How 2 know if keyword search isn't existing?

[Phutie]

Hi,

for example I have this script:

if ($KeyWords != "&quot
{
$my_array = explode(" ", $KeyWords);
$count = count($my_array);

if ($count == 1)
{
$sql = ("SELECT BanID from KeyWords WHERE Kwords LIKE '%$my_array[0]%'"
$result = mysql_query($sql);

How will I know if the keyword I entered is not present on the KeyWords table? I need to display "Not Found" else if it is found on the table it should say "Found"

Please help, thanks!

Phutie
}

 

[devnull22]

Hi Phutie,

Just use the mysql_num_rows() on the result.
ie. $found_num = mysql_num_rows($result);

mysql_num_rows() returns the number of rows in a
result set.


cheers