HELP NEEDED ON QUERY

[anuj576]

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.

$result=mysql_query("SELECT * FROM student_form WHERE roll='$roll_no'") or die(mysql_error());

What i want is that if the roll does not match with any entry in the database it shouls return "Database Not Found".

 

[r937]

this is a php question, please ask in that forum

r937.com | rudy.ca

 

[Kozusnik]

I believe that can be added to the db select.

mysql_connect('localhost',$user,$password);
@mysql_select_db($database) or die("Database Not Found");

Otherwise, you'll need to add an IF statement.

Mark

 

[vacunita]

The question and output is kind of misleading, since you want to search in the database it is by default found. Perhaps it be better to say "search term not found [red]in[/red] database"; Which is totally different beast than not finding the database


As for how to do it, well you need to check what results came back if any, and then you know whether it was found and can issue the statement. A simple If statement can do that.

but as was said this is a PHP question, and needs to be posted in the PHP forum here:
forum434



----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.