[PHP-DB] Re: "Where" Error

[Frank M Flynn]

You don't say which DBMS your using or what the specific error message 
(sometimes they are helpful - although sometimes useless)  is but I 
think what your after is:

  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:

Like this:
  $myQuery = "select * from foo where status = 'i' ";
Not this:
  $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?
Ken