[PHP-DB] Search Results - Next 10 records

[Dennis]

Trying to figure out how to limit search results to say 10 records and produce 
a button to show the next 10.  Do you use PHP to do the logic, or should I make 
another table column for a temporary count?  This is what I'm up to so far...

Thanks in advance


function show_all($table, $keyword=0)// initialize to zero
{

  $query_string = "select * from $table where keywords like '%$keyword%'";
  $entire_table = mysql_query($query_string);
  $count = 0;
  print("<TABLE BORDER=1 width=700>\n");
    while ($cols_rows = mysql_fetch_array($entire_table)) {
     $count++;
      if ($count < 4){
        print("<tr>");
        print("<td bgcolor=azure>");
        print("<font size=3>");
        print ($cols_rows['num']);
        print("</td><td bgcolor=azure>");
        print("<font size=2>");
        print ($cols_rows['site_name']);
        print("</td><td bgcolor=azure>");
        print("<font size=2>");
        print ($cols_rows['keywords']);
        print("</td><td bgcolor=azure>");
        print("<font size=2>");
        print ($cols_rows['url']);
        print("<P></td>");
      }  
    
    if ($count > 3){
        print("<tr>");
        print("<td bgcolor=silver>");
        print("<font size=3>");
        print ($cols_rows['num']);
        print("</td><td bgcolor=silver>");
        print("<font size=2>");
        print ($cols_rows['site_name']);
        print("</td><td bgcolor=silver>");
        print("<font size=2>");
        print ($cols_rows['keywords']);
        print("</td><td bgcolor=silver>");
        print("<font size=2>");
        print ($cols_rows['url']);
        print("</td>");
        $count++;
      }
  }    

print ("<FORM METHOD='POST' ACTION='search1.php'>");
print ("<INPUT TYPE='submit' VALUE='Next'></FORM>");
      print $count;
    print("</TABLE>\n");
}

    
?>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]