Re: It only prints lines that beggin with a number? I'm on a deadline!
| From: | Godzilla | Date: | Fri, 15 Nov 2002 23:53:16 +0000 |
| Subject: | Re: It only prints lines that beggin with a number? I'm on a deadline! | ||
| References: | 1 2 3 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-124668@lists.php.net to get a copy of this message | ||
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" <holmes072000@charter.net> 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...
>