You are here: Re: PHP, MySQL and BIT field « PHP Programming Language « IT news, forums, messages
Re: PHP, MySQL and BIT field

Posted by Jeff North on 09/20/06 01:40

On Tue, 19 Sep 2006 11:32:08 +0200, in comp.lang.php "Vojta"
<ryvo@centrum.cz>
<eeodev$9b0$1@ns.felk.cvut.cz> wrote:

>| Hello Jeff, thank you for reply. I tried following expressions, they are
>| allways evalueted:
>|
>| ($registered == 1) as false
>| ($registered == '1') as false
>| ($registered == '0001') as false

Huh??? False = 0 whereas True != 0

>| ((boolean)$registered) as true
>| (!is_null($registered)) as true

This would return $registered=0 as true.

>| (integer)$registered prints allways 0
>|
>| Please, how exactly should I work with $register variable?
>|
>| Vojta

how about:
if( !is_null($registered) )
{
if( $registered > 0 )
//--- do true stuff
else
//--- do false stuff
}

>| "Jeff North" <jnorthau@yahoo.com.au> píse v diskusním príspevku
>| news:7hetg2lvqqjk111k6j9snuvi7djkcmbsr5@4ax.com...
>| > On Mon, 18 Sep 2006 15:42:55 +0200, in comp.lang.php "Vojta"
>| > <ryvo@centrum.cz>
>| > <eem7p4$24u1$1@ns.felk.cvut.cz> wrote:
>| >
>| >>| Please can somebody give me an advice?
>| >>|
>| >>| my MySQL table contains bit field
>| >>|
>| >>| Registered BIT(1) NOT NULL DEFAULT 0
>| >>|
>| >>| I read records using
>| >>|
>| >>| $result = mysql_query('SELECT * FROM MyUsers');
>| >>| $row = mysql_fetch_array($result, MYSQL_ASSOC);
>| >>| $registered = $row['Registered'];
>| >>|
>| >>| Command "echo $registered;" shows nothing or rectangles depending on the
>| >>| value, it's ok. But I do not know how to use it in IF statements or so.
>| >>| Whatever I try does not work. How can I work with such values in PHP?
>| >>|
>| >>| Thank you in advance! Vojta
>| >>|
>| >
>| > The value is either 0000 or 0001 - not to be confused with ascii(0) or
>| > ascii(1).
>| > ---------------------------------------------------------------
>| > jnorthau@yourpantsyahoo.com.au : Remove your pants to reply
>| > ---------------------------------------------------------------
>|
---------------------------------------------------------------
jnorthau@yourpantsyahoo.com.au : Remove your pants to reply
---------------------------------------------------------------

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация