Re: [PHP-WIN] query strings & printouts Re: [PHP-WIN] Query Syntax - WHERE fieldname1='fieldvalue1' AND fieldname2='fieldvalue2'

2007-05-22 Thread Stut
Mark Abrams wrote: 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 Of course it does. You want

RE: [PHP-WIN] query strings & printouts Re: [PHP-WIN] Query Syntax - WHERE fieldname1='fieldvalue1' AND fieldname2='fieldvalue2'

2007-05-22 Thread Bill Bolte
rings & 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' AN

[PHP-WIN] query strings & printouts Re: [PHP-WIN] Query Syntax - WHERE fieldname1='fieldvalue1' AND fieldname2='fieldvalue2'

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

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

2007-05-22 Thread James Crow
Often the error in the SQL statement is just before the part echoed in the error message. Check your $field_name to see if it has any special characters or a semicolon in it. Maybe something like: or this: echo "\$query = $query\n"; Thanks, James On Tuesday 22 May 2007 11:07, Mark Abra

[PHP-WIN] This did not work. Re: [PHP-WIN] Query Syntax - WHERE fieldname1='fieldvalue1' AND fieldname2='fieldvalue2'

2007-05-22 Thread Mark Abrams
t; > Arno > > > > -----Original Message----- > From: Mark Abrams [mailto:[EMAIL PROTECTED] > Sent: 22 May 2007 05:07 > To: php-windows@lists.php.net > Subject: [PHP-WIN] Query Syntax - WHERE fieldname1='fieldvalue1' AND > fieldname2='fieldvalue2' >

[PHP-WIN] Failed Re: [PHP-WIN] Query Syntax - WHERE fieldname1='fieldvalue1' AND fieldname2='fieldvalue2'

2007-05-22 Thread Mark Abrams
gt; > > > -----Original Message- > From: Mark Abrams [mailto:[EMAIL PROTECTED] > Sent: 22 May 2007 05:07 > To: php-windows@lists.php.net > Subject: [PHP-WIN] Query Syntax - WHERE fieldname1='fieldvalue1' AND > fieldname2='fieldvalue2' > > >

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

2007-05-22 Thread Stut
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 hav

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

2007-05-22 Thread Arno Kuhl
need the single quotes. Arno -Original Message- From: Mark Abrams [mailto:[EMAIL PROTECTED] Sent: 22 May 2007 05:07 To: php-windows@lists.php.net Subject: [PHP-WIN] Query Syntax - WHERE fieldname1='fieldvalue1' AND fieldname2='fieldvalue2' Query Syntax - I

[PHP-WIN] Query Syntax - WHERE fieldname1='fieldvalue1' AND fieldname2='fieldvalue2'

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