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 Quote 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++; } Quote 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! Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.