How do i expire memberships ?

help !

I have a modelling website

the models membership needs to be deactivated if and when their height OR photos OR GP letters are out of date.

Height and shots have to updated 3monthly for younger ages and
6 monthly for middle years and then annually for older ones.
GP letters expire after 6 months (for all ages groups)

how can i get PHP to automate this for me & also to send an email to the model explaining why their account has been suspended?



thanks

 

i would use cron jobs to do this something like this

<?php
include "./../config.php";
mysql_query('DELETE FROM comments WHERE date < DATE_SUB(NOW(), INTERVAL 10 DAY') or die (mysql_error());

echo "If No Error <br><br>ALL DELETED<br>";

?>

PHP:

then just use cron to run once a day there is better ways but im not the best myself

 

Wow !

thats great that has really helped me,

i think i was trying to make things very hard for myself

many thanks

 

your welcome mate keep up the wows