deleting carts

From: Date: Sun, 25 Feb 2001 04:31:55 +0000
Subject: deleting carts
Groups: php.db 
Request: Send a blank email to php-db+get-6926@lists.php.net to get a copy of this message
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

« previous php.db (#6926) next »