hi all, i am trying to take a datefrom and dateto from a user and insert all hour records within that date range within the db. eg, if the user selects 2006-03-14 as datefrom and 2006-03-14 as dateto, the system would insert 24 rows within the table with their corresponding timestamps (eg 2006-03-14 01:00:00....2006-03-14 23:00:00). any suggestions on how to do this. thanks.