hi, I am stuck trying to figure out how to build a table to display agents names, (that I already have, mysql table etc...) but now I need to add columns dynamicaly. I need to add (programs in witch agents are enroled, and a status of the program ( in-progress, not-done, etc). The part that I can figure out is where would I save the status of the agent in the program.
enroled-agents table: (id, name, email) displays a basic mysql-php-html table;
then I have
programs table: (id, name, description, avaiable-status)
When i place them together, where how do I save the status (in-progress) of agent Smith in the program-1?
basicaly programs is going to be something that the agent needs to acomplish, like a class.
I was thinking of adding more rows to the agents mysql table, but I would like to have more than just one value in the program like (name, description, status).