We have a DB of customer comments that we want to display one at a time on our web site. We want the web pages (wrote in php) to use a user name/password on the DB that has SELECT ability and that's it.
What's the best way to cycle through the comments so that each page requested gets the "next" comment to be displayed without writing the "current" display number back to the database? Of course I could store it in a file or something, but I was hoping for a clean mysql solution. Like a LAST_INSERT_ID( ), only I'm looking for a LAST_SELECTED_ID( ) and then I'd select the next ID available. Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]