sum column

[mtpocket]

I would like to add(+) a column and sort by date. Everything on particular date = so much. when entering it manually at the mysql prompt it works but not the php code.
Looks as follows :

-snip-

$conn = mysql_connect("myhost", "username", "password");
mysql_select_db("work");
return $conn;
}

function sql_select()
{
global $conn;

$sql = "SELECT SUM(manifest.Quantity) AS `Total Parcels`, SUM(manifest.Weight) AS `Total Weight` FROM manifest ORDER BY manifest.`Date` ";
$res = mysql_query($sql, $conn) or die(mysql_error());
return $res;
}

function sql_getrecordcount()
{
global $conn;

$sql = "SELECT COUNT(*) AS ROWCOUNT FROM (SELECT SUM(manifest.Quantity) AS `Total Parcels`, SUM(manifest.Weight) AS `Total Weight` FROM manifest ) S";
$res = mysql_query($sql, $conn) or die(mysql_error());
$row = mysql_fetch_assoc($res);
reset($row);
return current($row);
} ?>

-snip-

thanks

[Fumigator]

Use GROUP BY to summarize multiple rows.

SELECT date_column, sum(column1), count(*)
FROM table_name
GROUP BY date_column

[mtpocket]

gr8 it worked