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

2007-05-22 Thread tg-php
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'

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

2007-05-22 Thread tg-php
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,

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

2007-05-22 Thread Mark Abrams
ç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

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

2007-05-22 Thread Luis Moreira (ESI-GSQP)
-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