[SOLVED] Associating rows upon generating php files

[mdbrownarch]

Hi,

 

I have a table of addresses in MySQL, and I am looking to generate pages with php for each address that also show links to the previous address and next address in my table. So if I have a page showing the 10th address, I want to provide links to the 9th and 11th addresses.

 

I would imagine that this would be done in PHP, but I wasn't sure. Can someone please help me with this?

 

Thank you!

Matt

[The Little Guy]

This should get your desired results....

 

$current = '100';
$sql = mysql_query("
(SELECT * FROM users WHERE id < '$current' ORDER BY id DESC LIMIT 1)
UNION
(SELECT * FROM users WHERE id > '$current' ORDER BY id ASC LIMIT 1)
");
$i = 0;
while($row = mysql_fetch_array($sql)){
     if($i == 0)
          echo '<a href="/link.php?id='.$row['id'].'">Previous</a>';
     if($i == 1)
          echo '<a href="/link.php?id='.$row['id'].'">Next</a>';
     $i++;
}

[mdbrownarch]

Thank you!