personal accounting program - I need to get the sum of all the entries (mysql table) for today.
the date is inserted into the table in a date("Y-m-d") format
the table fields are id, date (type date) and amount
the code
First off the link identifier $c is not defined anywhere, and secondly you need to use quotes around the date in the query. Other than that, you didn't give any indication of the problem you're having or any errors.
mysql_function(): WARNING: This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQLextension should be used. See also MySQL: choosing an API guide and related FAQ for more information.