Creating a daily log

[ebross67]

I'm creating a daily log for a daycare site. What I'm trying to do - The admin will create daily reports of the children in the daycare. The parents will be able to login and see those reports in their private user section. I have two tables in my database userTable and a dailylogTable. The dailylogTable is linked by userID. I can filter the data by a session variable and display all the daily log records for a specific user. What I can't do is figure out how to sort them by a drop down or input field by date. I want the user to be able to put in a date or pull a drop down menu of dates to display the correct information. Any help would be appreciated.

[Newsgroup_User]

> What I can't do is figure out how to
> sort them by a drop down or input field by date. I want the user to be
> able to
> put in a date or pull a drop down menu of dates to display the correct
> information. Any help would be appreciated.

Broadly speaking you'd create a form element to collect the dat info (like a
drop down list) a button to submit the form, and then a new SQL query to get
the list of logs sorted by date, and then render it back to the screen.

-Darrel

[ebross67]

Is there a tutorial or can you explain in more detail? How do I pass a menu item variable with a form button? I'm confused. I'm new to php mysql and Dreamweaver server behaviors. Please help!