Re: bool type (between MySQL and PHP)

Daniel Brown wrote:

On Tue, Jan 25, 2011 at 17:05, Donovan Brooke<lists@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. Donovan -- D Brooke