Query with variable

[ongsoowee]

I try to write a query inside Dreamweaver but it kept returning me empty results. However I am sure this query should return me a result (It was successful when I replace the two variable '$result_1' and '$pattern_id' with the actual value.) Is it possible to use query with variables? Where did I go wrong?

 

 

$sql_2= mysql_query("SELECT body_id FROM body WHERE pattern_id = '$pattern_id' AND bodyColorset_id = '$result_1'");

$num_rows = mysql_num_rows($sql_2);

if($num_rows == 0){

echo "error in body set......";

}

else{

while($row=mysql_fetch_array($sql_2)){

$result_2 = $row["body_id"];

}#END OF WHILE LOOP

}#END OF IF_ELSE LOOP

 

Thank you for your attention.