How do I increment dates?

[dee]

Hi,
I was wondering if anyone could help me with some php stuff. I have created a mysql database and a table which includes a date for dispatching goods, I want customers to be able to repeatedly order these goods on a monthly basis based on the initial date of the order. How would I be able to output this so that the sales rep would be able to view the repeat orders for each day for each customer so that they can disptach them automatically to these customers.

[girishn]

Hi,

the better way is to get the records from table for the current month.

SQL:- select * from table_name where DATE_FORMAT(date_field,"%m-%Y") = "$month-$year" ORDER BY date_field

So the $month & $year will come from php $month=date("m") etc.

hTh

[dee]

Hi, thanks for that...however..firstly, I want to be able to automatically generate repeat orders every month based on the initial date, how do i do this??? I then want to be able to access all the orders placed by customers on a certain day, so that these orders can be dispatched...for eg. i would like to see all the customer orders that are to be dispatched next month...
am not sure if this explanation is clear..i hope you get what i mean....

[girishn]

Hi,

As you are talking in General terms so I would also like to explain thing in general

1) You want to automate the system of repeat order. So you can make a script which checks for cutomers having initial date = multiple of 30. So then it will take these customer id and generate the orders. To automate this script run this as a cron job(if you are on a Linux box). So that this script is run once a day.

2) you want to see the orders placed for current day. Ok, then you run a query to check for orders which have date = todays date(Or if you create a form to select a date then date will come from there) .

HTH
Cheers!
Note: Can use e-mail if you want specific help!
<[e-mail]>