Trying to loop through MDB rowset -
| From: | Matt Friedman | Date: | Thu, 07 Nov 2002 16:49:35 +0000 |
| Subject: | Trying to loop through MDB rowset - | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-2655@lists.php.net to get a copy of this message | ||
I had thought that this would work ok:
--------------------------------------------------
$sql = " SOME SQL HERE ";
$rs = $this->db->query($sql);
while( $row = $this->db->fetchRow($rs, MDB_FETCHMODE_ASSOC) ) {
// do something with the row info...
}
--------------------------------------------------
But I keep getting this error and I can't seem to reckon why.
Notice: Undefined offset: 19 in /usr/local/lib/php/MDB/mysql.php on line
1343
I looked at the MDB documentation but I couldn't seem to find an example
of how to loop through a set of rows. There is a single row example but
for a multi-rowset there isn't anything there AFAI can tell.
Thanks,
Matt Friedman
Web Applications Developer
www.SpryNewMedia.com
Phone: 416 992 5482
Email: matt@SpryNewMedia.com
> -----Original Message-----
> From: Stig S. Bakken [mailto:ssb@fast.no]
> Sent: Thursday November 7, 2002 7:31 AM
> To: Bertrand Mansion
> Cc: Stig S. Bakken; Arnaud Limbourg; Birgir Stefansson; pear-
> general@lists.php.net
> Subject: Re: [PEAR] Pear and installing packages .. help!?
>
> On Wed, 2002-11-06 at 17:08, Bertrand Mansion wrote:
> > <ssb@fast.no> wrote :
> >
> > > On Tue, 2002-11-05 at 09:50, Bertrand Mansion wrote:
> >
> > >> There seems to be some problems with the packages of at least
> HTML_Table and
> > >> HTML_QuickForm. I released them at the same time using the PEAR
cli
> tool and
> > >> when I untar them now, I only get the package.xml file, even if
the
> archive
> > >> is big.
> > >>
> > >> This was done on Darwin. I think there must be a problem with the
> pear cli
> > >> tool or archive_tar. I don't know if this is related to the
problem
> you have
> > >> now.
> > >>
> > >> Anyway, I will try to make a new release this week for both
packages.
> > >
> > > For now I think that people should avoid releasing packages built
on
> > > Windows and Darwin machines. There seem to be some problems
related
> to
> > > Archive_Tar that must be resolved before we can consider building
> > > packages on these platforms stable.
> >
> > How can I release my packages, then ?
>
> Four options:
>
> 1. Drop me a mail and I'll package/upload for you (make sure you
cvstag
> first)
>
> 2. Fix the problems on Darwin/Windows
>
> 3. Help making an online package builder for pear.php.net :-)
>
> 4. Wait until I've installed a couple of windows environments for
> testing in vmware and fixed the portability issues
>
> - Stig
>
> --
> Stig Sæther Bakken, Fast Search & Transfer ASA, Trondheim, Norway
> http://pear.php.net/wishlist.php/ssb
>
>
> --
> PEAR General Mailing List (http://pear.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php