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]