DOH! - A private message arrived.... read below
When you mention it, ofcourse this is the correct (and sane sollution). I
guess
I was giving more flesh to the bone that the previous poster posted.
Looping through when limit is there is plain and simple stupid...
Shame on me! :)
Kim Steinhaug
----- Original Message -----
From: "Ross Honniball" <ross at bookshop dot jcu dot edu dot au>
To: "Kim Steinhaug" <kim@xxxxxxxxxxxxx>
Sent: Monday, April 05, 2004 4:18 AM
Subject: Re: How to get only 2nd row in result set ???
> If you specify LIMIT 2,1 then this will only return 1 record (ie. the
> second parameter is the number of results to return)
>
> At 06:17 AM 5/04/2004, you wrote:
> >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@xxxxxxxx> wrote in message
> >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
> >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@xxxxxxxx
> >
> >--
> >PHP Database Mailing List (http://www.php.net/)
> >To unsubscribe, visit: http://www.php.net/unsub.php
>
>
> . Ross Honniball JCU Bookshop Cairns Supervisor
> . James Cook Uni, McGreggor Rd, Smithfield, Qld. 4878, Australia
> . Ph:07.4042.1157 Fx:07.4042.1158 Em:ross@xxxxxxxxxxxxxxxxxxx
> . There are no problems. Only solutions.
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
