Recordset into an array?

Thanks for your persistance in drilling this stuff through my noggin, David.

Luckily, I had commented out that part of the DW markup! 8)

--
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:fgl2jv$cu8$1@forums.macromedia.com...
> Murray *ACE* wrote:
>> Yeah - I wound up doing this -
>>
>> while($row = mysql_fetch_assoc($rsRates)){
>> $array[] = $row; }
>
> As I explained before, because of the way that Dreamweaver creates a
> recordset, you need to use a do... while loop. If you don't, and you place
> the preceding code after the recordset code, the first record will be
> missing.
>
> This is because the code generated by Dreamweaver automatically retrieves
> the first record in this line:
>
> $row_recordsetName = mysql_fetch_assoc($recordsetName);
>
> --
> David Powers, Adobe Community Expert
> Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
> Author, "PHP Solutions" (friends of ED)
> http://foundationphp.com/

Murray *ACE* wrote:
> Yeah - I wound up doing this -
>
> while($row = mysql_fetch_assoc($rsRates)){
> $array[] = $row; }

As I explained before, because of the way that Dreamweaver creates a
recordset, you need to use a do... while loop. If you don't, and you
place the preceding code after the recordset code, the first record will
be missing.

This is because the code generated by Dreamweaver automatically
retrieves the first record in this line:

$row_recordsetName = mysql_fetch_assoc($recordsetName);

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

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/

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/

LAMP....

--
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
==================


"Joris van Lier" <whizzrd@hotmail.com> wrote in message
news:fgkjkp$olq$1@forums.macromedia.com...
> "Murray *ACE*" <forums@HAHAgreat-web-sights.com> wrote in message
> news:fgki3r$mt8$1@forums.macromedia.com...
>> Yes. Oops....
>
> .. so what is it....Coldfusion, JSP, .NET ? :)

"Murray *ACE*" <forums@HAHAgreat-web-sights.com> wrote in message
news:fgki3r$mt8$1@forums.macromedia.com...
> Yes. Oops....

.. so what is it....Coldfusion, JSP, .NET ? :)

Yes. Oops....

Thanks for the gentle reminder!

--
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
==================


"Joris van Lier" <whizzrd@hotmail.com> wrote in message
news:fgkh1u$ljn$1@forums.macromedia.com...
> "Joris van Lier" <whizzrd@hotmail.com> wrote in message
> news:fgkgsh$lbf$1@forums.macromedia.com...
>> in PHP Mysql it's already an array isn't it?
>
> http://www.weberdev.com/get_example-4065.html
>
>

"Joris van Lier" <whizzrd@hotmail.com> wrote in message
news:fgkgsh$lbf$1@forums.macromedia.com...
> in PHP Mysql it's already an array isn't it?

http://www.weberdev.com/get_example-4065.html

"Murray *ACE*" <forums@HAHAgreat-web-sights.com> wrote in message
news:fgkgj3$kvh$1@forums.macromedia.com...
> What function would I use to load an entire recordset into an array?

Aww c'mon Murray, you know better than not to state what servermodel you
need..

Asp: Recordset1.GetRows() http://www.w3schools.com/ado/met_rs_getrows.asp
Phakt: $recordset->GetRows($nrows)
in PHP Mysql it's already an array isn't it?

Joris