nevermind, figure it out, had to take the ' ' away from
contract.length_start :)
Adam Williams wrote:
I have a field in mysql as shown by describe contract;
| length_start | date| YES | | NULL
||
Which stores it in the mysql format of
Why not get MySQL to compare your date with today?
e.g.
select if(Booking_Date = curdate(),'booked','free') as Todays_Status ...
$Todays_Status = mysql_result($result,$i, Todays_Status);
echo you are $Todays_Status today;
I find it is much, much safer to only use the database for finding out
try:
select
date_format(date_add(arrivaldate1, INTERVAL nights1 DAY), '%Y-%m-%d') as
dept_date1
from mytable
where
(date_add(arrivaldate1, INTERVAL nights1 DAY) BETWEEN '2003-02-01' AND
'2003-02-10')
regds,
-Original Message-
From: Dhaval Desai [mailto:[EMAIL PROTECTED]
Hi,
Thanx for yor reply. Well It worked for me with the same query when I used
HAVING instead of where. This is what I got from Mysql Database. However
the solution that you have showed is reall good as well.
Thanx
-Dhaval
From: Uttam [EMAIL PROTECTED]
To: 'Dhaval Desai' [EMAIL
4 matches
Mail list logo