SQL question..

[MemphiS]

I wish to retrieve all data from a column which is called "cost"

 

Example:

 

$query = mysql_query("SELECT `cost` FROM `table` WHERE `id` = '1'"); // 10 users may have the id "1"

while ($getcost = mysql_fetch_row($query)){

$start = 0;

$overall = $start += $getcost[0];

}

echo "$overall";

 

Problem is it only gets the last record in the table instead of adding all the values together

 

Anyone have a solution

 

Thanks

[chigley]

Quicker way:

 

$query = mysql_query("SELECT SUM(cost) FROM table WHERE id = 1") or die(mysql_error());

 

Alternatively put start = 0 before the while.

[MemphiS]

Thanks chigley