where status = 'i'
Notice that you must quote the values for string or characters. Try this on your DBMS's command line (no web or PHP) this might give you better error messages and it takes all of the other variables out of it. Then be careful when you build your query to use different quotes:
$myQuery = "select * from foo where status = 'i' ";
$myQuery = "select * from foo where status = "i"";
One last note - if you build your query in different strings be sure to leave white space between the strings:
Like this: $myQuery = "select * from foo "; $myQuery = $myQuery =" where status = 'i' "; $myQuery = $myQuery =" order by ... ";
Good Luck, Frank
On May 29, 2004, at 7:36 AM, [EMAIL PROTECTED] wrote:
From: [EMAIL PROTECTED] Date: May 29, 2004 7:35:40 AM PDT To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> Subject: "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?