At 10:24 12/09/00 -0600, you wrote:
> 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";
space before = ?
build select statement in mysqladmin or whatever and when it works paste it
straight into $Query=""
Also you have got two vars, $Query and $query
>------------------------------------------------------------
>To subscribe: [EMAIL PROTECTED]
>To unsubscribe: [EMAIL PROTECTED]
>Site: http://www.working-dogs.com/freetrade/
>Problems?: [EMAIL PROTECTED]
bye
Bob Hutchinson
[EMAIL PROTECTED]
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
