How to display "NO RESULT" if no data is found?

[kalasag]

hi!

Im working on a php page that will retrieve data into a database.

My problem is I want to display the "NO RESULTS FOUND" if the search word is not in the database, or no data is retrieve..

btw im using adodb..

heres my simple code..

$search = $_POST['searchbox'];
$sql = "SELECT main_entry,part_of_speech,synonyms,antonyms FROM thesauri where synonyms LIKE '%$search%'";
$rs = &$db->Execute($sql);
if (!$rs) {
print $db->ErrorMsg(); // Displays the error message if no results could be returned
}

thanks!

[zabmilenko]

I believe it's:

if ($rs->numRows() == 0)
{
    // Blah Blah
}

[kalasag]

zabmilenko your the man!hehe...thanks for quick respond

Yeah its working..thanks!