mdbrownarch Posted March 25, 2009 Share Posted March 25, 2009 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 Link to comment https://forums.phpfreaks.com/topic/151090-solved-associating-rows-upon-generating-php-files/ Share on other sites More sharing options...
The Little Guy Posted March 25, 2009 Share Posted March 25, 2009 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++; } Link to comment https://forums.phpfreaks.com/topic/151090-solved-associating-rows-upon-generating-php-files/#findComment-793916 Share on other sites More sharing options...
mdbrownarch Posted March 25, 2009 Author Share Posted March 25, 2009 Thank you! Link to comment https://forums.phpfreaks.com/topic/151090-solved-associating-rows-upon-generating-php-files/#findComment-793944 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.