I have created a project in phprunner with two identical tables. I inserted a button for each row and what I would like to do is, when the task is completed for that row the user must click the row button to move the record to the other table. I am using phpmysql. Can someone please help me with this issue. I have tried many codes from my searches online to no avail. Many thanks.
what is phpmysql? anyway, you have to perform an insert and a delete statement.
You are already off on the wrong foot. Tell us about the high level overview of what you have going on.
Sorry, Benanamen, what I meant to achieve is to move a row from one list page to another by inserting a button on that row. Please help, I using phprunner and I’ve tried googling but to no avail.
Once data is inserted into a table, it is almost never moved or deleted. You may insert a reference to data into a foreign table, or update a value in a row that indicates something changed about the data.
Based on your statement about a ‘task is complete’, what you should probably be doing is inserting a row in a status table indicating the Who, What, When, Where, and Why information about each status change for a task.
Without a specific example of what your data is and what it means to ‘move’ a row of it, we cannot specifically help you.
The best solution, that doesn’t involve a lot of backtracking, would need to take into account all the extents and limits of what you are actually doing.