deep958 Posted June 14, 2017 Share Posted June 14, 2017 i make my cron job file in php code and upload it . but it doesnt work my cron job file is this : <?php $con=mysqli_connect("localhost","name","pass"); mysqli_select_db($con,"table"); $t=time(); $a=mysqli_query($con,"select * from signup");$anum=mysqli_num_rows($a); for($i=1;$i<=$anum;$i++) { $arow=mysqli_fetch_array($a); $avalid=$arow['valid']; $email=$arow['email']; if($avalid<$t) { mysqli_query($con,"delete from signup where email='$email'"); } } ?> plz help me to solve my problem Quote Link to comment Share on other sites More sharing options...
Krydos Posted June 14, 2017 Share Posted June 14, 2017 What is the error message? Quote Link to comment Share on other sites More sharing options...
deep958 Posted June 14, 2017 Author Share Posted June 14, 2017 there is no error message and no work is performed by it . but when i execute it by my own then it works fine Quote Link to comment Share on other sites More sharing options...
Krydos Posted June 14, 2017 Share Posted June 14, 2017 I talked to him on IRC chat and his command was /home/deep958/public_html/cron.php which doesn't do anything because it needs to be something like php /home/deep958/public_html/cron.php 1 Quote Link to comment Share on other sites More sharing options...
Luigi123 Posted June 17, 2017 Share Posted June 17, 2017 Moved to Customer Service. Quote Link to comment Share on other sites More sharing options...
deep958 Posted June 17, 2017 Author Share Posted June 17, 2017 thanks krydos now its working 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.