Not sure but I think now() doesn't return the date formate you'd want
assuming your date section is classified as a date. Here's what I would do:

$date = date("Y-m-d");
$sql = "SELECT * FROM table WHERE date='".$date"'";
$result = mysql_query($sql, $connection);

Hope it works!

----- Original Message -----
From: "Miguel Brás" <[EMAIL PROTECTED]>
Sent: Friday, December 06, 2002 10:39 PM
Subject: [PHP] Date again

> Ok guys,
> having a problem here. I did my table with 6 fields, they are:
> id  position  name  timein  timeout  date
> I have a form to insert the info on the fields, and at the date field, I
> have a drop down menu that returns me the next 7 days (the date in d/m/y),
> people will choose the date they want and that will be stored on the
> Now I want to retrieve the position, name, timein and timeout from by
> and display it on a page. But I want only the records for the present
> I inserted the info on my table and on the date's field I inserted
> and 06/12/02 just for testing
> I called the data via a query: SELECT position, name, timein, timeout,
> FROM table WHERE date=NOW()
> It was supposed that only the record from the present date was shown. But
> not, I can't have anything. Only the custom message I did if nothing was
> available
> What is missing here? Looked at PHP manual, time, date mktime and so on
> functions, but nothing.
> Anybody for a hand?
> One more thing, how can I do to prevent that different people apply for a
> same position, on the same day and during the "shift" of the first one
> applied?
> I mean, I decide to occupy the FSS position from 21:00 to 23:00 on 08th
> Decemeber.
> Someone come and try to apply also for FSS but from 19:00 to 20:30 or from
> 21:30 to 22:30. Since the position is occupied during a portion of the
> requested time or during all the requested time, how can I prevent this to
> be added on the table??
> Thx
> Miguel
> --
> PHP General Mailing List (
> To unsubscribe, visit:

PHP General Mailing List (
To unsubscribe, visit:

Reply via email to