Re: Command Line Error

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 �������؇�I� > > ���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 ---------- >