I am developing a shopping cart style e-commerce web site. I have a
table called carts that holds users' cart items ... so one user may
have several entries in this table:
+----------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+--------------+------+-----+---------+-------+
| cust_id | int(11) | | | 0 | |
| item_id | int(11) | YES | | NULL | |
| qty | tinyint(4) | YES | | NULL | |
| price | float(10,2) | YES | | NULL | |
| date_added | timestamp(6) | YES | | NULL | |
+----------------+--------------+------+-----+---------+-------+
I would like to write a PHP script that I will cron which will delete
all items belonging to a user if their most recent item is over 90
days old.
Is this possible?
Nick
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
