Simple:

while($rows[]=mysql_fetch_array($res)) {}

($res is a mysql result resource)

Beauford.2002 wrote:

Thanks for the info, but maybe I didn't give enough info.

I have a mysql database with up to 10 rows and 5 fields in each row.. I have
been reading up on some of the array functions, but haven't been able to get
anything to work.

TIA

----- Original Message -----
From: "Weston Houghton" <[EMAIL PROTECTED]>
To: "Beauford.2002" <[EMAIL PROTECTED]>
Cc: "PHP General" <[EMAIL PROTECTED]>
Sent: Thursday, December 26, 2002 6:19 PM
Subject: Re: [PHP] Nested Arrays



Sure... for the longwinded approach, just do this:

$row1 = array("col1", "col2", "col3", ...);
$row2 = array("col1", "col2", "col3", ...);
$row3 = array("col1", "col2", "col3", ...);
$row4 = array("col1", "col2", "col3", ...);
$row5 = array("col1", "col2", "col3", ...);

$main_array = array($row1, $row2, $row3, $row4, $row5);

Obviously these could include key-value pairs in the arrays as well.
Then to prove it to yourself:

print_r($main_array);

Cheers,
Wes


On Thursday, December 26, 2002, at 06:14 PM, Beauford.2002 wrote:


Hi,

Is there anyway to do a nested array, I have looked at the various
array
functions and can't figure this out (if possible).

I want to be able to put each field of a row into an array, and then
put
that entire row and into another array.

so when I display it, I would have:

row1 - col1 col2 col3 col4 col5
row2 - col1 col2 col3 col4 col5
row3 - col1 col2 col3 col4 col5
row4 - col1 col2 col3 col4 col5
row5 - col1 col2 col3 col4 col5

etc. (depending on how many rows there are).

TIA



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php








--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to