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 Link to comment https://forums.phpfreaks.com/topic/16999-search-engine-script/ 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. Link to comment https://forums.phpfreaks.com/topic/16999-search-engine-script/#findComment-71693 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. Link to comment https://forums.phpfreaks.com/topic/16999-search-engine-script/#findComment-71696 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.