<?php
include("conn/connfoxpro.php");
$get_data1=$_POST["txtKeyword4"];
$get_data2=$_POST["txtKeyword5"];
$sqlobj3 ="SELECT * FROM t_contract_obj INNER JOIN m_obj ON t_contract_obj.objid=m_obj.objid WHERE (contractid LIKE '%".$get_data2."%' ) ";
$results3 = odbc_exec($conn,$sqlobj3);
?>
<body>
<table width="390" border="1" cellspacing="0" cellpadding="0"> <tr>
<td colspan="2"><span class="style2">รายละเอียดการใช้เงินกู้</span></td></tr>
<?php $q=1;
while (odbc_fetch_row( $results4 )) {
$AA1 = odbc_result($results4,"objname");
$AA2 = odbc_result($results4,"objamt");
?>
<tr><td width="334"><?php print "$q";?>.<? echo "$AA1";?></td>
<td width="50"> <? $number=$AA2; echo "".number_format($number,2,'.',',')." "; ?> <?php $q++; } ?> </td></tr>
<tr><td><span class="style2">รวมเงินกู้</span></td><td> </td></tr>
</table>
</body>
ผลที่ได้
ช่วยดู code while odbc_fetch_row ให้หน่อยครับ
include("conn/connfoxpro.php");
$get_data1=$_POST["txtKeyword4"];
$get_data2=$_POST["txtKeyword5"];
$sqlobj3 ="SELECT * FROM t_contract_obj INNER JOIN m_obj ON t_contract_obj.objid=m_obj.objid WHERE (contractid LIKE '%".$get_data2."%' ) ";
$results3 = odbc_exec($conn,$sqlobj3);
?>
<body>
<table width="390" border="1" cellspacing="0" cellpadding="0"> <tr>
<td colspan="2"><span class="style2">รายละเอียดการใช้เงินกู้</span></td></tr>
<?php $q=1;
while (odbc_fetch_row( $results4 )) {
$AA1 = odbc_result($results4,"objname");
$AA2 = odbc_result($results4,"objamt");
?>
<tr><td width="334"><?php print "$q";?>.<? echo "$AA1";?></td>
<td width="50"> <? $number=$AA2; echo "".number_format($number,2,'.',',')." "; ?> <?php $q++; } ?> </td></tr>
<tr><td><span class="style2">รวมเงินกู้</span></td><td> </td></tr>
</table>
</body>
ผลที่ได้