t - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/
> -Original Message-
> From: David Rice [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 05, 2003 12:34 PM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: [PHP-DB] date funct
Sorry, I forgot to add the part at the bottom where I am calling the
function
=
$start = date('Ymd',strtotime($weekstart));
$query = "SELECT * FROM Rota WHERE date >= $start and date <= ($start +
INTERVAL 6 DAY) ORDER BY staff
> Here is the whole code of my function
>
> Whenever i run it, it say's there is a parse error on line 6, can't see
what
> is the problem
> the format of $weekstart (as it is stored in the Database) is -MM-DD
>
> =
> function tips
Here is the whole code of my function
Whenever i run it, it say's there is a parse error on line 6, can't see what
is the problem
the format of $weekstart (as it is stored in the Database) is -MM-DD
=
$start = date('Ymd',strto
> I want to use it in this function that i am creating (it's for a
resteraunt
> automated tips system, to work out how much tips each staff member is
> entitled to.
>
>
> function tips($weekstart){
> /* JUST BELOW HERE IS WHER
Good stuff here.
http://www.mysql.com/doc/en/Date_and_time_functions.html
Check out the SELECT DATE_ADD section. That might be what you're looking
for.
HTH,
Rich
> -Original Message-
> From: David Rice [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 04, 2003 9:36 AM
> To: [EMAIL PROTEC
> I am looking for a way to take a date stored in a mysql database... and
find
> out the date seven days later.
>
> how would i do this?!
too easy...
SELECT date_column + INTERVAL 7 DAY FROM your_table ...
---John Holmes...
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, vi
On Mon, 1 Jul 2002, Achilleas Maroulis wrote:
> Hi.
> I want to know what is the right way to make some comparisons with date variables.
> I have used only the date() function to get a variable in this format=> 01-07-2002
> Is there a way to add 20 days in order to have 21-07-2002 or 2 months to