Goes right where you have it

#!/<path to php cli binary>
<?php
...rest of your script

?>

Bastien



From: "Ron Piggott" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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: <[EMAIL PROTECTED]>
To: Ron Piggott <[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]> > > 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


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



Reply via email to