Re: Problem with PHP_SELF

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" <rkurth@pacifier.com> wrote in message news:8518647749.20010518012115@pacifier.com... > 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:rkurth@pacifier.com > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >