Yes it has results when you first view the page, but not after it submits.
The recordsets depend on the ID being sent through the url, but your form action doesn't carry it through.
To solve the problem change your form action from: <form action="job-status.php" to: <form action="" and then it will automatically carry forward any url parameters through the submit.