I'd like a column to have a value of either true or false but i'm thinking there is no such thing, no such data type (....and why not?!)
if there isn't what's a good alternative?, tiny int?, or i'll just use text reading true or false,
Read the manual.
jedaisoul;1213789 wrote:Read the manual.
This question is in regard to SQL, not PHP - I don't know why you posted a link to the PHP manual.
Fortunately, there is a boolean data type in MySQL, it's a numeric data type. Basically a non zero value is true and 0 is false. Check the MySQL documentation: http://dev.mysql.com/doc/refman/5.5/en/numeric-type-overview.html
Perfect, thank you