Rebate Expire Date Not Working

[rickeyl]

I have an oscommerce database with a couple of added tables in the products table. The first table is products_rebate which I have setup to be populated from the admin side of the website, this works fine. The second table is the products_rebate_expire. This is also populated from admin.
My problem is that when the expiration date passes, it dosen't remove the product rebate from the product. Is this a MySql problem or is it PHP?
Thanks, Rickey

 

[vacunita]

I would guess its a PHP issue, as MySQL on its own has no way of deciding when something should be removed.






----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[rickeyl]

Thanks, I'll keep searching the PHP forums and maybe find an answer. I am a newbie to php and sql.

 

[vacunita]

You can post the relevant sections of your code in the forum434.

I'm sure someone there will be able to help you.


----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.