[SOLVED] ending a query with the correct syntax problem

[glennn.php]

i'm using several variables in a query:

 

$result = mysql_query("SELECT fice FROM characteristics WHERE offering IN ($offering_sql) AND ".$public_private_sql." AND ".$twofour_sql."");

 

but where the last condition in the query is a variable, i'm getting errors no matter how i close it:

 

AND ".$twofour_sql."");

AND ".$twofour_sql");

etc...

 

can someone kindly show me how to close this?

 

thanks so much.

GN

[Minase]

give the content of the 2 variables and what error you recive

[revraz]

$result = mysql_query("SELECT fice FROM characteristics WHERE offering IN ('$offering_sql') AND '$public_private_sql' AND '$twofour_sql'");

[Psycho]

You should create your queries as string variables so you can echo them to the page when they fail for debugging purposes! And put an on die() handler on there to see what the error is.

 

$query = "SELECT fice
         FROM characteristics
         WHERE offering IN ($offering_sql)
           AND $public_private_sql
           AND $twofour_sql";
$result = mysql_query($query) or die("Error:<br />".mysql_error()."<br />Query:<br />$query");

[glennn.php]

thanks all of you - i'm still sorting through all these conditions (there are about 10) while configure them. but your help is appreciated and solved the problem.