############## function UpdateFirstYearCost(){ ##function GetData($connect,$func,$id=0,$disconnect,$id2=0,$id3='=') { $link = mysql_connect ("localhost", "phones_3phones", "thunder") or die("Could not connect : " . mysql_error()); mysql_select_db ("phones_3phones"); } $query="SELECT Phones.PhoneID, Makes.MakeName,Makes.MakeID, Phones.PhoneModel, Phones.Exclude, LCASE(REPLACE(CONCAT(MakeName,'-',PhoneModel),' ','-')) AS Phonecode FROM Makes INNER JOIN Phones ON Makes.MakeID = Phones.PhoneMake WHERE (((Phones.Exclude)=0)) ORDER BY Makes.MakeName, Phones.PhoneModel"; break; } $result = mysql_query($query); if ($result){ $num_fields = mysql_num_fields($result); #echo $num_fields; $j=0; $x=1; while($row=mysql_fetch_array($result)){ for($j=0;$j<$num_fields;$j++){ $name = mysql_field_name($result, $j); $data[$x][$name]=$row[$name]; # echo $data[$x][$name]; }$x++; } #echo "Make=".$data[20]["PhoneModel"]; return $data; } #else{return null;} } Array ( [0] => Array ( [desc] => FREE Line Rental for first 6 months [cost] => -240 ) [1] => Array ( [desc] => 3 months Free Insurance [cost] => 0 ) [2] => Array ( [desc] => Free MP3 Player [cost] => 0 ) [3] => Array ( [desc] => £5 Video Content [cost] => 0 ) [4] => Array ( [desc] => 50 Video Messages and 25 MMS for first 3 months [cost] => 0 ) [5] => Array ( [desc] => 25 minutes of Video Calls [cost] => 0 ) [6] => Array ( [desc] => Free DVD Player [cost] => 0 ) [7] => Array ( [desc] => £50 Cash Back [cost] => -50 ) )