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@xxxxxxxxxxxxxxxxxxxxx>
To: Ron Piggott <ron.php@xxxxxxxxxxxxxxxxxx>
Sent: Monday, March 28, 2005 11:02 AM
Subject: Re: 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@xxxxxxxxxxxxxxxxxx>
> > To: PHP DB <php-db@xxxxxxxxxxxxx>
> > Date: Monday, March 28, 2005 09:54:00 AM -0500
> > Subject: 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
