Hi Nick,
Of course it's possible. Anything is possible. Simply generate a simple PHP
script that will be executed from the command line which is called from a
cron. The PHP script would simple delete any records where (current date) -
(your date_added) >= 90 days.
On the other hand, on the shopping cart that I wrote, I did it another way;
instead of creating a separate script and additional external components
(the cron for example), simple create 1 function that holds the
functionality needed to delete the old records. Then just call the function
each time your cart script is called. There's no reason to create a cron to
delete records because you can have the shopping cart script do it
automatically...
Hope this helps,
Jorge
[EMAIL PROTECTED]
----- Original Message -----
From: Nicholas W. Miller <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 24, 2001 11:31 PM
Subject: [PHP-DB] deleting carts
> 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]
>
--
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]
