Select as sum() all records of today

[Scott Haneda]

I have the following table transaction
+------------+---------------+------+-----+---------+----------------+
| Field      | Type          | Null | Key | Default | Extra          |
+------------+---------------+------+-----+---------+----------------+
| id         | int(11)       |      | PRI | NULL    | auto_increment |
| user_id    | int(11)       |      |     | 0       |                |
| amount     | decimal(6,2)  |      |     | 0.00    |                |
| trans_type | varchar(12)   |      |     |         |                |
| error      | varchar(80)   |      |     |         |                |
| added      | timestamp(14) | YES  |     | NULL    |                |
+------------+---------------+------+-----+---------+----------------+

I need to do a
Select SUM(amount) from transaction WHERE added ..... Is in todays data
range.  Can someone help me with this one, thanks.

-------------------------------------------------------------
Scott Haneda                                Tel: [phone]
http://www.newgeo.com                       Fax: [phone]
scott@stripped                            Novato, CA U.S.A.