I am currently trying to pass a variable from one page to another then load the query on that page with the passed variable.
My code is as follows:
Awaiting Variable
if(isset($_POST['viewrecord'])){
$sup_code = $_POST['vhidden'];
}
SQL Query
$sql = "SELECT sup_code, firstname, lastname, email, telephone
FROM dbo.table
WHERE sup_code = ('$sup_code')";