Hi!
I am currently working on a project where I store many files in a mySQL databse. One column of that file talbe contains the files "date".
I am trying to build a page that the right frame will display 12 files.
In the left frame there will form where the user can enter a specific hour & minute, and beneath this, will list ALL the files in groups of 12. For instance " 8:15 -> 8:24 \n 8:26 -> 8:42 \n, etc. "
If you select the hour & minute.. it will display a grouping of 12 files in the right frame, with the one containing the hour & minute you selected...
If you click on one of the 8:26 -> 8:42, it will display 12 files.. starting with 8:26 & ending w/ 8:42 ..
I am not new to mySQL & PHP ... but am having a slight headache when I try to figure this one out..
For instance, should I look at "cacheing" the file groupings.. so that each time the page is displayed PHP & mySQL don't need to figure out how many file grouping of 12 there are, and their start & end times?
One idea I had is to create another mySQL table w/ the following columns:
1) ID - primary / unique key
2) event - Event files are assosiated w/
3) start - beginning file time (ex.8:26)
4) end - ending file time (ex.8:42)
then write a script that will create this table.. and use this table to display the "table of contents" type solution in the left frame?
Thanks!
Brice
