[PHP-DB] Where Error
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
Re: [PHP-DB] Where Error
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
Re: [PHP-DB] Where Error
$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 PROTECTED] 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
Re: [PHP-DB] Where Error
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
order by $sort_field $sort_order;
**
On Sat, 29 May 2004 07:50:52 -0700, Daniel Clark [EMAIL PROTECTED] 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
