Topic: Check if there are any results from mysql

[vicodin]

What i want to do is check if anything has retrieved from mysql or not. Any help would be appreciated.

Current code:

Code: [Select]

mysql_select_db("mediapil_mkmdata") or die(mysql_error());
$query = "SELECT * FROM products WHERE proid = $prodid";
$result = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($result);
echo '



[rhodesa]

like this?

Code: [Select]

<?php
mysql_select_db("mediapil_mkmdata") or die(mysql_error());
$query = "SELECT * FROM products WHERE proid = $prodid";
$result = mysql_query($query) or die(mysql_error());
if(mysql_num_rows($result)){
  while($row = mysql_fetch_array($result)){

  }
}else{
  echo "No rows found";
}
?>

[vicodin]

No its only looking for one thing. If it doesnt find it then i want ti to echo something and if it finds it then echo the product.

[p2grace]

Count the results before continuing

Code: [Select]

<?php
$query = "SELECT * FROM products WHERE proid = $prodid";
$result = mysql_query($query) or die(mysql_error());
$num = mysql_num_rows($result);
if($num > 0){ // results found
}else{ // no results found
}
?>


[vicodin]

Thank you worked perfect!