use the limit clause
$count = 25;
$query="SELECT * FROM xxxx WHERE hello = '$hello' limit $count";
Bastien
From: Chris Carter <chandan9sharma@xxxxxxxxx>
To: php-db@xxxxxxxxxxxxx
Subject: Limited number of database results
Date: Wed, 13 Dec 2006 08:51:47 -0800 (PST)
Hi,
I have more than 200 rows of data to show to the user. How can I limit it
to
say 25 rows per page and give an option at the bottom to the user to keep
clicking for more till s/he reaches the end of data.
my db code is:
</tr>
</thead>
<tbody>
<?php
// database information
$host = 'localhost';
$user = 'xxxx';
$password = 'xxxx';
$dbName = 'xxxx';
$hello = $_REQUEST['hello'];
mysql_connect(localhost,$user,$password);
@mysql_select_db($dbName ) or die( "Sorry But There Seems To Be A Problem
Connecting To The Database");
$query="SELECT * FROM xxxx WHERE hello = '$hello'";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
$i=0;
while ($i < $num) {
$showThis=mysql_result($result,$i,"showThis");
echo "
<tr>
<td>$showThis</td>
</tr>";
$i++;
}
if (num==0)
{
<tr><td>Sorry no results displayed</td></tr>
}
?>
</tbody></table></div>
Seems like I am the only one asking questions since past few days. Thanks
anyway for your support. I am just about to launch my site. Just after I
achieve this. It will be very userfriendly.
Thanks in advance.
Chris
--
View this message in context:
http://www.nabble.com/Limited-number-of-database-results-tf2815179.html#a7856535
Sent from the Php - Database mailing list archive at Nabble.com.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
_________________________________________________________________
Download now! Visit http://www.telusmobility.com/msnxbox/ to enter and see
how cool it is to get Messenger with you on your cell phone.
http://www.telusmobility.com/msnxbox/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
