表中字段price的格式是decimal(8,2)
<?php  echo($row["price"]) ?> 显示为0
请问它在PHP里要如何调用啊? 小弟严重不解,希有高人指点。全部代码如下:
<?php 
$result=@mysql_query("select  * from ****_posts a , ****_trades b ,****_attachments c where a.first=0 && a.fid=114 && a.pid=b.pid && a.pid=c.pid order by a.dateline desc limit 0,2 ");
if(!$result){
echo("<P>Error performing query: " . mysql_error() . "</P>");
exit();
}
while ( $row = mysql_fetch_array($result) ) { ?>
     <table width="228" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
      <tr>
        <td height="5" colspan="3" valign="bottom">
  <table width="227" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td height="1" bgcolor="#CCCCCC"></td>
          </tr>
        </table></td>
        </tr>
      <tr>
        <td width="10" height="50" align="left" class="STYLE8"></td>
        <td width="128" align="left" class="STYLE8"><A 
href="/bbs/viewthread.php?tid=<?php echo($row["tid"]) ?> "  target="_blank"  title="商品名称:<?php echo($row["subject"]) ?>" class="STYLE2"><?php echo(msubstr($row["subject"],0,13)) ?></a></td>
        <td width="90" rowspan="3" align="left"><A 
href="/bbs/viewthread.php?tid=<?php echo($row["tid"]) ?> "  target="_blank"  title="商品名称:<?php echo($row["subject"]) ?>" class="STYLE8"><img src="/bbs/attachments/<?php  echo($row["attachment"]) ?>" width="76" height="76" border="0"></a></td>
      </tr>
      <tr align="left">
        <td height="20" class="STYLE8"></td>
        <td class="STYLE8"><a href="http://www.52lsj.com/bbs/viewpro.php?uid=<?php echo($row["author"]) ?>"  class="STYLE8"  title="卖家:<?php echo($row["author"]) ?>" target='_blank'>卖家:<?php echo(msubstr($row["author"],0,9)) ?></a></td>
      </tr>
      <tr align="left">
        <td height="20" class="STYLE8"><A 
href="/bbs/viewthread.php?tid=<?php echo($row["tid"]) ?> "  title="商品名称:<?php echo($row["subject"]) ?>" target="_blank"  class="STYLE8"></a></td>
        <td class="STYLE8"><A 
href="/bbs/viewthread.php?tid=<?php echo($row["tid"]) ?> "  title="商品名称:<?php echo($row["subject"]) ?>" target="_blank"  class="STYLE8">价格:
              </a><A 
href="/bbs/viewthread.php?tid=<?php echo($row["tid"]) ?> "  title="商品名称:<?php echo($row["subject"]) ?>" target="_blank"  class="STYLE8">
              <?php  echo($row["price"]) ?>
          </a></td>
      </tr>
    </table>
<?php } ?>