问为什么我的一个专栏显示为空？

EN

 <?php
include('connect.php');
$start = isset($_GET['d1']) ? $_GET['d1'] : '';
$end = isset($_GET['d2']) ? $_GET['d2'] : '';
if(isset($_GET['submit']) && $_GET['submit']=='Search')
{
$result = mysql_query(
"SELECT 
   t1.qty, 
   t2.lastname, 
   t2.firstname, 
   t2.date, 
   t3.name,  
   t2.reservation_id, 
   t2.payable FROM prodinventory AS t1
INNER JOIN reservation AS t2
ON t1.confirmation=t2.confirmation
INNER JOIN products AS t3
ON t1.room=t3.id
WHERE str_to_date(t2.date, '%d/%m/%Y') BETWEEN
   str_to_date('$start', '%d/%m/%Y') AND
   str_to_date('$end', '%d/%m/%Y')
GROUP BY t2.confirmation") or die(mysql_error());   
while ($row = mysql_fetch_array($result)){
echo'<tr class="record">';
echo '<td>'.$row['reservation_id'].'</td>';
echo '<td>'.$row['date'].'</td>';
echo '<td>'.$row['firstname'].' '.$row['lastname'].'</td>';
echo '<td><div align="left">';
$rrr=$row['confirmation'];
$results = mysql_query("SELECT * FROM prodinventory where confirmation='$rrr'");
    while($row1 = mysql_fetch_array($results))
            {
                $roomid=$row1['room'];
                $resulta = mysql_query("SELECT * FROM products where id='$roomid'");
                    while($rowa = mysql_fetch_array($resulta))
                        {
                        echo $rowa['name'].' x';
                        }
                        echo '&nbsp;&nbsp;&nbsp;'.$row1['qty'].'<br>';
                        }
                        echo '<td>'.'PHP ' . number_format(floatval($row['payable'])); 
}
?>