Please Help - 2 Connections??

[eukhost]

Hello,

How can i get the following code to work please:

$result =mysql_query("SELECT FROM products WHERE category='$category' ORDER BY name AND price");
$result =mysql_query("SELECT FROM merchants WHERE id='$merchant'");
if($suspend == "yes") {
print("");
}else{

Thank you

[Wave]

seem like this is valid code.
where is the problem?

[eukhost]

well under that code even though the merchant is suspended it still displays there products

[stolzyboy]

is $suspend set equal to something from a the database, if not you can say something like this:

$query = "select * from table";
$result = mysql_query($result) or die ("could not select");

while($row = mysql_fetch_array($result)) 
{
     $suspend = $row['fieldname'];

 if ($suspend == "yes")
 {
      echo "suspend";
 }
 else
 {
      echo "no suspend";
 }
}

[Butthead]

Is the problem just that you forgot to echo the output? Seems valid to me...