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-tf281
5179.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