I have a TV schedule listing that need to be display in drop down menu as display on this web site - [login to view URL] (only the highlighted areas are needed, ignore the rest)
BACK END
- The data to be entered into DB :
Type - Date - Time - Event - Game - Link Name - Link URL (variable entry up to 20 Links)
So probably we need 3 db. (this is my suggestion but I expect you can provide better solution)
DB one : Type
DB two : Date - Time - Event - Game
DB three : Link Name - Link URL (variable entry up to 20 Link URL , pop up window)
Example of "Type" is Football.
Example of "Event" is "English Premier League".
Example of "Game" is "Arsenal vs Liverpool"
- For data entry
Normally I will add an event few days before the actual day then add/edit links on the actual day. Link Name must have the option to be BOLD. It also must be password protect and no search engine index.
- Script has to erase DB two and DB three automatically on the 8th days of listed date.
Example : I add "Event One" on 1 October 2011, it will be erased on 9 October 2011.
FRONT END (900 width)
- Main Page
The page will show everything found in DB arrange in date and time, showing the type, event and game. Meanwhile the drop down shows the link name and link URL in pop up.
- Individual Page
The individual page will show a particular "Type" that are found in the DB.
Example : If I have Tennis, Rugby and Motor Sports in the DB, there will be 3 individual page for each of them. Tennis page will show tennis schedule only and Rugby page will show rugby schedule only.
- Header ("Type" in green on attached photo)
This is the shortcut to individual page. It will display an icon for every type.
Example :
Football will have the icon address of [login to view URL]
Baseball will have the icon address of [login to view URL]
- Graphic
Preferred to use CSS to display the text and graphic which I need a page can edit the changes.
Noted : The script has to be short and sweet to minimise loading time.
Just click to the attachment here our best projects i have linked. We are having 7 years experience in web development. Please check PMB for more details.
Dear Sir/Madam,
We are specialized in web designing and development. We already complete a huge project, if you intarested then we can PM you our e-profile.
Thank You
With regards,
NBT FIRM