Not signed in (Sign In)
SkillShare - A place to discuss Web Standards and Web Design topics
Categories
Vanilla 1.1.9 is a product of Lussumo. More Information: Documentation, Community Support.
- Friends
-
- CommentAuthorfirethrottle
- CommentTimeAug 27th 2007
hey,
how do i make a next link in an articles system?
i know you can just do $nextid = $_get[id] + 1; or whatever, but what if the next id doesn't exist? (eg article not approved, or has been deleted).
so in essence, what i am asking is how do you get the next existing id from a database? -
The SQL for the "next" ID could be "SELECT MIN(id) FROM table WHERE id > current_id LIMIT 1;".
-
- CommentAuthorfirethrottle
- CommentTimeAug 27th 2007
oh ok. thanks, i never thought of that. :)
1 to 3 of 3