Yeah - I wound up doing this -
while($row = mysql_fetch_assoc($rsRates)){
$array[] = $row; }
> If you want to use the recordset (as opposed to the
array just created)
> later in the same page, you need to reset the result
resource like this:
>
> mysql_data_seek($recordsetName, 0);
Thank you for anticipating a question. That's excellent!
--
Murray --- ICQ 71997575
Adobe Community Expert
(If you *MUST* email me, don't LAUGH when you do so!)
==================
http://www.projectseven.com/go
- DW FAQs, Tutorials & Resources
http://www.dwfaq.com - DW FAQs,
Tutorials & Resources
==================
"David Powers" <david@example.com> wrote in message
news:fgkpaq$28r$1@forums.macromedia.com...
> Joris van Lier wrote:
>> in PHP Mysql it's already an array isn't it?
>
> No, it's not. It's a resource, which is a completely
different data type.
>
> To put the whole recordset in an array, you need to loop
through it.
> Because of the way Dreamweaver codes a recordset, it
requires a do...
> while loop.
>
> $myArray = array();
> do {
> $myArray[] = $row_recordsetName;
> } while ($row_recordsetName =
mysql_fetch_assoc($recordsetName));
>
> If you want to use the recordset (as opposed to the
array just created)
> later in the same page, you need to reset the result
resource like this:
>
> mysql_data_seek($recordsetName, 0);
>
> --
> David Powers, Adobe Community Expert
> Author, "The Essential Guide to Dreamweaver CS3"
(friends of ED)
> Author, "PHP Solutions" (friends of ED)
>
http://foundationphp.com/
10
Replies
AdChoices