Re: Command Line Error

["Bastien Koert" <bastien_k@xxxxxxxxxxx>]

Goes right where you have it

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

?>

Bastien



> From: "Ron Piggott" <ron.php@xxxxxxxxxxxxxxxxxx>
> To: <php-list-replies@xxxxxxxxxxxxxxxxxxxxx>
> CC: "PHP DB" <php-db@xxxxxxxxxxxxx>
> Subject: Re:  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@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

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