Dheeraj Verma (WD)

Can anyone tell me that how to add "There is no results found" function in my php search script that is ------------------------> <?php mysql_connect ("localhost", "root","pswd") or die (mysql_error()); //This connects the file to your database. Change the "database-username & database-password" to the one you've setup already. mysql_select_db ("freshohn_fresh"); //This selects the specific database you want your results to come from (as you may have more than one database). Change "test" to your database name. $keyword = $_GET['keyword']; //This grabs everything your user has put into the search field (which has been labelled as "search" earlier from the .HTML page). $sql = mysql_query("select * from jobs where location like '%$keyword%' or title like '%$keyword%' and status=1 order by id desc limit 0,10"); //Assigns a variable called "$sql" to the result of your "search". And the use of LIKE allows you to only have to type in (for example if you were searching a name).. Jord instead of the full Jordan. while ($row = mysql_fetch_array($sql)){ //We start a "while" loop so you can output multiple results. Also we assign an array "$row" to each database table column you would like to display. Below is an example if you wanted multiple tables to be searched through and displayed if a match is found.

Please tell me that how to add next previous function with this search script this is working correctly. Thanks Jordan