Sorry, I forgot to add the part at the bottom where I am calling the
function
=
?
function tips($weekstart){
$start = date('Ymd',strtotime($weekstart));
$query = SELECT * FROM Rota WHERE date = $start and date = ($start +
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 functions (generates parse error)
Sorry, I forgot
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,
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
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 WHERE I
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
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
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 have