RE: [PHP-DB] Current row of query
| From: | Hutchins, Richard | Date: | Thu, 26 Sep 2002 15:16:37 +0000 |
| Subject: | RE: [PHP-DB] Current row of query | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-22009@lists.php.net to get a copy of this message | ||
Not sure here, but you might also run into a problem if you start your if
statement with $i=0. If PHP does not treat the value 0 as even or odd, your
first row is most likely going to be purple along with your second row. I
know it's nitpicky, but I could see myself spending half an hour trying to
figure out why the code works, but not the way I want it to.
> -----Original Message-----
> From: Brad Bonkoski [mailto:bbonkosk@tampabay.rr.com]
> Sent: Thursday, September 26, 2002 11:10 AM
> To: Patrick Lebon; php-db@lists.php.net
> Subject: Re: [PHP-DB] Current row of query
>
>
> oops...
>
> I meant:
> (if $i is odd)
> ...
>
> because $i would be the current index in the array.
>
>
> Brad Bonkoski wrote:
>
> > why not this?
> >
> > $result = mysql_query("Select * from table');
> > $num_rows = mysql_num_rows($rows);
> >
> > for ($i=0; $i<$num_rows, $i++)
> > {
> > $row = mysql_fetch_array($result);
> > if ($num_rows is odd)
> > {
> > print $row with BG color of red;
> > }
> > else
> > {
> > printf $row with BG color of purple;
> > }
> > }
> >
> > HTH
> > -Brad
> >
> > Patrick Lebon wrote:
> >
> > > Is there a mysql or array variable for the current row of
> a query array?
> > > I want to alternate background colours for each row of
> the query output so i
> > > need to know the current row number.
> > >
> > > Thanks
> > >
> > > --
> > > 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
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>