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 table.

Now I want to retrieve the position, name, timein and timeout from by table
and display it on a page. But I want only the records for the present date.
I inserted the info on my table and on the date's field I inserted 07/12/02
and 06/12/02 just for testing

I called the data via a query: SELECT position, name, timein, timeout, date
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

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 that

I mean, I decide to occupy the FSS position from 21:00 to 23:00 on 08th
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??


PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to