When running on my webserver (hosted via https://www.asurahosting.com/) I get error 500 after logging in. When running on my localhost server (XAMPP on my computer) it runs fine.

The loading time of the page is very very long, and the small sections is coming one by one. It is because I am using 3 WHILE loops. Is there any other way so that I can reduce the loading time ?

I was asked to fix a PHP script that wasn’t updating everything in SQL. It uses a website to update a Microsoft SQL database. there are two SQL columns that were not communicating/updating, those being, “ID” and “Roster ID”. This bug was found when an employee would quit and than be rehired and their old Roster ID would be updated with certifications not the new Roster ID.

I need to delete those rows from the Database (from the table) that were selected by me in the checkbox. That is, if the button is pressed, and the check box is pressed, it should be deleted.