DataAssist only delete most recent item
Hi,
I am creating a page for users to create assignment briefs. In the first instance users enter a name and assign a lecturer etc and then 'save' the information to the database. On the second page (the enclosed page), the information already entered by the user is displayed and then users can attach specific units to the assignment. These units are stored in a db table called 'panelnames' and the assignment briefs are stored in a db table called 'assignments'. These two tables are then "linked" together by a db table called 'assignments_panels'.
When I display these results in a table they work fine but I am not sure if I am doing it right since it is only when I come to delete a record using the Delete Multiple Records option that only the most recent item in the database is deleted. I have enclosed my page for you to look at.
P.S. My one thought is that I am doing something wrong when I pull the linking tables from the db. It is my understanding of linking two tables that this does not physically happen in mySQL. Instead, when adding records I simply include the integer values of the other two tables into the linking table. I should then display these values in a new recordset by using the following for the enclosed page:
SELECT *
FROM assignments_panels, panelnames
WHERE assignments_panels.panelnames_foreign_key = panelnames.ID AND assignments_panels.assignment_foreign_key = paramID
ORDER BY assignments_panels.APID ASC
Variables
paramID is $_GET['AID']