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
