SUM and GROUP BY

$result = mysql_query("SELECT SUM(conversions) AS mysum,campaign FROM table WHERE client='$client' AND date BETWEEN '$startdate' AND '$enddate' and time = 23 group by campaign");