<?php$db_id = mysql_connect("localhost", "root", "");
$result = mysql_db_query("database","select serial, GoodsName,GoodsExhaleDate from society_allgoods where IsOnValidPeriod='yes' and GoodsOwner='".$_SESSION["username"]."'"."order by GoodsExhaleDate Desc");$num_rows = mysql_num_rows($result);if ($num_rows==0)
{
echo "<tr><td colspan=3> </td></tr>";
}else{
while($row = mysql_fetch_array($result,MYSQL_ASSOC))
{
$serial = $row["serial"];
$goodsname = $row["goodsname"];
这里取出来的goodsname是空,在我数据库里面确实有数据呀
$ExhaleDate= date("Y-m-d",strtotime($row["GoodsExhaleDate"])); //发布日期
echo "<tr><td width=10><input type=\"checkbox\" value=\"".$serial."\" /></td><td width=525>".$goodsname."</td><td width=240 align=center>".$ExhaleDate."</td></tr>";
}
}
echo "</table>";mysql_close($db_id);?>
$result = mysql_db_query("database","select serial, GoodsName,GoodsExhaleDate from society_allgoods where IsOnValidPeriod='yes' and GoodsOwner='".$_SESSION["username"]."'"."order by GoodsExhaleDate Desc");$num_rows = mysql_num_rows($result);if ($num_rows==0)
{
echo "<tr><td colspan=3> </td></tr>";
}else{
while($row = mysql_fetch_array($result,MYSQL_ASSOC))
{
$serial = $row["serial"];
$goodsname = $row["goodsname"];
这里取出来的goodsname是空,在我数据库里面确实有数据呀
$ExhaleDate= date("Y-m-d",strtotime($row["GoodsExhaleDate"])); //发布日期
echo "<tr><td width=10><input type=\"checkbox\" value=\"".$serial."\" /></td><td width=525>".$goodsname."</td><td width=240 align=center>".$ExhaleDate."</td></tr>";
}
}
echo "</table>";mysql_close($db_id);?>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货