2 replies to this topic

[Scion]

Hi,

I am creating a MySQL Database Search, but I had a quick question. If I enter a search term that is not inside the MySQL Database, (such as random gibberish), will it come up with blank information, or will it give me an error?

Thanks,
Scion

Edited by Scion, 14 November 2007 - 07:53 PM.

[Archangel]

I'm sure there might be a better way to do it, but here's how I have done it before...

$data = mysql_query("blah blah");
$drows= mysql_num_rows($data);

if($drows >= 1){
//do stuff
}else{
//nothing was found
}

Edited by Archangel, 14 November 2007 - 11:05 PM.

[rc69]

The only way to find out is to try... it is a random fact of life.

But since i'm here, if no match is found, it will return 0 results, which is probably something you will have to handle in your code (like with what archangel provided).