Craig Hopson

basicly i want any account older that one week it will send out email saying one week left then after 2 weeks i will delete that member and email telling them "GOODBYE"

hi guys a simple one for you i cant get my head round it this is what i have time is stored as "time()" in database when members signup along with ther name now what i want is to show $row['name'] of all members that are 1 week old $t = time()-604800;$result = mysql_query("SELECT * FROM members WHERE time <= $t");while($row = mysql_fetch_array($result)) {echo $row['name']; } Thanks

err i think the script i'm using my be what you need it works fine apart from attachments which is why i posted in here http://w3schools.invisionzone.com/index.php?showtopic=42926