PHP and MySQL Programming/Common Functions and Operators

COUNTEdit

mysql_query(" SELECT COUNT(*|`field_name`) FROM `table_name` ");

SUMEdit

mysql> SELECT SUM(`field_name`) FROM `table_name`;