Re: How to get only 2nd row in result set ???

I would say the same, do the query and then a loop through the results. Skip the first one and output the second, eg. $levels = mysql_query("SELECT levelID from hf_levels ORDER BY levelorder > RB> DESC LIMIT 2") or die('Unable to get levels<br>'.mysql_error()); for($i=0;$i<mysql_num_rows($levels);$i++){ $item = mysql_fetch_object($levels); if($i){ // Do the output with the new object, $item break; } } -- -- Kim Steinhaug ---------------------------------------------------------------------- There are 10 types of people when it comes to binary numbers: those who understand them, and those who don't. ---------------------------------------------------------------------- www.steinhaug.com - www.easywebshop.no - www.webkitpro.com ---------------------------------------------------------------------- "Mikhail U. Petrov" <mikhail@begun.ru> wrote in message news:182174812166.20040402211601@begun.ru... > 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_query("SELECT levelID from hf_levels ORDER BY levelorder > RB> DESC LIMIT 2") or die('Unable to get levels<br>'.mysql_error()); > > RB> but I can't figure out how to write the rest of the code ... I need to skip > RB> the first row and get the data from the 2nd row... but because there's an > RB> optional up to 255 possible rows in this table, and the order of these are > RB> determined by a user customizable field called levelorder ... so I can't > RB> just pick the specific numrows - 1 ... :-/ > > RB> I know this is a kludge to do it this way ... but it's what I need for now > RB> ... later I'll get to do it a more brilliant way... > > > RB> TIA > > RB> Rene > RB> -- > RB> Rene Brehmer > RB> aka Metalbunny > > RB> ~ If you don't like what I have to say ... don't read it ~ > > RB> http://metalbunny.net/ > RB> References, tools, and other useful stuff... > RB> Check out the new Metalbunny forums @ http://forums.metalbunny.net/ > > > > -- > Best regards, > Mikhail U. Petrov > mailto:mikhail@begun.ru