Home > Archive > PHP DB > March 2005 > Re: [PHP-DB] Command Line Error
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Re: [PHP-DB] Command Line Error
|
|
| Ron Piggott 2005-03-28, 3:56 pm |
| 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 ----------
>
| |
| Bastien Koert 2005-03-28, 3:56 pm |
| 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
>
|
|
|
|
|