Hi,
Before you save entries into database, get the count of the entries for that day, check on google for "SQL COUNT". when you get the count of entries in the db for that selected day, use (count + 1) as your serial number on the new entry.
SELECT COUNT(Datecolumn) FROM Customers WHERE DateColumn='2013-03-05'
Hope this helps.
Regards
Jegan