Re: "Where" Error
| From: | Daniel Clark | Date: | Sat, 29 May 2004 14:50:52 +0000 |
| Subject: | Re: "Where" Error | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-34579@lists.php.net to get a copy of this message | ||
Can you post the code?
Something like:
WHERE status IN ('i', 'c', 'o') ;
>>This should be ultimately simple; it just doesn't work. I want to limit
>>display to rows from a single table in which the status column contains
>>i. Only options are i, c, o. After the select line I have "where status
>>= i" (no quote marks). I get an error message to the "while" line that
>>calls the table.
>>
>>When I limit by another column "where netreceipts > 500" I get the desired
>>result. When I change it to "where netreceipts = 500" (and there is a
>>500) I get the error message above.
>>
>>What's the solution?
>>
>>Ken