Having issues converting pages: code as follows: Not retrieving info from database. Info required from two tables
<?php if (isset($_GET['btnSubmit'])) { //Does not display data until button is submitted
$query = "SELECT Packlist_Detail.Packlist, Packlist_Detail.Job, job.Unit_Price, Packlist_Detail.Quantity, job.Price_UofM, job.Total_Price," .
" Job.Description, Job.Rev, Job.Customer_PO, Job.Customer_PO_LN, Delivery.Shipped_Date, Job.Part_Number" .
" FROM Packlist_Detail INNER JOIN Job ON Packlist_Detail.Job = Job.Job INNER JOIN Delivery ON Job.Job = Delivery.Job" .
" WHERE(Packlist_Detail.Packlist = '" . $row['packlist'] . "')";
$results = sqlsrv_query($connPPP, $query);
?>
<?php
while ($row = sqlsrv_fetch_array($results)) {;?>
<h4><strong>Shipped On:</strong><?php echo $Shipped_Date = $_GET['Shipped_Date'];?></h4>
<h4><strong>Job:</strong> <a href="/portal/invoicing/jobcostdetail.asp.job=<?php echo $row['job']?>&selecteddate=<?php echo SelectedDate?> . invoice=<?php echo invoice?>" target="_blank" echo $row['job']?></a></h4><br>
<strong>Part Number:</strong> <?php echo $row['Document_Date'];?><br>
<strong>Revision:</strong> <?php echo $row['rev'];("rev")?> <br>
<strong>Quantity Ordered:</strong> <?php echo $row['quantity'];("quantity")?>/<?php echo $row['Price_UofM']?><br>
<strong>Description:</strong> <?php echo $row['description'];("description")?><br>
<strong>P.O.:</strong> <?php echo $row['stomer_PO'];("Customer_PO")?><br>
<strong>P.O. Line:</strong> <?php echo $row['Customer_PO_LN'];("Customer_PO_LN")?><br>
<strong>Unit Price:</strong> $<?php echo $row['Unit_Price'];("Unit_Price")?><br>
<strong>Total:</strong> $<?php echo $row['Total_Pric'];("Total_Price")?>
<hr>
<?php ;} //End of button submit ?>
<?php ;} //End of while ?>