Re: [PHP-DB] "Where" Error

2004-05-29 Thread Daniel Clark
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 s

Re: [PHP-DB] "Where" Error

2004-05-29 Thread kc68
$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

Re: [PHP-DB] "Where" Error

2004-05-29 Thread Daniel Clark
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 "