Re: bool type (between MySQL and PHP)
| From: | Daniel Brown | Date: | Tue, 25 Jan 2011 22:08:36 +0000 |
| Subject: | Re: bool type (between MySQL and PHP) | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-47652@lists.php.net to get a copy of this message | ||
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.
--
</Daniel P. Brown>
Network Infrastructure Manager
Documentation, Webmaster Teams
http://www.php.net/