Use a LIMIT clause. See http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#SELECT
-Rasmus On Tue, 23 Oct 2001, Tshering Norbu wrote: > Dear list, > I would like to query only the last 50 records/rows (order by ID desc) in > the following script file which uses MySQL, and I want to have NEXT page for > the 50 rows earlier than last 50 queried and go on. I think I can use > JavaScript for BACK page to go back. Could you pl add for me the script to > implement NEXT page. > > Here is the script file: > > <html> > <body> > <?php > $db = mysql_connect("localhost", "root", "root"); > mysql_select_db("penpal",$db); > if ($id) > > $result = mysql_query("select * from penpal where id = $id",$db); > $myrow = mysql_fetch_array($result); > printf("<b>ID:</b> %s\n<br>", $myrow["id"]); > printf("<b>Name:</b> %s\n<br>", $myrow["name"]); > printf("<b>Age/Sex/Location:</b> %s\n<br>", $myrow["asl"]); > printf("<b>Description:</b> %s\n<br>", $myrow["description"]); > printf("<b>Email:</b> %s\n<br>", $myrow["email"]); > } else { > $result = mysql_query("select * from penpal order by id desc", $db); > if ($myrow = mysql_fetch_array($result)) { > do { > printf("<a href = \"%s?id=%s\">%s %s</a><br>\n", $PHP_SELF, $myrow["id"], > $myrow["name"], $myrow["asl"]); > } while ($myrow = mysql_fetch_array($result)); > } else { > echo "Sorry, no records"; > } > } > ?> > </body> > </html> > > > > Thank you in advance. > > NOBBY > > > -- PHP General 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]