blank page with this query?

[$php_mysql$]

friends whenever i include this coding to my page, everything goes blank. how could i fix this?

 

$time_count = 7*24*60*60; // count the 7 days Ads will be deleted

$match_time = time()-$time_count;


$query = "SELECT id FROM classifieds WHERE time<'".$match_time."' ORDER BY RAND() LIMIT 1"; 
  $result = mysql_query($query);

  while($ad_id = mysql_fetch_array($result))

$delete =$ad_id[0];

mysql_query("DELETE FROM classifieds WHERE id='$delete'");

[litebearer]

It appears you want to delete all records which are more than 7 days old. If that is the case, why not just use only one query - delete where datefield is older than 7 days from today. No need to run two queries.

 

Also re:blank page, the portion of your script you show does not have any 'echoing', perhaps we need to see more ???

[$php_mysql$]

this is the only bit of coding i include to my script. could u show a better way to delete? i also got field like imagepath and imale name i need to unlink them too