Need Help Displaying the Contents from the table
Posted: Thu May 13, 2004 1:36 pm
I used Dream weaver to bind the database and display the contents from the table. The problem is I CAN DISPLAY only 10 rows per page. I want to have a next Button which shows the other 10 rows in another page.
<?php
$maxRows_rs_contact = 10;
$pageNum_rs_contact = 0;
if (isset($HTTP_GET_VARS['pageNum_rs_contact']))
{
$pageNum_rs_contact = $HTTP_GET_VARS['pageNum_rs_contact'];
}
$startRow_rs_contact = $pageNum_rs_contact * $maxRows_rs_contact;
//mysql_select_db($database_dbconnect, $dbconnect);
$query_rs_contact = "SELECT * FROM contact";
$query_limit_rs_contact = sprintf("%s LIMIT %d, %d", $query_rs_contact, $startRow_rs_contact, $maxRows_rs_contact);
$rs_contact = mysql_query($query_limit_rs_contact, $connect) or die(mysql_error());
$row_rs_contact = mysql_fetch_assoc($rs_contact);
if (isset($HTTP_GET_VARS['totalRows_rs_contact'])) {
$totalRows_rs_contact = $HTTP_GET_VARS['totalRows_rs_contact'];
} else {
$all_rs_contact = mysql_query($query_rs_contact);
$totalRows_rs_contact = mysql_num_rows($all_rs_contact);
}
$totalPages_rs_contact = ceil($totalRows_rs_contact/$maxRows_rs_contact)-1;
?>
<table border="1">
<tr>
<td>Name</td>
<td>Phone</td>
<td>Email</td>
</tr>
<?php do { ?>
<tr>
<td><?php echo $row_rs_contact['Name']; ?></td>
<td><?php echo $row_rs_contact['Phone']; ?></td>
<td><?php echo $row_rs_contact['Email']; ?></td>
</tr>
<?php } while ($row_rs_contact = mysql_fetch_assoc($rs_contact)); ?>
</table>
<?php
$maxRows_rs_contact = 10;
$pageNum_rs_contact = 0;
if (isset($HTTP_GET_VARS['pageNum_rs_contact']))
{
$pageNum_rs_contact = $HTTP_GET_VARS['pageNum_rs_contact'];
}
$startRow_rs_contact = $pageNum_rs_contact * $maxRows_rs_contact;
//mysql_select_db($database_dbconnect, $dbconnect);
$query_rs_contact = "SELECT * FROM contact";
$query_limit_rs_contact = sprintf("%s LIMIT %d, %d", $query_rs_contact, $startRow_rs_contact, $maxRows_rs_contact);
$rs_contact = mysql_query($query_limit_rs_contact, $connect) or die(mysql_error());
$row_rs_contact = mysql_fetch_assoc($rs_contact);
if (isset($HTTP_GET_VARS['totalRows_rs_contact'])) {
$totalRows_rs_contact = $HTTP_GET_VARS['totalRows_rs_contact'];
} else {
$all_rs_contact = mysql_query($query_rs_contact);
$totalRows_rs_contact = mysql_num_rows($all_rs_contact);
}
$totalPages_rs_contact = ceil($totalRows_rs_contact/$maxRows_rs_contact)-1;
?>
<table border="1">
<tr>
<td>Name</td>
<td>Phone</td>
<td>Email</td>
</tr>
<?php do { ?>
<tr>
<td><?php echo $row_rs_contact['Name']; ?></td>
<td><?php echo $row_rs_contact['Phone']; ?></td>
<td><?php echo $row_rs_contact['Email']; ?></td>
</tr>
<?php } while ($row_rs_contact = mysql_fetch_assoc($rs_contact)); ?>
</table>