There are 2 parts to this project. This is the first part. Please read all the information in detail.
I currently have a mysql database that shows rows and columns of data based on each user. I would like all the data to be shown on my website for each user and the user will have a few options to select for each row of data he sees. Once he selects an option, it will be updated in the mysql database.
If you see the first picture (account_table) you will see that every user has a unique "Account Number" and a "Pass". These are the 2 fields which a user would key into in wordpress to help the script look for his account. When the account number and pass matches, it will access the "Trades" table to view all his data. A user can add an unlimited number of accounts to his wordpress account as long as the "account number" and "pass" matches.
In the second picture (trades), you can see all the rows there. All these rows will be displayed to the user on a page called "Forex Business Plan". The only thing a user can edit for each row that is displayed to him is the "Entry" and "Strategy" columns. The complete picture and explanation of this can be seen in the third picture (assigned trades).