missed a couple of quotes and braces there :)
while ($row = mysql_fetch_assoc($result)) {
$vehicles[$row['dealer_id']][$row['vehicle_id']]['views'][] =
$row['page_views'];
}
At 02:03 PM 28/06/2002 +1000, Tom Rogers wrote:
>Hi
>I would do it this way (untested)
>
>while ($row = mysql_fetch_assoc($result)) {
> $vehicles[$row['dealer_id][$row['vehicle_id]['views'][] =
> $row['page_views'];
>}
>
>
>should end up something like this
>
>(
>[645] => Array
> (
> [35073] => Array
> ([
> [views]=> Array
> (
> [1] => 10
> [0] => 6
> )
> )
>)
>
>
>Tom
>
>
>
>At 01:09 PM 28/06/2002 +1200, Morgan Grubb wrote:
>>I have a large dataset which can contain many different fields, and I'm
>>trying to flatten them in such a way that I can display it happily in a
>>table.
>>
>>To simplify: I'm populating the array such (many many more fields, but these
>>will do):
>>
>> $i = 0;
>> while ($row = mysql_fetch_assoc($result)) {
>> $vehicles[$i]['dealer_id'] = $row['dealer_id'];
>> $vehicles[$i]['vehicle_id'] = $row['vehicle_id'];
>> $vehicles[$i][$row['company_id']] = $row['page_views'];
>> $i++;
>> }
>>
>>Now, if that vehicle_id and dealer_id combination exist, instead of adding
>>it as another record completely,
>>just add
>>
>> $vehicles[$existing_id][$row['company_id']] = $row['page_views'];
>>
>>The end result of this would be (if given two 'company_id' records for the
>>given dealer):
>>
>>(
>> [0] => Array
>> (
>> [dealer_id] => 645
>> [vehicle_id] => 35073
>> [1] => 10
>> )
>>
>> [1] => Array
>> (
>> [dealer_id] => 645
>> [vehicle_id] => 35073
>> [0] => 6
>> )
>>)
>>
>>Turns into:
>>
>>(
>> [0] => Array
>> (
>> [dealer_id] => 645
>> [vehicle_id] => 35073
>> [1] => 10
>> [0] => 6
>> )
>>)
>>
>>Can anyone think of a fast way to do this either during creation of the
>>array or after the array has been created? (A sort of fast_flatten($array)
>>function) ?
>>
>>If anyone can think of something, I'd be really appreciative.
>>
>>
>>
>>Cheers,
>>Morgan Grubb.
>>
>>
>>
>>--
>>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
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
