Associative Array From MySQL Results using PHP

[bululu]

Suppose I have a table with columns fname, lname, test1,test2,test3.

How do I get all rows into an associative array that will look like:

$array=('name'=>56, 'anothername'=>32, 'somename'=>48,'thisothername'=>82);

name is a concartination of fname and lname, and the value (e.g 56) is the sum of test1,test2 and test3.

Any help will be greatly appreciated.

[httpwebwitch]

Welcome to WebmasterWorld!

$array = array();
$query = "SELECT * from table";
$result = mysql_query($query);
while($row = mysql_fetch_array($result)){
$array[$row['fname'].$row['lname']] = $row['test1']+$row['test2']+$row['test3'];
}

print_r($array);

[bululu]

Thanks very much that works well.