Shawn,
If you have copied and pasted the code below from your code the problem is
the var name $Query. It should be lower case.
Kathleen
::-----Original Message-----
::From: [EMAIL PROTECTED]
::[mailto:[EMAIL PROTECTED]]On Behalf Of Shawn
::Sent: Tuesday, September 12, 2000 12:24 PM
::To: FreeTrade
::Subject: [FreeTrade] Need help with query
::
::
:: Hello All;
::
::I am hoping that someone can help me out. I am trying to use the folloing
::query in my store and it does not work. As far as I can tell it
::is correct
::and wneh I use it on MySQLAdmin it works fine as well as working fine with
::another MySQL frontend program. All the data display but it is as if the
::WHERE ProvinceState line is being ignored since nothing is filtered out.
::What am I doing wrong?
::Shawn
::
::
::$query = "SELECT ID, Name, Address, Phone, WebSite, Email, Country,
::ProvinceState ";
::$query .= "FROM retailer ";
::$Query .= "WHERE ProvinceState = 'Alabama' ";
::$query .= "ORDER BY Name";
::
::
::
::------------------------------------------------------------
::To subscribe: [EMAIL PROTECTED]
::To unsubscribe: [EMAIL PROTECTED]
::Site: http://www.working-dogs.com/freetrade/
::Problems?: [EMAIL PROTECTED]
::
::
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
