Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › Data Bridge General / Announcements › How to return previous (or next) values in MySQL?

View all replies to this thread

How to return previous (or next) values in MySQL?

Thread began 5/27/2013 1:08 am by Mike | Last modified 5/28/2013 7:21 am by Mike | 612 views | 2 replies

5/27/2013 1:08 amMike

How to return previous (or next) values in MySQL?

I'd like to create a query that allow me to rescue the previous value in a mysql table.

I've a detail news page with a URL parameter filter* and I need to recuperate the previous value in the recordset; for example, if the page view the news with ID 5, a secondary query should view the previous value (ID 4).

How to create this sql code?

Thanks,
Michele

*
"SELECT * FROM tbl_news WHERE url_news = %s AND tbl_news.status_news = 1", GetSQLValueString($colname_rsNewsDetails, "text")

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.