At 11:31 PM 2/24/01 -0500, Nicholas W. Miller wrote:
>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?

What database?  Assuming an sql type you do a select custid, max(date_added)
(I do most my dates as just ints of unix timestamps) group by custid having
max(date_added) > (timestamp of 90 days ago).  as you select them call a 
function that passes custids that come up, and the function deletes where
custid = thevaluepassed.


=============================
"To dwell within Samsara, however, is to
 be subject to the works of those mighty
 among dreamers."

 - Mahasamatman, in Zelazny's "Lord of Light"

Andrew Apold


-- 
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]

Reply via email to