multiple str_replace

EcLip_e

i'm using 4 str_replace's to get my sql statement the way that i want it. however each str_replace is reading from the first "str_results". i want it to update in succession, for example, the 2nd str_replace is replacing the stuff from the first str_replace, and the 3rd str_replace is replacing the stuff from the 2nd str_replace. any ideas on how i can do this?

here is my code:

	$sql_results = "SELECT * FROM physicians WHERE specialty = '" . $_GET['specialty'] . "' AND clinic = '" . $_GET['clinic'] . "' AND city = '" . $_GET['city'] . "' ORDER BY id DESC";

$sql_results = str_replace("specialty = 'queryall'", "", $sql_results);
$sql_results = str_replace("clinic = 'queryall'", "", $sql_results);
$sql_results = str_replace("city = 'queryall'", "", $sql_results);
$sql_results = str_replace("AND ORDER", "ORDER", $sql_results);

echo $sql_results;

thanks in advance 🙂

TheDefender

Concatanate:

$sql_results = "SELECT * FROM physicians WHERE specialty = '" . $_GET['specialty'] . "' AND clinic = '" . $_GET['clinic'] . "' AND city = '" . $_GET['city'] . "' ORDER BY id DESC"; 

$sql_results .= str_replace("specialty = 'queryall'", "", $sql_results); 
$sql_results .= str_replace("clinic = 'queryall'", "", $sql_results); 
$sql_results .= str_replace("city = 'queryall'", "", $sql_results); 
$sql_results .= str_replace("AND ORDER", "ORDER", $sql_results); 

echo $sql_results;

Note the periods before the subsequent equal signs...

EcLip_e

thanks for you post defender .. however i don't want to link them alltogether. here is my problem; for example, if clinic = queryall and city = queryall then that gives me two AND's in my sql statement, and it fails. but, if only city = queryall then the sql statement reads AND ORDER BY, which also fails. so i'm trying to use a series of str_replaces to fix this AND problem.

i'm so confused that i can't even explain myself 😉

there's probably a much easier, and better way of doin this, but i'm not sure how.

TheDefender

Nevermind, there are still problems, and my brain hurts from a different issue I have been working on ;-)

The easier way would probably be to just use if/then statements to concatenate the $sql_results based on the GET values... It's easier to add things to it, than to take it away, especially when you are dealing with ANDs and ORs.