Daniel Brown wrote:
On Tue, Jan 25, 2011 at 17:05, Donovan Brooke<li...@euca.us>  wrote:

What is the best PHP practice when using bools with
MySQL? Save 1's and 0's instead of true/false?

     You could either do an INT(1) DEFAULT 0 or an ENUM('Y','N') to
make it easier on yourself.

Thanks Dan,

I think the error would still persist using DEFAULT.. because as mentioned, I don't think MySQL likes:

UPDATE tablename SET vbool=

..which is not great news for me since I'd like to avoid having to redo
all my bool's in PHP (input checking, updates, add's etc.. ;-) ENUM would require that route as well I guess.

I suppose I could instead place a string value of "0" in the query statement, if bool false, perhaps?

I'll try that.


D Brooke

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to