previous next php

buzzby

i have tried the code. i think i need some help with it. all it is doing is going to the next id but displaying nothing. this is what i have so far

<?php
$user="";
$host="";
$password="";
$database="";
$connection=mysql_connect($host,$user,$password) or die ("could not connect to server");
$db=mysql_select_db($database,$connection);
$result = mysql_query("select * from gstrialforma where id = '$_GET[id]'",$connection);
$q = mysql_fetch_object($result); 
$check1= mysql_query("select min(id) as id from gstrialforma"); 
$check1 = mysql_fetch_object($check1); 
$check2 = mysql_query("select max(id) as id from gstrialforma"); 
$check2 = mysql_fetch_object($check2);  

?>

i have this code on the text button at the bottom
previous

<?php if($check1->id != $_GET['id']) { $newid = $_GET['id']-1; echo "<a href=\"formview.php?id=$newid\"><- Previous</a>"; }?>

<?php if($check2->id != $_GET['id']) { $newid = $_GET['id']+1; echo "<a href=\"formview.php?id=$newid\">Next -></a>"; }?>

i am not sure whether to you this:

<? echo $_GET['name']?>

or this

<? echo $_POST['email']?>

neither is returning anything.

devinemke

few things:

you don't need two queries to get the min/max id's. this can be done on one single query:
```
SELECT MIN(id) AS min_id, MAX(id) AS max_id FROM gstrialforma
```

to get the previous id (assuming the current id is $id):

SELECT id AS prev FROM gstrialforma WHERE id < $id ORDER BY id DESC LIMIT 1

to get the next id (assuming the current id is $id):

SELECT id AS next FROM gstrialforma WHERE id > $id LIMIT 1