[PHP-DB] How to get only 2nd row in result set ???

2004-04-02 Thread -{ Rene Brehmer }-
I couldn't find anything like this from my archive searches ... so here goes: I've got this query: $levels = mysql_query("SELECT levelID from hf_levels ORDER BY levelorder DESC LIMIT 2") or die('Unable to get levels'.mysql_error()); but I can't figure out how to write the rest of the code ... I

Re: [PHP-DB] How to get only 2nd row in result set ???

2004-04-02 Thread Mikhail U. Petrov
Hi! But what's the problem? You can use mysql_fetch_array() 2 times. But may be I understood question not correctly... Friday, April 2, 2004, 10:06:05 PM, -{ wrote: RB> I couldn't find anything like this from my archive searches ... so here goes: RB> I've got this query: RB> $levels = mysql_qu

RE: [PHP-DB] How to get only 2nd row in result set ???

2004-04-02 Thread Rogers, Dennis
This will give you the second row of data. $levels = mysql_query("SELECT levelID " ."from hf_levels " ."ORDER BY levelorder " ."DESC LIMIT 1, 1") or die('Unable to get levels'.mysql_error()); -O