beginner question back/prev buttons

[Anon]

hi to all !

i´ve taken the script from rod with back / prev buttons and included that one into my script...

the script is well done so far, but with my select statement i get a mysql error

i do know that i must change something in:

// check to see if last page
if (!(($offset/$limit)==$pages) && $pages!=1) {
// not last page so give NEXT link
$newoffset=$offset+$limit;
print "<a href=\"test1.php3?offset=$newoffset\">NEXT</a><p>\n";
}

for my select statement :

// get results
$result=mysql_query("select * ".
"from fahrdata where $metode like '%$search%' ".
"order by hersteller limit $offset,$limit");

// now you can display the results returned
while ($row=mysql_fetch_array($result)) {
// include code to display results as you see fit

but i don´t know what i´ve to change !
so could anybody help me ? i don´t see it..

so i thougt somebody here can help me !
thanx !

torsten

[Anon]

You will need to pass your variables used in the search along in the link with next like

if (!(($offset/$limit)==$pages) && $pages!=1) {
// not last page so give NEXT link
$newoffset=$offset+$limit;
print "<a href=\"test1.php3?offset=$newoffset&metode=$metode&search=$search\">NEXT</a><p>\n";
}

[Anon]

Looks like you forgot to define the db connection in your call to mysql_query.

$result=mysql_query("select * ".
"from fahrdata where $metode like '%$search%' ".
"order by hersteller limit $offset,$limit", $db_conn);

[Anon]

Chris that parameter is optional what he forgot was to pass the varibales to the next page

[Anon]

thank you all !

that´s it ! i knew that it was something like that.. it was realy easy ! but i didn´t see it.

so again.. thank´s for your help... it works !

greetz
torsten schrammen

[Anon]

I didn't know that. I guess you learn something new every day.

: )