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]
