how to display "NO RECORDS FOUND" by using following code...!

[asad_black]

I am new in PHP and this is my search code noW i want to display "NO RECORDS FOUND" when no record match with search string..!

 

this is my code:

 

<?php

$var = @$_GET['q'] ;

$trimmed = trim($var);

// database connection info

$conn = mysql_connect('localhost','asad','asad') or trigger_error("SQL", E_USER_ERROR);

$db = mysql_select_db('asad',$conn) or trigger_error("SQL", E_USER_ERROR);

 

// find out how many rows are in the table

$sql = "SELECT COUNT(*) FROM links where kw like \"%$trimmed%\"";

$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);

$r = mysql_fetch_row($result);

$numrows = $r[0];

 

// number of rows to show per page

$rowsperpage = 3;

// find out total pages

$totalpages = ceil($numrows / $rowsperpage);

 

// get the current page or set a default

if (isset($_GET['currentpage']) && is_numeric($_GET['currentpage'])) {

  // cast var as int

  $currentpage = (int) $_GET['currentpage'];

} else {

  // default page num

  $currentpage = 1;

} // end if

 

// if current page is greater than total pages...

if ($currentpage > $totalpages) {

  // set current page to last page

  $currentpage = $totalpages;

} // end if

// if current page is less than first page...

if ($currentpage < 1) {

  // set current page to first page

  $currentpage = 1;

} // end if

 

// the offset of the list, based on current page

$offset = ($currentpage - 1) * $rowsperpage;

 

// get the info from the db

$sql = "SELECT * FROM links where kw like \"%$trimmed%\"

LIMIT $offset, $rowsperpage";

$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);

 

 

    echo "<table border='0' cellpadding='3' cellspacing='3' width='50%'>";

 

// while there are rows to be fetched...

while ($list = mysql_fetch_assoc($result)) {

  // echo data

 

    {

  echo "<tr>";

// echo "<td valign=top>". $list['text'];

echo "<td rowspan=2 valign=top><a href=\"idpage.php?id=" . $list["id"] . "\">

<img src=\"" . $list["image"] . "\" height='80' width='80' border=0 \"" . $list["text"] . "\"></a></td>";

echo "<td valign=top class=headingofvideotext height='29'><a href=\"idpage.php?id=" . $list["id"] . "\">". $list['text'];

echo "</td>";

echo "</tr>";

 

echo "<tr class=style28>";

 

  echo "<td valign=top>" . $list['des'] . "</td>";

  echo "</tr>";

  }

 

  }

 

echo "</td>";

    echo "</tr>";

  echo "</table>";

/******  build the pagination links ******/

// range of num links to show

$range = 3;

 

// if not on page 1, don't show back links

if ($currentpage > 1) {

  // show << link to go back to page 1

  echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=1&q=$var'>First</a> ";

  // get previous page num

  $prevpage = $currentpage - 1;

  // show < link to go back to 1 page

  echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$prevpage&q=$var'>Previous</a> ";

} // end if

 

// loop to show links to range of pages around current page

for ($x = ($currentpage - $range); $x < (($currentpage + $range) + 1); $x++) {

  // if it's a valid page number...

  if (($x > 0) && ($x <= $totalpages)) {

      // if we're on current page...

      if ($x == $currentpage) {

        // 'highlight' it but don't make a link

        echo " [<b>$x</b>] ";

      // if not current page...

      } else {

        // make it a link

echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$x&q=$var'>$x</a> ";

      } // end else

  } // end if

} // end for

 

// if not on last page, show forward and last page links

if ($currentpage != $totalpages) {

  // get next page

  $nextpage = $currentpage + 1;

    // echo forward link for next page

  echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$nextpage&q=$var'>Next</a> ";

  // echo forward link for lastpage

  echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$totalpages&q=$var'>Last</a> ";

} // end if

/****** end build pagination links ******/

?>

[Silverado_NL]

something like this should do, although you might need to change a bit more code.

echo "<table border='0' cellpadding='3' cellspacing='3' width='50%'>";

if($numrows == 0){
echo "NO RECORDS FOUND";
}

// while there are rows to be fetched...
while ($list = mysql_fetch_assoc($result)) {
   // echo data
   
    {

[asad_black]

its work but it shows also paging in the last of the page