[SOLVED] When empty set results from SELECT query?

[robert.juric]

$query = "SELECT * FROM soft WHERE name = '$search'";
if ($result = $mysqli->query($query)) {
while ($row = $result->fetch_row()) {
	printf ("ID: %s<br> Name: %s<br> Path: %s<br> Comment: %s<br>\n", $row[0], $row[1], $row[2], $row[3]);
}
printf ("End of results.<br>\n");
$result->close();
}

 

My problem is that if there is no entry matching the search, the select query still returns a true value even if it's an empty set. How can I tell if the query returns an empty set (no matches) vs the normal array?

[obsidian]

You need to count your records instead of simply checking to see whether or not your query is TRUE:

<?php
$query = "SELECT * FROM soft WHERE name = '$search'";
if ($result = mysql_query($query)) 
  {
  if (mysql_num_rows($result) > 0)
  {
    // Do your loop since you have records returned
  }
}
?>

[robert.juric]

Perfect. Thank you!