请大家帮我看下这段代码有没有错误,为什么不能正确的输出查询结果
代码:
<?php
$link=mysql_connect("localhost","root","123")
or die("Could not connect to MySQL server!");
mysql_select_db("php",$link);
$str="Select ID,ClassTreeID,NewsTitle,RevContent,ImageUrl,Infotime From newsinfo where ClassTreeID=1 and IsShow=1 order by Infotim desc limit 6";
$result=mysql_query($str);
while($rows=mysql_fetch_row($result))
{
echo $rows[0];
}
?>
代码:
<?php
$link=mysql_connect("localhost","root","123")
or die("Could not connect to MySQL server!");
mysql_select_db("php",$link);
$str="Select ID,ClassTreeID,NewsTitle,RevContent,ImageUrl,Infotime From newsinfo where ClassTreeID=1 and IsShow=1 order by Infotim desc limit 6";
$result=mysql_query($str);
while($rows=mysql_fetch_row($result))
{
echo $rows[0];
}
?>
收回我1L的话
你是否需要查询字段ID的值?
是否应该是order by Infotime?
echo "debug".$rows[0];看看进没进去
你debug一下撒
for($i = 0; $i < $num; $i++){
$row = mysql_fetch_array($result);
}
代码:
<?php
$link=mysql_connect("localhost","root","123")
or die("Could not connect to MySQL server!");
mysql_query("set names 'utf8'");
mysql_select_db("php",$link);
$str="Select ID,ClassTreeID,NewsTitle,RevContent,ImageUrl,Infotime From newsinfo where ClassTreeID=1 and IsShow=1 order by Infotime desc limit 6";
// mysql_query('set names "utf-8"');
$result=mysql_query($str,$link);
$num = mysql_num_rows($result);
for($i = 0; $i < $num; $i++)
{
$row = mysql_fetch_array($result);
echo"<div id=""index_news""><ul><li><a href=""#"">".$row["NewsTitle"]."</a></li></ul></div>";
}
?>
<?php
$strs="Select * from productsinfo Order By ToSort";
$results=mysql_query($str,$link);
$nums=mysql_num_rows($strs);
for($j=0;$j<$nums;$j++)
{
$rows = mysql_fetch_array($results);
echo "<img src='imgfile/".$rows["ProSImg"]."'/>";
}
?>
$results=mysql_query($strs,$link);
$nums=mysql_num_rows($results);
for($j=0;$j<$nums;$j++)
{
$rows = mysql_fetch_array($results);
echo "<img src='imgfile/".$rows["ProSImg"]."'/>";
}