A questo punto prova a stampare a video la stringa della query

$query = "SELECT object, piecesnum, price, SUM(piecesnum) As n, SUM(price) As total FROM cart WHERE client=".$arrid['id'];
print $query;
$res = mysql_query($query );