Thanks very much Marcus. It worked like a charm.
Dennis
On Mon, 3 Sep 2001 14:02:07 +0200, [EMAIL PROTECTED] (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" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
> [EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> > 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");
> > }
> >
> >
> > ?>
> >
>
>
--
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]
