Trying to get next record from MySQL db
Posted on 2005-04-14
This is probably extremely simple, but I cant work it out.
I have build a site for a client, Under the 'collections' link this displays all records from that 'collection' in thumbnail form, clicking one of them passes the id in the URL to display that product. Now, I have done $next = $id + 1; but of course, if the next record has been deleted, it wont return anything. How can I write a loop to keep checking until it finds the next record and pass the id of that record though the URL?
Thanks in Advance,