hi

...and to be able to know the exact number of pages
do
$result = mysql_query("select count(*)....");
$nb_pages = $result/$nb_records_per_page;
et voila! add this to marcus's suggestion and you have a full paging script,
if you want some inspiration check out http://phpclasses.upperdesign.com i 
believe they have a class that does exactly that;

regards

At 14:02 03/09/01, 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]



-- 
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]

Reply via email to