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 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 that 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 (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
