Help needed with displaying additional mySQL data from a mySQL derived table
Hi, I've been looking at this problem for quite some while now and I'm still trying to figure out if what I want is even possible (which is why I haven't posted my code so far). I'm sure it is as I can see the two parts are fairly straight forward on their own.
I have a mySQL database, with 2 columns, Grade (1-5), and Comments (free text). This gets filled in on a separate form already built and connected with no issues.
On my results page I want to display only the Grade column in a dynamic table that grows with the responses, but have a pop-up that shows the Comments correlating to the Grade when the particular Grade cell is clicked.
I've been using PHP and a looping variable which gets me the dynamic table, but as I've found out can't get me the individual Grade Comments (I get either the first or the last in the series depending on where I put the code).
Any help would be much appreciated, I'm not looking for someone to do this for me (yet!) but pointing me in the right direction, a tutorial, or even if its possible would be great.