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 -MM-
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 ou
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
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]
Se
4 matches
Mail list logo
