On Monday 28 January 2002 18:42, Jason Wong wrote:
> > $page behaves just fine :
> > page: 2 <- yup, it's incrementing, all right...
> > nr_pages: 230
> > Whack! Doesn't work any more... It's starting to drive me mad.
> Me too. Post the full code so we can all revel in this madness!
All rightey. Here it goes in it's (almost) full glory!
// The nav-function that's responsible for updateing the query
if($nav) {
if($go=="next") {
if($page < $nr_pages && $page >= 0) {
$page++;
$milla= (($page) * 20).","; // replace with
echo "mill�: " . $milla; // echo out debug info
$mita = (($page-1) * 20).","; // replace what
echo "mit�: " .$mita; // echo out more debug info
$query=ereg_replace($mita,$milla,$query);
}
}
if($go=="prev") {
if($page>=1 && $page <= $nr_pages) {
$page--;
$milla = (($page) * 20).",";
echo "mill�: " . $milla;
$mita = (($page+1) * 20).",";
echo "mit�: " . $mita;
$query=ereg_replace($mita,$milla,$query);
}
}
echo "query from nav(): " .$query;
$result=mysql_query($query,$database)
or die("BEATCH,WHINE AND MOAN!"); // hehe. just a debug output.
print_taulukko();
}
function print_taulukko() {
?>
<FORM ACTION="page.php" METHOD="POST">
<?
//debug
echo "query: " . $query;
echo "<BR><BR>";
echo "page: " . $page;
echo "<BR>";
echo "nr_pages: " .$nr_pages;
//endof debug
while($row=mysql_fetch_row($result)) {
[snip away stuff that doesn't really matter]
}
?>
<TR>
<TD COLSPAN="5" WIDTH="50%" ALIGN="CENTER"><INPUT <?php if($page == 0) {echo
"DISABLED";} ?> TYPE=button
VALUE="Edellinen sivu"
onclick="parent.location='page.php?nav=true&go=prev';"></TD>
<TD COLSPAN="4" WIDTH="50%" ALIGN="CENTER"><INPUT <?php if($page >=
($nr_pages-1)) { echo "DISABLED"; }?> TYPE=button
VALUE="Seuraava sivu"
onclick="parent.location='page.php?nav=true&go=next';"></TD>
</TR>
<?
}
And that's basically it. There's a function responsible for
reading user input and constructing the sql-query, and it
places the sql in $query, stuffs it down MySQL and throws
it over to print_taulukko(), and it seems to be working right,
since the first result always is the correct one. It also session_registers
$query. (yes, I use session_register("query"), not session_register($query).)
I checked the sess_<whatever> file step by step when testing again just to see
exactly what is put in it, but it seems to be a well-behaved little textfile.
Make any sense out of the code?
Cheers mate,
Markus
--
Markus Lervik
Linux-administrator with a kungfoo grip
Vaasa City Library - Regional Library
[EMAIL PROTECTED]
+358-6-325 3589 / +358-40-832 6709
--
PHP Database 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]
