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
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
$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 [EMAIL
SELECT ..
WHERE status IN ('i', 'c', 'o') ;
ORDER BY $sort_field $sort_order;
$get_data_query = select state, cd, representative, status, party,
netreceipts,
individualcontributions, paccommcontributions, candidatesupport,
netdisbursements
from fec33104
where status = i
