Jump to content


Photo

Search Engine Script


  • Please log in to reply
2 replies to this topic

#1 Mark82

Mark82
  • New Members
  • Pip
  • Newbie
  • 5 posts

Posted 09 August 2006 - 11:00 AM

Hello

I have a search engine script, which has used paging, and this works fine.  What I need is a snippet of code to display a message such as "no results found" if the query returns nothing.  I have tried several things, such as if's and using variables, but none of them work completly.  I am pretty OK with php but this has got me stuck.

is there a very easy way to check is the '$row' is empty after doing the query (sample code below):

$row=mysql_fetch_assoc($result);

I am sorry fi this is confusing, if it is, please say! Im desperate for help!

Thanks

Mark

#2 Orio

Orio
  • Staff Alumni
  • Advanced Member
  • 2,491 posts

Posted 09 August 2006 - 11:04 AM

What about:

<?php
if(mysql_num_rows($result)==0){
echo("No results");
}
else{
//echo results here
}
?>

Orio.
Think you're smarty?

(Gone until 20 to November)

#3 Mark82

Mark82
  • New Members
  • Pip
  • Newbie
  • 5 posts

Posted 09 August 2006 - 11:07 AM

thanks, strangley enough I have just found that on another forum too! I guess help is like buses, wait forever and two come at once.

thanks very much, that works fine.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users