Skip to main content
E
ebross67
Participant
July 14, 2008
Question

Creating a daily log

  • July 14, 2008
  • 1 reply
  • 244 views
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.
This topic has been closed for replies.

1 reply

N
Newsgroup_User
Inspiring
July 14, 2008
> 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


E
ebross67Author
Participant
July 15, 2008
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!
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices