Search Results - Next 10 records
| From: | (Dennis) | Date: | Mon, 03 Sep 2001 01:45:05 +0000 |
| Subject: | Search Results - Next 10 records | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-12103@lists.php.net to get a copy of this message | ||
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");
}
?>