[thelist] PHP/MySQL/sum()

[Richard Bennett]

On Sunday 09 April 2006 10:04, rogerharness at comcast.net wrote:
> $query = "select * from my_table where unique_id = '$unique_id'";
Hi,
Replacing the above with something like this should do it:
$query = "select unique_id, max(name) as name, sum(hours) as hours from 
my_table where unique_id = '$unique_id' group by unique_id";

Hope that's what you meant.

Richard