Re: [PHP] It only prints lines that beggin with a number? I'm on a deadline!

[Godzilla]

Thanks so much guys, that worked perfectly. I do ok with php but am still on
the bumpy part of the road with SQL queries.

Thanks again!

Regards,
Tim

"1lt John W. Holmes" <[EMAIL PROTECTED]> wrote in message
news:00da01c28cad$b9a90d50$a629089b@;TBHHCCDR...
> > >$result = mysql_query ("SELECT * FROM `data` WHERE categories");
>
> Where categories is what?? You don't have any comparison...
>
> What it's doing is evaluating the column as true or false. Any integer
> column > 0 will evaluate to true, so that row will be returned. "1A" will
be
> converted to 1, so it'll be returned as true. "CD" will be converted to
> zero, so that row will not be returned...
>
> ---John Holmes...
>



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

Re: [PHP] It only prints lines that beggin with a number? I'm on a deadline!

[1LT John W. Holmes]

> >$result = mysql_query ("SELECT * FROM `data` WHERE categories");

Where categories is what?? You don't have any comparison...

What it's doing is evaluating the column as true or false. Any integer
column > 0 will evaluate to true, so that row will be returned. "1A" will be
converted to 1, so it'll be returned as true. "CD" will be converted to
zero, so that row will not be returned...

---John Holmes...


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