the next or previous valid sql value

[Bob-Marley]

<?php
$image_query=mysql_query("SELECT id FROM images ORDER BY id DESC");
if($_GET['id'] > "1"){
$id=mysql_real_escape_string($_GET['id]);
$max=mysql_num_rows($image_query);   /////////NumberOfImages
$back=$id-1;   //////////BackID
if($id < $max){
$next=$id+1;   //////////NextID
}else{
$id="1";
}
$cur_img=mysql_fetch_array(mysql_query("SELECT src FROM images WHERE id='$id'"));
echo"<img src=\"".$cur_img[src]."\"><br>";
if($back){ echo"<a href=\"book.php?id=".$back."\">Back</a>"; }
if($next){ echo"<a href=\"book.php?id=".$next"\">Next</a>"; }
?>

try that , make a table with id and src then insert 1 row per image and src is the URL to the image

[Maq]

Bob-Marley,

 

If you read the previous posts we decided not to do that because some of the id's don't exist because they have been deleted.

[Bob-Marley]

Ok just posting my opinion

[Maq]

Ok just posting my opinion

 

And here's mine, you should read the previous posts so you don't post redundant suggestions that have already been rendered useless. 

[Zeradin]

I'm using these

   $newidquery = "SELECT id FROM yearbook WHERE id < $id AND year = 2009 AND visible = 0 ORDER BY id DESC LIMIT 1";
   $newidquery2 = "SELECT id FROM yearbook WHERE id > $id AND year = 2009 AND visible = 0 ORDER BY id ASC LIMIT 1";

 

but now I want to get the next and prev values for alphabetical order from the name column. How would I do that?

[Zeradin]

bump?