While ()

Forever_xxl

I have in mysql this data:
id | auto | cost
1 | Ford | 70000
2 | Ford | 12000
3 | VW | 1000
4 | VW | 140000
with while i get all data. but I want what he print how much cost all ford, VW
my formula ($cost 12 / $points) // $points I am getting from over table.
I want what it group auto.
if i wrote:
$auto = ($cost 12 / $points) + $auto; // it's print all cars informations.
I want That count all FORD information and print informations, then count disabled and he are 0. then counting VW. I now i can make it with mysql sentence, but I don't wan't. My formula are more biggest. (😉)
I want what he print only.
ford 82000 //
VW 141000 //

Thanks for help.

Weedpacket

I don't understand: why don't you want to do it in MySQL? It would be faster.

Forever_xxl

because my formula very big and same times he getting random() data.

laserlight

because my formula very big and same times he getting random() data.

Your formula doesnt look very 'big', and mysql can handle (pseudo-)random selection of data.

Kudose

Originally posted by Forever_xxl
I want what he print only.
ford 82000 //
VW 141000 //

<?php
//you need to name your table in this function
function getTotalCost($type){
	$sql = mysql_query("SELECT * FROM table WHERE auto='".$type."'");
	$total = 0;
	while(($fetch = mysql_fetch_array($sql)) !== FALSE){
		$total += $fetch['cost'];
	}

return $total;
}

//use it like this
$ford_total = getTotalCost("Ford");
$vw_total = getTotalCost("VW");

echo 'Ford: '.$ford_total.'<br>';
echo 'VW: '.$vw_total.'<br>';

?>