Use a tinyint field in mysql, (which is what bool gets translated to I think)
and you'll get a number back, 0 = false, 1 = true, and you can:
if ($fieldname) {
do true item;
}
if (!$fieldname) {
do false item;
}
This works for me, I've done before quite a bit in the past.
-Micah
On Saturday 07 January 2006 6:45 am, Larry Bradley wrote:
> Greetings:
>
> I'm new to PHP, although I've been a programmer all my life. I had been
> doing a bit of web database work with VB Script and ASP and mySQL, and then
> decided to try PHP. I've run into a couple of things that bother me.
>
> I have boolean fields (i.e. bit(1)) in the mySQL database. When I retrieve
> data from the mySQL server into an array or an object, it seems as if all
> the data fields are returned as characters. For most data types this does
> not matter, since PHP will handle them properly. This an integer 46 being
> retrieved as a character '46' is OK.
>
> However, the boolean is a curse, as it comes back as a character containing
> hex 00 or hex 01, and I have to use a test such as:
>
> if (ord(IsAMember) == 0) ...
>
> I can't just treat it as a boolean.
>
> I have got around the problem by using a construct such as:
>
> select if(IsAMember,1,0) as IsAMember
>
> in the SQL select, but this is a bit of a pain.
>
> Any thoughts?
>
> Thanks
>
> Larry Bradley
> Orleans (Ottawa), Ontario, CANADA
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
