Mark82 Posted August 9, 2006 Share Posted August 9, 2006 HelloI 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!ThanksMark Quote Link to comment Share on other sites More sharing options...
Orio Posted August 9, 2006 Share Posted August 9, 2006 What about:[code]<?phpif(mysql_num_rows($result)==0){echo("No results");}else{//echo results here}?>[/code]Orio. Quote Link to comment Share on other sites More sharing options...
Mark82 Posted August 9, 2006 Author Share Posted August 9, 2006 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.