Need help with the confusing PHP and jquery functionality
I'm trying to create a fantasy game website (yeah ..like fantasy football).
For 2 weeks i was wondering how should i create a webpage for the change(transfers) of players in the user team.
i'll explain. user will be able to sign up and login, which i've done. then he will create his own team by selecting 10 players from pool of players.
So i created a database design (in phpmyadmin) and now i'm stuck at the webpage where user will select players.
In this page, i displayed the available players (pool of players) using php and html table. Now I know, here i'll need some jquery.
Like, when user clicks a players it should be added to his team.
So, here're my problems...
1)How to display selected players (10 players whom user'll select ).
I thought of using html table. Means players will move from 1 html table (table of all players) to another (user team).
and i tried too but it becomes more complicated. Is there any other solution to this??
2)how to put selected 10 players in the DB?
Pls help with this.
i'll provide more info (like code) if you want.
thanks in advance.