[Resolved] Multidimensional array

[redzzzon]

Hi

I like to query my db and each row be an array of values within an array of instance.

So when I do print_r I get something like array( personID[1]=>array(email=>'[e-mail]',status='0',postalcode=>'11111')personID[2]]=>array(email=>'[e-mail]',status='1',postalcode=>'22222'))

I not sure if this is way it should look. However I am aiming in keeping it together.

Thanks Tom

[devinemke]

$result = mysql_query('SELECT * FROM table');
while ($row = mysql_fetch_assoc($result)) {$array[$row['personID']] = $row;}
print_r($array);

[redzzzon]

Thanks Davin

If I am at the command line of mysql and run a query where there are 100 records I would get a 100 rows. With the code, which solves my problem, does it store in memory as it runs through. Or are is the whole query result dump into the array once its done.

I am wondering. If the query is outside the condition why doesnt the query start from the begging every time.

Thanks Tom

[devinemke]

Originally posted by redzzzon
With the code, which solves my problem, does it store in memory as it runs through. Or are is the whole query result dump into the array once its done.

during each iteration of the foreach loop a new index is added into the array, which is all stored in memory

Originally posted by redzzzon
I am wondering. If the query is outside the condition why doesnt the query start from the begging every time.

the query will return as many rows as you ask it to and will order them however you want.

[redzzzon]

during each iteration of the foreach loop a new index is added into the array, which is all stored in memory

The objective is to look at a status of each member. If status is true then display in first table. If status is false then secound table. If I have a 1000 rows and create array using thw while condition until condition is met then to filter to right the right row seems to be memory burdemsom.

Are there any other ways?

Thanks

[devinemke]

i'm assuming from your post that "status" is simply a boolean filed in your table.

$result = mysql_query('SELECT * FROM table');
while ($row = mysql_fetch_assoc($result))
{
	if ($row['status']) {$status_true[$row['personID']] = $row;}
	else {$status_false[$row['personID']] = $row;}	
}

now you have 2 arrays: $status_true and $status_false. use them to build out your 2 HTML tables.