[SOLVED] Cronjob returns syntax error

[The14thGOD]

I have a cron job going and its finding the right file but it's emailing me back with errors. Syntax errors, but if I run it from the browser it runs fine.

 

Error:

/var/path/to/domain/httpdocs/csv_db.php: line 1: ?php

: No such file or directory

/var/path/to/domain/httpdocs/csv_db.php: line 2: syntax error near unexpected token `('

/var/path/to/domain/httpdocs/csv_db.php: line 2: ` $dbh = mysql_connect("localhost","username","password");

 

CronJob:

52 * * * * /var/path/to/domain/httpdocs/csv_db.php

 

Start of PHP:

<?php
$dbh = mysql_connect("localhost","username","password");
mysql_select_db("db");	
$date = date("Y-m-d H:i:s");?>

 

Any ideas?

Thanks in advance,

Justin

[taquitosensei]

try

52   *   *   *   *   "php /var/path/to/domain/httpdocs/csv_db.php"

 

not sure if you need the quotes around the whole command or not

[trq]

Looks like your missing your shebang and therefor bash is trying to execute php. that won't work.

 

Add this to the top of your script.

 

#!/usr/bin/php

 

Of course, you'll need to change that to the correct path to the php executable.

[The14thGOD]

nope that didnt work, i got a different error however i found this tutorial:

http://www.htmlcenter.com/blog/running-php-scripts-with-cron/

 

basically if you have Apache handling ur PHP and not CGI, you do:

 

30  *  *  *  *  http://www.example.com/cron.php