"SELECT FROM classifieds WHERE trans_type ="For Sale"" SELECT what? $field_name looks to null or blank... -----Original Message----- From: Mark Abrams [mailto:mark@xxxxxxxxxxxxxxxxxxxxxxxx] Sent: Tuesday, May 22, 2007 12:48 PM To: php-windows@xxxxxxxxxxxxx Subject: query strings & printouts Re: [PHP-WIN] Query Syntax - WHERE fieldname1='fieldvalue1' AND fieldname2='fieldvalue2' Here are the query strings & printouts: This works OK $query = "SELECT $field_name FROM classifieds WHERE $field_name1 = '$field_value1' AND $field_name2 = '$field_value2'"; SELECT FROM classifieds WHERE trans_type ="For Sale" FAILS #1 $query = "SELECT $field_name FROM classifieds WHERE $field_name1 = '$field_value1' AND $field_name2 = '$field_value2'"; SELECT FROM classifieds WHERE trans_type = 'For Sale' AND category = 'Books' 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 trans_type = 'For Sale'' at line 1 in C:\apache2triad\htdocs\sunlakes\test3.php on line 82 #2 $query = "SELECT $field_name FROM classifieds WHERE ($field_name1 = '".$field_value1."') AND ($field_name2 = '".$field_value2."')"; SELECT FROM classifieds WHERE (trans_type = 'For Sale') AND (category = 'Books') 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 (tr' at line 2 in C:\apache2triad\htdocs\sunlakes\test3.php on line 85 "Stut" <stuttle@xxxxxxxxx> wrote in message news:46531BBA.5010207@xxxxxxxxxxxx > Mark Abrams wrote: >> #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\ > > Have you tried printing out $query to see exactly what you're sending? > Seems like a logical first step to me. Something about it is clearly > wrong, and I'm guess it's an empty or wrong $field_name value. > > -Stut -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
