Display contents of database by date.
Posted: Tue Jun 24, 2008 9:30 am
Hi all, i'm new to devnet. I've been browsing it for a while now and its helped me out with a lot of stuff in the past so i'd like to say a general thank you to everyone first.
Now on to my question, i'm sorry if I can't explain it perfectly, as i'm not too sure how to describe it.
I'm making website for a local sports league. In my database I have 2 tables one to display and store the league data and one to display the results of each indivual match. I have built a form where I input the date, teams, scores. This for then updates both tables.
I can make the league table and results update and display perfectly. To display my results I use SORT BY DESC date. However, I would like to able to display my results by having a seperate table for each date. Starting from the newest to oldest. e.g:
Date 10/5/08
Team A 1 - 2Team B
Team C 0 - 2Team D
Date 03/5/08
Team E 2 - 2Team F
Team G 3 - 2Team H
I don't want to have to manually edit and add a new table each week. I was hoping that everytime I update my database, my page would automatically update itself starting with the newest date and descending to the oldest date.
Any help would be great! Thanks
Now on to my question, i'm sorry if I can't explain it perfectly, as i'm not too sure how to describe it.
I'm making website for a local sports league. In my database I have 2 tables one to display and store the league data and one to display the results of each indivual match. I have built a form where I input the date, teams, scores. This for then updates both tables.
I can make the league table and results update and display perfectly. To display my results I use SORT BY DESC date. However, I would like to able to display my results by having a seperate table for each date. Starting from the newest to oldest. e.g:
Date 10/5/08
Team A 1 - 2Team B
Team C 0 - 2Team D
Date 03/5/08
Team E 2 - 2Team F
Team G 3 - 2Team H
I don't want to have to manually edit and add a new table each week. I was hoping that everytime I update my database, my page would automatically update itself starting with the newest date and descending to the oldest date.
Any help would be great! Thanks