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@xxxxxxxxxx> 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
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
