Re: First and Last Record Query
| From: | David Fudge | Date: | Wed, 13 Feb 2002 17:49:11 +0000 |
| Subject: | Re: First and Last Record Query | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-16909@lists.php.net to get a copy of this message | ||
yep, good point. thanks. =)
----- Original Message -----
From: "Rick Emery" <remery@excel.com>
To: "'David Fudge'" <fudge@hostopia.com>; <php-db@lists.php.net>
Sent: Wednesday, February 13, 2002 12:43 PM
Subject: RE: [PHP-DB] First and Last Record Query
> Why are you iterating through the array? Why not just:
>
> $start_id = $row[0];
> $end_id = $row[count($row)-1];
>
> -----Original Message-----
> From: David Fudge [mailto:fudge@hostopia.com]
> Sent: Wednesday, February 13, 2002 11:40 AM
> To: php-db@lists.php.net
> Subject: Re: [PHP-DB] First and Last Record Query
>
>
> well, if you're using an array, you could use a for like this:
>
> $row = mysql_fetch_row($result);
> for( $i=0;$i<count($row);$i++ )
> {
> if( $i==0 )
> $start_id = $row[$i];
> elseif( $i == (count($row)-1) )
> $end_id = $row[$i];
> }
>
>
> ----- Original Message -----
> From: "Rankin, Randy" <randy.rankin@invensys.com>
> To: <php-db@lists.php.net>
> Sent: Wednesday, February 13, 2002 12:32 PM
> Subject: [PHP-DB] First and Last Record Query
>
>
> > Does anyone know how to grab only the first and last record of a query.
> >
> > I have a table named periods with two fields, period_id and period_name.
> The
> > user will select a start period and an end period from a drop down list,
> > assigning $start_period and $end_period variables based on the period
id.
> If
> > I run this query:
> >
> > Select period_name
> > from periods
> > where period_id between '$start_period_id' and '$end_period_id'
> > order by period_id
> >
> > An array is returned which could include one or more records, depending
> upon
> > the user selection. I would like to grab the first and last record in
the
> > array so that the final result would be to echo something like "This
> report
> > is from $start_period through $end_period".
> >
> > Hope that makes sense ...
> >
> > Thanks in advance for any help.
> >
> > Randy Rankin
> >
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>