Re: It only prints lines that beggin with a number? I'm on a deadline!
| From: | 1LT John W. Holmes | Date: | Fri, 15 Nov 2002 13:48:39 +0000 |
| Subject: | Re: It only prints lines that beggin with a number? I'm on a deadline! | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-124598@lists.php.net to get a copy of this message | ||
> >$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...