well i need some help
i am looking to build several databases for my local soccer team;
Tournaments name, location, logo
Each tournament; teams, logo and location:: in DB i was not able to connected with first DB. i was hoping that i could have a dropdown from first DB easier to manage
Games Schedule (date, time, away team, home team, their logos, which tournament), here as the second DB should be connected to first; the third DB will be easier to fill but for now i was not able to connect them, so i have to re-enter tournament name, then i have again to enter away team name and bring logo again. Also to add result
our team player name, player number, cards (red/yellow), goals, assist , position and so on
then i want to use dynamic pages to do the following
page for fixture, showing 3rd DB, with two filters by date filter, by tournament filter.
page for showing team player info (all).
page to show each player: after selecting from table it goes to new page. at the page there will be dropdown to select players from DB. in page it shown player info, pic and all those stuff
page to show each tournament and the status of our team
page for team services
in main page i need to connect WIX countdown to game schedule so that it shows
before game: count down for the next game showing home and away teams and logo as well as the tournament name.
while playing (same day, after reaching the set time) to show LIVE word (the result will be updated so it will show it too)
after we select gameEnd (Boolean) it will count down for the next game
so if there is any help in DB connection instead of repeating the inputs will be very nice,
sorry for my long post