第一个结果使用while循环

Question

我创建一个PHP脚本来生成基于存储在SQL数据报表时不显示，查询是在这里：

$sql = $adb->query("SELECT firstname, lastname, policynumber, isatype, isaname, startdate, unitvalue, numberofunits, currentamount, date, newunitvalue, newnumberofunits, newcurrentamount 
           FROM vtiger_isa, vtiger_addisa, vtiger_contactdetails 
           WHERE vtiger_isa.relatedclient = vtiger_addisa.addrelatedclient 
           AND vtiger_addisa.addrelatedclient = vtiger_contactdetails.contactid 
           AND vtiger_isa.relatedclient = $clientid 
           AND vtiger_isa.policynumber = $polnum 
           AND vtiger_addisa.addrelatedclient = $clientid 
           AND vtiger_addisa.newpolicynumber = $polnum 
           ORDER BY date ASC" 
           ); 

因为我已经通过测试，这将执行罚款print_r($sql);和我想要的结果在那里。尽管当我循环播放结果时，他们没有显示出来。我已经测试过不同的clientid，第一个结果似乎错过了。

<b> New Figures:</b> 
<table style="width:100%"> 
<tr> 
    <th>Date</th> 
    <th>Unit Value (P)</th> 
    <th>Number of Units</th> 
    <th>Total Value (£)</th> 
    </tr> 
<?php 
while ($sql->fetchInto($row)) { 
    ?> 
    <tr> 
    <td><?php echo $row['date'];?></td> 
    <td><?php echo $row['newunitvalue'];?></td> 
    <td><?php echo $row['newnumberofunits'];?></td> 
    <td><?php echo $row['newcurrentamount'];?></td> 
    </tr> 
    <?php 
}?> 
</table> 
</body> 
</html> 

Answer 1

我没有使用fetchInto()方法。我用下面的例子：

<?php 
$sql = $adb->query("..."); 

foreach($sql as $row){ 
    ?> 
    <tr> 
    <td><?php echo $row['date'];?></td> 
    <td><?php echo $row['newunitvalue'];?></td> 
    <td><?php echo $row['newnumberofunits'];?></td> 
    <td><?php echo $row['newcurrentamount'];?></td> 
    </tr> 
    <?php 
} 
?> 

这是每次都在工作。试试看。