Hi shawn.
� think the problem is in your var. You got smallcaps and big caps (query
and Query)
Tommy
----- Original Message -----
From: "Shawn" <[EMAIL PROTECTED]>
To: "FreeTrade" <[EMAIL PROTECTED]>
Sent: Tuesday, September 12, 2000 9:24 AM
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]
