Re: Search Results - Next 10 records

Thanks very much Marcus. It worked like a charm. Dennis On Mon, 3 Sep 2001 14:02:07 +0200, m.tobias@uptrade.de (Marcus Tobias) wrote: > Hi Dennis! > > You can add the parameter "LIMIT" to your SQL query. > Syntax: LIMIT $start_record,$record_count > Example: $query_string = "select * from $table where keywords like > '%$keyword%' limit 5,3"; > This will return 3 records started with the 5. found record. > > The startrecord has to increase on next page. > Store the current startrecord in the form and send it to the next page. > > bye Marcus > > > "Dennis" <dennisb@unix.asb.com> schrieb im Newsbeitrag > news:20010903014505.81682.qmail@pb1.pair.com... > > 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 > > { > > global $start_record; > > if ( !isset( $start_record ) ) $start_record = 0; > > > $query_string = "select * from $table where keywords like > > '%$keyword%'"; > > $query_string = "select * from $table where keywords like '%$keyword%' limit > $start_record,10"; > > > > $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='text' NAME='start_record' > VALUE='$start_record+10'>"); > > > print ("<INPUT TYPE='submit' > > VALUE='Next'></FORM>"); > > print $count; > > print("</TABLE>\n"); > > } > > > > > > ?> > > > >