yah would be possible.... pseudo code to follow....
if ($i_have_no_imagination_feed_me_everyday)
{
//insert their data into table_feed_me_nothing_original
}
else
{
//i have imagination, feed me something different everyday
}
and the actual PLACING of the daily order is a bit trickier... you would either have to a person logon to a "special page" or include a trigger in say your index.php that gets called ALL the time from people going to the site....
//included to check re-occuring daily orders
$store_opens '07:00:00'; //set as opening time for store any orders not done after this time are reordered on the first page load after $store_opens
SELECT * FROM table_feed_me_nothing_original WHERE last_ordered < UNIX_TIMESTAMP(CONCAT(CURDATE(), '$store_opens'))
while row = fetch_array($result)
{
//loop through and place each reoccuring order that hasnt already been auto placed
UPDATE table_feed_me_nothing_original SET last_ordered=NOW() WHERE orderID=$orderID
//send email or whatever to customer to remind them of their order....
}
ugly... yah... but it would work.... other option is to have your HOST setup a crontab running your "auto schedule" php file every 15 minutes or so.... or every day at a certain time... however you want it...
