RE: [PHP-WIN] Query Syntax - WHERE fieldname1='fieldvalue1' ANDfieldname2='fieldvalue2'

I think you have an "operator\precedence" issue. Try $query = "SELECT $field_name FROM classifieds WHERE ($field_name1 = '$field_value1') AND ($field_name2 ='$field_value2') "; This will stop you from eventually ANDing the wrong pair... -----Original Message----- From: Mark Abrams [mailto:mark@hospitalsystemsgroup.com] Sent: terça-feira, 22 de Maio de 2007 16:07 To: php-windows@lists.php.net Subject: [PHP-WIN] Query Syntax - WHERE fieldname1='fieldvalue1' ANDfieldname2='fieldvalue2' Query Syntax - I have a syntax error when I am using an AND in the WHERE clause for a double field=value restriction #1 RUNS OK $query = "SELECT $field_name FROM classifieds WHERE $field_name = '$field_value'"; $result = mysql_query($query) or die(mysql_error()); #2 FAILS $query = "SELECT $field_name FROM classifieds WHERE $field_name1 = '$field_value1' AND $field_name2 ='$field_value2'"; $result = mysql_query($query) or die(mysql_error()); dies with the following message: Warning: mysql_query() [http://www.mysql.com/doc]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM classifieds WHERE trans_type = 'For Sale' AND category ='Boats'' at line 1 in C:\apache2triad\htdocs\ Background: I call a function and pass a $field_name = $field_value pair. This works OK. When I add a second field_name = $field_value pair the query dies. Data excerpt from TABLE classifieds: trans_type = Free category = Books Also, Can anyone recommend a good book on mySQL / php? I could not find a good example of my problem in the online manual http://www.mysql.com/doc. TIA Mark -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php