I am having a problem with this script. It works perfect if I just do
a Query like ("SELECT * FROM customers") but if I call it from
another script with a form to set the search criteria for this Query
("SELECT * FROM customers WHERE $metode LIKE '%$search%'") It will
show the first page but it gives me a error for any other page the
problem is it does not pass the $metode $search on to the next page with
PHP_SELF (look at bottom of script) How can I make it retain the
variables to the next page?
// Number of entries per page
$per_page = 3;
$sql_text = ("SELECT * FROM customers WHERE $metode LIKE '%$search%'");
// Set page #, if no page is specified, assume page 1
if (!$page) {
$page = 1;
}
$prev_page = $page - 1;
$next_page = $page + 1;
$query = mysql_query($sql_text);
// Set up specified page
$page_start = ($per_page * $page) - $per_page;
$num_rows = mysql_num_rows($query);
if ($num_rows <= $per_page) {
$num_pages = 1;
} else if (($num_rows % $per_page) == 0) {
$num_pages = ($num_rows / $per_page);
} else {
$num_pages = ($num_rows / $per_page) + 1;
}
$num_pages = (int) $num_pages;
if (($page > $num_pages) || ($page < 0)) {
}
//
// Now the pages are set right, we can
// perform the actual displaying...
$sql_text = $sql_text . " LIMIT $page_start, $per_page";
$query = mysql_query($sql_text);
?>
<table border="1" align="center">
<tr align="center" valign="top" bgcolor="#86B3E3">
<td><h3>Plan</h3></td>
<td><h3>Domain</h3></td>
<td><h3>First Name</h3></td>
<td><h3>Last Name</h3></td>
<td><h3>Company</h3></td>
<td><h3>Email</h3></td>
<td><h3>User Name</h3></td>
<td><h3>Password</h3></td>
</tr>
<?
//$query = mysql_query("SELECT * FROM customersWHERE $metode LIKE '%$search%' LIMIT 0,
30 ");
while ($row = mysql_fetch_array($query))
{ $plan=$row["plan"];
$domaname=$row["domaname"];
$fname=$row["fname"];
$lname=$row["lname"];
$company=$row["company"];
$email=$row["email"];
$cusername=$row["cusername"];
$cpassword=$row["cpassword"];
echo "<tr align='center'>";
print
("<td><strong>$plan</strong></td><td><strong>$domaname</strong></td><td><strong>$fname</strong></td>
<td><strong>$lname</strong></td><td><strong>$company</strong></td><td><strong>$email</strong></td><td><strong>$cusername</strong></td><td><strong>$cpassword</strong></td><br>");
echo "</tr>";
}
echo "</table>";
// Previous
if ($prev_page) {
echo "<a href=\"$PHP_SELF?page=$prev_page\">Prev</a>";
}
// Page # direct links
for ($i = 1; $i <= $num_pages; $i++) {
if ($i != $page) {
echo "<a href=\"$PHP_SELF?page=$i\">$i</a>";
} else {
echo " $i ";
}
}
// Next
if ($page != $num_pages) {
echo "<a href=\"$PHP_SELF?page=$next_page\">Next</a>";
}
Best regards,
Richard
mailto:[EMAIL PROTECTED]
--
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]