help needed on a query

[anuj_sharma]

hey guys,
I have made a database using mysql and php. I have also put in a search option. But what i want is that if the item which is being searched for is not in the databse it should return "Database Not Found". I am not able to execute this.
Please help me on this.

[architact]

hey guys,
I have made a database using mysql and php. I have also put in a search option. But what i want is that if the item which is being searched for is not in the databse it should return "Database Not Found". I am not able to execute this.
Please help me on this.

i assume the name of variables to be dat and data

$dat = mysql_query("SELECT * ........."); // the query you used
if(!$data = mysql_fetch_array($dat)){
echo "No results found";
}

[anuj_sharma]

IT WORKED!!!!!!!!!!!!!
Thanks a lot...