Hi Richard.
Two methods, POST and GET: Post for forms and best works with hidden
elements.
Get can be put across URL's:
echo "<a href=\"$PHP_SELF?page=$next_page&$metode=$search\">Next</a>";
Or
<FORM ACTION="<? echo "$PHP_SELF"; ?>" METHOD="POST">
<INPUT TYPE="hidden" NAME="<? echo "$metode"; ?>" VALUE="<? echo "$search";
?>">
<INPUT TYPE="Submit" NAME="Submit" VALUE="Next">
</FORM>
Of course form buttons look dreadful, so if you use that method, create a
graphic to use, or do a javscript work around for text links. Hope that
helps :)
James.
"Richard Kurth" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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><str
ong>$fname</strong></td>
<td><strong>$lname</strong></td><td><strong>$company</strong></td><td><stron
g>$email</strong></td><td><strong>$cusername</strong></td><td><strong>$cpass
word</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]
>
--
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]
