> SELECT * FROM news WHERE display='yes' ORDER BY id desc limit 1 > > Think this would get the lastest article that is to be displayed > but how do I get the second one. >
Just add an offset to the LIMIT clause: SELECT * FROM news WHERE display='yes' ORDER BY id desc limit 1,1 Edward -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]