Cron job not taking effect

[$php_mysql$]

could someone check what is wrong in this code that no db entry nor image is being deleted

 

$time_count = 2*24*60*60; 
$match_time = time() - $time_count; 
$sql="SELECT id FROM tbl WHERE adtime < '".$match_time."'";
$result=mysql_query($sql);
if(!$result){
echo 'SELECT failed: '.mysql_error();
}else{
while($row=mysql_fetch_array($result)){
$id = $row['id'];
if(!unlink($row['image'])){
echo "unlink ".$row['image']." failed";
}else{
}
$sql="DELETE FROM tbl WHERE id = '".$id."'";
$result= mysql_query($sql);
if(!$result){
echo 'DELETE from tbl with id '.$id.' failed: '.mysql_error();
}
executeSql($sql);
} 
} 

[Maq]

Can you run it in a regular script?  If it doesn't work specifically when you run it in cron then it's probably permissions.

 

I don't see any DB connection credentials either.

[darkfreaks]

Make sure your chmod permissions on crontab.php script is set to 755 or 777

 

 

http://net.tutsplus.com/tutorials/php/managing-cron-jobs-with-php-2/

 

This really explains how to create a PHP class that handles cron jobs using PHP.

 

 

[$php_mysql$]

yes i can run it on regular script without errors but its just not doing its job, how do i set permission if required?

[$php_mysql$]

oh thats soo much , let me try it