inserting multiple incrementing values into same column
Posted: Sun Nov 02, 2003 11:01 am
hi there
can u help a newbie who's confused?!!?
i would be really grateful if anyone can help me out. i would like to know how i can insert a series of incrementing date values in date format (eg 2003-10-03, 2003-10-04, 2003-10-05 etc) into seperate rows of a table but in the same 'date' column i have created.
eg table with 3 columns iam using
ID #### booking id### date
1 ##### 1 ######## 2003-10-03
2 ##### 1 ######## 2003-10-04
3 ##### 1 ######## 2003-10-05
i am doing a booking system project in php that the user can hire out a motorhome for a set 7 days. i have managed to get a starting date from the user that then passes that value and the next seven day values from the same form value. However, using a basic insert sql command it only takes the initial date and inserts that. i am assuming that i need to more than the basic sql command i am using
thanks in advance for any help
can u help a newbie who's confused?!!?
i would be really grateful if anyone can help me out. i would like to know how i can insert a series of incrementing date values in date format (eg 2003-10-03, 2003-10-04, 2003-10-05 etc) into seperate rows of a table but in the same 'date' column i have created.
eg table with 3 columns iam using
ID #### booking id### date
1 ##### 1 ######## 2003-10-03
2 ##### 1 ######## 2003-10-04
3 ##### 1 ######## 2003-10-05
i am doing a booking system project in php that the user can hire out a motorhome for a set 7 days. i have managed to get a starting date from the user that then passes that value and the next seven day values from the same form value. However, using a basic insert sql command it only takes the initial date and inserts that. i am assuming that i need to more than the basic sql command i am using
thanks in advance for any help