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

KS> $item = mysql_fetch_object($levels); probe with $item = mysql_fetch_rows($levels); ---- Aitzi mail@aitziberhernandez.com ------------->>>>>>>>>>>>>>>>>------------- domingo, 04 de abril de 2004, 22:17:41, escribiste: KS> I would say the same, do the query and then a loop through the results. KS> Skip the first one and output the second, KS> eg. KS> $levels = mysql_query("SELECT levelID from hf_levels ORDER BY levelorder >> RB> DESC LIMIT 2") or die('Unable to get >> RB> levels<br>'.mysql_error()); KS> for($i=0;$i<mysql_num_rows($levels);$i++){ KS> $item = mysql_fetch_object($levels); KS> if($i){ KS> // Do the output with the new object, $item KS> break; KS> } KS> } KS> -- KS> -- KS> Kim Steinhaug KS> ---------------------------------------------------------------------- KS> There are 10 types of people when it comes to binary numbers: KS> those who understand them, and those who don't. KS> ---------------------------------------------------------------------- KS> www.steinhaug.com - www.easywebshop.no - www.webkitpro.com KS> ---------------------------------------------------------------------- KS> "Mikhail U. Petrov" <mikhail@begun.ru> wrote in message KS> 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 KS> here goes: >> >> RB> I've got this query: >> >> RB> $levels = mysql_query("SELECT levelID from hf_levels ORDER BY KS> levelorder >> RB> DESC LIMIT 2") or die('Unable to get >> RB> levels<br>'.mysql_error()); >> >> RB> but I can't figure out how to write the rest of the code ... I need to KS> skip >> RB> the first row and get the data from the 2nd row... but because there's KS> an >> RB> optional up to 255 possible rows in this table, and the order of these KS> are >> RB> determined by a user customizable field called levelorder ... so I KS> 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 KS> 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 @ >> RB> http://forums.metalbunny.net/ >> >> >> >> -- >> Best regards, >> Mikhail U. Petrov >> mailto:mikhail@begun.ru