select epg_key,repertoire_cn_name,type_name,program_cn_name,type,play_date from repertoire_program1
查询语句没有问题,为什么会出现上面问题啊
$dbh = mysql_connect('localhost','root','123456');
mysql_query("set names gb2312");
$sql=mysql_db_query($dbh,"select epg_key,repertoire_cn_name,type_name,program_cn_name,type,play_date from repertoire_program1");
$info=mysql_fetch_array($sql);
if($info==NULL)
{
echo "暂无信息";
}
else
{
do
{
?>
<tr>
/*<td height="20" bgcolor="#FFFFFF"><div align="center"><?php echo $info[sno];?></div></td>*/
<td bgcolor="#FFFFFF"><div align="center"><?php echo $info[epg_key];?></div></td>
<td bgcolor="#FFFFFF"><div align="center"><?php echo $info[repertoire_cn_name];?></div></td>
<td bgcolor="#FFFFFF"><div align="center"><?php echo $info[type_name];?></div></td>
<td bgcolor="#FFFFFF"><div align="center"><?php echo $info[program_cn_name];?></div></td>
<td bgcolor="#FFFFFF"><div align="center"><?php echo $info[type];?></div></td>
<td bgcolor="#FFFFFF"><div align="center"><?php echo $info[play_date];?></div></td>
</tr>
查询语句没有问题,为什么会出现上面问题啊
$dbh = mysql_connect('localhost','root','123456');
mysql_query("set names gb2312");
$sql=mysql_db_query($dbh,"select epg_key,repertoire_cn_name,type_name,program_cn_name,type,play_date from repertoire_program1");
$info=mysql_fetch_array($sql);
if($info==NULL)
{
echo "暂无信息";
}
else
{
do
{
?>
<tr>
/*<td height="20" bgcolor="#FFFFFF"><div align="center"><?php echo $info[sno];?></div></td>*/
<td bgcolor="#FFFFFF"><div align="center"><?php echo $info[epg_key];?></div></td>
<td bgcolor="#FFFFFF"><div align="center"><?php echo $info[repertoire_cn_name];?></div></td>
<td bgcolor="#FFFFFF"><div align="center"><?php echo $info[type_name];?></div></td>
<td bgcolor="#FFFFFF"><div align="center"><?php echo $info[program_cn_name];?></div></td>
<td bgcolor="#FFFFFF"><div align="center"><?php echo $info[type];?></div></td>
<td bgcolor="#FFFFFF"><div align="center"><?php echo $info[play_date];?></div></td>
</tr>
还用过mysql_db_query,试下下面的看看 $dbh = mysql_connect('localhost','root','123456');
mysql_select_db("数据库名称");
mysql_query("set names gb2312");
$sql = mysql_query("select epg_key,repertoire_cn_name,type_name,program_cn_name,type,play_date from repertoire_program1");
$info=mysql_fetch_array($sql);