How to count database value

[ghjk]

I want to get the some of all values in given date range. This is my code and it prints all data correctly. But couldn't get the sum. Please tell me what is wrong?

[PHP]$q = mysql_query("SELECT * FROM db WHERE SID = '$SID' AND Date BETWEEN '$DateFrom' AND '$DateTo'");
//echo $Date;
while($row = mysql_fetch_array($q)){
foreach( $row AS $key => $val ){
$$key = stripslashes( $val );
}
$Riml=$row["Rim"];
count ($Rim);
echo $Rrim;

}

}[/PHP]

[Markus]

I want to get the some of all values in given date range. This is my code and it prints all data correctly. But couldn't get the sum. Please tell me what is wrong?

[PHP]$q = mysql_query("SELECT * FROM db WHERE SID = '$SID' AND Date BETWEEN '$DateFrom' AND '$DateTo'");
//echo $Date;
while($row = mysql_fetch_array($q)){
foreach( $row AS $key => $val ){
$$key = stripslashes( $val );
}
$Riml=$row["Rim"];
count ($Rim);
echo $Rrim;

}

}[/PHP]

I think mysql_num_rows() is what you're after:
[php]
$_query =
mysql_query("
SELECT
*
FROM
`tbl_name`
WHERE
`tbl_col`
=
'{$_something}'
"; # lets say this affects 4 rows in the table `tbl_name`

$_num_rows = mysql_num_rows($_query)

echo "Rows affected: {$_num_rows}";
[/php]