Re: [PHP-DB] 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,$passw
ord);
@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 ---------- 
>
> ---------- End Original Message ----------
>

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,$passw
ord);
>@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
>
> 
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
>