wn column '' in 'field list'
-Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 22, 2007 10:57 AM
To: php-windows@lists.php.net
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-WIN] Query Syntax - WHERE
fieldname1='fieldvalue1'
t;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:[EMAIL PROTECTED]
Sent: ter~a-feira,
ç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
-Original Message-
From: Mark Abrams [mailto:[EMAIL PROTECTED]
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 a