Re: Command Line Error

Goes right where you have it #!/<path to php cli binary> <?php ...rest of your script ?> Bastien

From: "Ron Piggott" <ron.php@actsministries.org> To: <php-list-replies@listmail.innovate.net> CC: "PHP DB" <php-db@lists.php.net> Subject: Re: [PHP-DB] Command Line Error Date: Mon, 28 Mar 2005 12:35:09 -0500 I didn't realize I was required to do this. Would you put this line where it belongs? I am not sure what to do with the <? and ?> and if these are needed for the script to run from the command line. Ron #!/<path to php cli binary> <? $todays_date=DATE("Y-m-d"); $username="user"; $password="password"; $database="database"; mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $query = "DELETE FROM webcardtable WHERE date_to_be_deleted LIKE '$todays_date'"; mysql_query($query); mysql_close(); ?> ----- Original Message ----- From: <php-list-replies@listmail.innovate.net> To: Ron Piggott <ron.php@actsministries.org> Sent: Monday, March 28, 2005 11:02 AM Subject: Re: [PHP-DB] Command Line Error are you putting: #!/<path to php cli binary> at the top of your page? if not, it will be interpreted as a shell (bash/csh) script. ---------- Original Message ----------

From: Ron Piggott <ron.php@actsministries.org> To: PHP DB <php-db@lists.php.net> Date: Monday, March 28, 2005 09:54:00 AM -0500 Subject: [PHP-DB] Command Line Error I wrote a really simple 11 or 12 line PHP script to remove old entries from a web card application I made: <? $todays_date=DATE("Y-m-d"); $username="user"; $password="password"; $database="database"; mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); $query = "DELETE FROM webcardtable WHERE date_to_be_deleted LIKE '$todays_date'"; mysql_query($query); mysql_close(); ?> When this is run from the web it works fine. I wanted it on a CRON ---- then the expired entries are removed automatically. Take a look at this line: $todays_date=DATE("Y-m-d"); When it is ran from the command line this line causes the script to give these error messages: /home/actsmin/actsministries-www/webcards/administration/daily_main tenance.p hp3: line 3: syntax error near unexpected token `DATE("' /home/actsmin/actsministries-www/webcards/administration/daily_main tenance.p hp3: line 3: `$todays_date = DATE("Y-m-d");' Any idea why the command line can't deal with but the http:// version works just fine? Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

---------- End Original Message ---------- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php