Try this:
$query = "SELECT $field_name
FROM classifieds
WHERE $field_name1 = '".$field_value1."'
AND $field_name2 = '".$field_value2."'";
Also, check the data types - if $field_name1/2 is an int then you don't need
the single quotes.
Arno
-----Original Message-----
From: Mark Abrams [mailto:mark@xxxxxxxxxxxxxxxxxxxxxxxx]
Sent: 22 May 2007 05:07
To: php-windows@xxxxxxxxxxxxx
Subject: Query Syntax - WHERE fieldname1='fieldvalue1' AND
fieldname2='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
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
