factoring2117 Posted October 24, 2008 Share Posted October 24, 2008 Hello everyone, I am been kicking myself for the last 24 hours with the problem. I decided to come on here and ask for help. I have a set of users who pay to be on a list for a certain amount of time. I would like my script to delete the user from the list when the current $date is > the $expire_date. For some reason I cannot get this to work. Here is my code thus far. <?php $date = date("Y-m-d H:i:s"); $res = mysql_query("SELECT id, myspaceid, nick, image, expire_time FROM `vip` WHERE game = $game_no order by id asc"); while($associate = mysql_fetch_array($res)) { $id = $associate['id']; $expire_time = $associate['expire_time']; if($date > $expire_time) { $delete = mysql_query("DELETE FROM `vip` WHERE `expire_time` = $expire_time"); } else { ?> <center> <table cellspacing="18" cellpadding="0" border="0"> <?php $i =0; if(mysql_num_rows($r) > 0) { echo '<tr>'; while($row = mysql_fetch_array($res)) { if($i % $image_per_row2 == 0) { echo '</tr>'; echo '<tr>'; } $img_src = $row['image']; $myspaceid = $row['myspaceid']; $title = $row['nick']; echo '<td align="center"><a target="_blank" rel="nofollow" href="http://collect.myspace.com/index.cfm?fuseaction=invite.addfriend_verify&friendID='.$myspaceid.'" title="'.$title.'"><img src="'. $img_src .'" height="75" width="75" border="0"></a></td>'; $i++; } ?> <td> <form action="/featured/index.php" method="POST"> <input type="hidden" name="game" value="<?php echo "$game" ?>" /> <input type="hidden" name="amount" value="<?php echo "$amount" ?>" /> <input type="hidden" name="amount2" value="<?php echo "$amount2" ?>" /> <input type="hidden" name="amount3" value="<?php echo "$amount3" ?>" /> <input type="hidden" name="time" value="<?php echo "$time" ?>" /> <input type="hidden" name="time2" value="<?php echo "$time2" ?>" /> <input type="hidden" name="time3" value="<?php echo "$time3" ?>" /> <input type="hidden" name="invites" value="<?php echo "$invites" ?>" /> <input type="hidden" name="invites2" value="<?php echo "$invites2" ?>" /> <input type="hidden" name="invites3" value="<?php echo "$invites3" ?>" /> <input type="hidden" name="item_name" value="<?php echo "$item_name" ?>" /> <input type="hidden" name="item_name2" value="<?php echo "$item_name2" ?>" /> <input type="hidden" name="item_name3" value="<?php echo "$item_name3" ?>" /> <input type="image" src="http://www.spuko.com/images/no_pic.gif" border="0" name="submit" alt="" /> </form></td> <?php echo '</tr>'; } else { //message to come up in case of empty list for a game. echo '<tr><td align="center">NO CREW IN THIS GAME</td></tr>'; } } } ?> </table> </center> Please let me know if you need anymore info. Thanks for your help. Quote Link to comment Share on other sites More sharing options...
Orio Posted October 24, 2008 Share Posted October 24, 2008 You can't compare strings of dates. You need to convert them into time stamps. Try this: <?php $date = time(); $res = mysql_query("SELECT id, myspaceid, nick, image, expire_time FROM `vip` WHERE game = $game_no order by id asc"); while($associate = mysql_fetch_array($res)) { $id = $associate['id']; $expire_time = $associate['expire_time']; if($date > strtotime($expire_time)) { $delete = mysql_query("DELETE FROM `vip` WHERE `expire_time` = $expire_time"); } else { ?> Orio. Quote Link to comment Share on other sites More sharing options...
Orio Posted October 24, 2008 Share Posted October 24, 2008 I also see you are deleting the user from the vip table according to their expire_time. That's not a smart thing to do- you could be deleting more than one user this way. It's better to delete them by their unique value- their ID. Orio. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.