<?php
//显示求货信息.最近的十条.
mysql_connect('localhost','root');
@mysql_select_db("iwn") or die (print "无法找到数据库!");
$sql="select * from dt_qiu ORDER BY `tq_date` DESC LIMIT 0, 10 ";
$resu=mysql_query($sql) or die (print "无法执行SQL语句!");
?>
<CENTER><FONT SIZE="5" COLOR="#FF6633"><B>求 购 信 息</B></FONT></CENTER>
<center><table align="center" width='80%' border=0 cellspacing=0 cellpadding=0>
<tr>
<td>型号</td>
<td>数量</td>
<td>厂家</td>
<td>单价</td>
<td>日期</td>
<td>公司</td>
<td>有效期限</td>
<td>产品注释</td>
</tr><?
while($aa=mysql_fetch_array($resu))
{
print <<<LMY
<tr>
<td>$aa[1]</td>
<td>$aa[2]</td>
<td>$aa[3]</td>
<td>$aa[4]</td>
<td>$aa[5]</td>
<td>$aa[6]</td>
<td>$aa[7]</td>
<td>$aa[8]</td>
</tr>
LMY;
}?>
</table></center>
<div align='right'><A HREF="more.php">更多....</A></div>
//显示求货信息.最近的十条.
mysql_connect('localhost','root');
@mysql_select_db("iwn") or die (print "无法找到数据库!");
$sql="select * from dt_qiu ORDER BY `tq_date` DESC LIMIT 0, 10 ";
$resu=mysql_query($sql) or die (print "无法执行SQL语句!");
?>
<CENTER><FONT SIZE="5" COLOR="#FF6633"><B>求 购 信 息</B></FONT></CENTER>
<center><table align="center" width='80%' border=0 cellspacing=0 cellpadding=0>
<tr>
<td>型号</td>
<td>数量</td>
<td>厂家</td>
<td>单价</td>
<td>日期</td>
<td>公司</td>
<td>有效期限</td>
<td>产品注释</td>
</tr><?
while($aa=mysql_fetch_array($resu))
{
print <<<LMY
<tr>
<td>$aa[1]</td>
<td>$aa[2]</td>
<td>$aa[3]</td>
<td>$aa[4]</td>
<td>$aa[5]</td>
<td>$aa[6]</td>
<td>$aa[7]</td>
<td>$aa[8]</td>
</tr>
LMY;
}?>
</table></center>
<div align='right'><A HREF="more.php">更多....</A></div>
@mysql_select_db("YourDatabase");
$query="select * from YourTableName";
$result=mysql_query($sql);
while($value=mysql_fetch_array($result))
{ for($i=0;$i<count($value);$i++)
{ echo $value[$i]."<br>";}
}
http://starho.51.net