Re: "Where" Error
| From: | kc68 at cornell dot edu | Date: | Sat, 29 May 2004 14:58:26 +0000 |
| Subject: | Re: "Where" Error | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-34580@lists.php.net to get a copy of this message | ||
$get_data_query = "select state, cd, representative, status, party, netreceipts,
individualcontributions, paccommcontributions, candidatesupport, netdisbursements
from fec33104
where status = i
order by $sort_field $sort_order";
**********
On Sat, 29 May 2004 07:50:52 -0700, Daniel Clark <dclark@nwlink.com> wrote:
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