Posted by bill on 01/05/07 13:32

Hendri Kurniawan wrote:
> <?php
> // initialize array
> $vals = array();
>
> // Fetch data from database, put them into associative array
> //
> // I am assuming the SQL will be something like:
> // SELECT comparableValue, otherInformation1, otherInformation2
> FROM sometable
> //
> // Thus. when fetching result:
> // $temp[0] = comparableValue
> // $temp[1] = otherInformation1
> // $temp[2] = otherInformation2
> //
> // With associative array, the newer values will always
> // re-write the older value. See example
> //
> // Say you fecth the row, it returned array('value1', 'someinfo',
> 'someinfo')
> // I will put them into assoc array, where 'value1' will be the key.
> // The next fetch, it returns array('value1', 'someinfoagain',
> 'someinfotoo')
> // If I put them into the same associative array, with the same key,
> // it will over-write the previous value.
> // and so on.
> //
> // Try first. If still don't understand. please ask again in ng
> //
> // PS. for Craig. 2 pass loop is not an elegant solution. But it's
> just an advice
> //
> while ($temp = fetch_row_from_db()) $vals[$temp[0]] = $temp;
>
> // This just dump the whole array to screen
> var_dump($vals);
> ?>
>
>
> Hendri Kurniawan

Lovely, and very much appreciated.
Now I just need to print it out and study it.
Thanks

bill
>
> bill wrote:
>> Hendri Kurniawan wrote:
>>> Another way to do it VIA array
>>>
>>> <?php
>>> $vals = array();
>>> while ($temp = fetch_row_from_db()) $vals[$temp[0]] = $temp;
>>> var_dump($vals);
>>> ?>
>>>
>>> This way, you are sure to get the last row of every value.
>>>
>>> Hendri Kurniawan
>>>
>>
>> Hendri,
>> Would you please take pity on a PHP newbie and explain your code.
>> It is elegant and dense I can't quite make sense of it.
>> Shouldn't there be a bracket after the while statement ?\
>>
>> bill

[Back to original message]