KS> $item = mysql_fetch_object($levels);
probe with $item = mysql_fetch_rows($levels);
----
Aitzi
mail@xxxxxxxxxxxxxxxxxxxxx
------------->>>>>>>>>>>>>>>>>-------------
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 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@xxxxxxxx> wrote in message
KS> news:182174812166.20040402211601@xxxxxxxxxxx
>> 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 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 @ http://forums.metalbunny.net/
>>
>>
>>
>> --
>> Best regards,
>> Mikhail U. Petrov
>> mailto:mikhail@xxxxxxxx
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
