$sql = "SELECT qq,qqid,subject FROM `news` LIMIT 30 ";$list = mysql_query($sql);
$list = mysql_fetch_array($list);
echo $list[qq];
$list[qq] 调用的只是一行数据 怎么调用多行数据???
$list = mysql_fetch_array($list);
echo $list[qq];
$list[qq] 调用的只是一行数据 怎么调用多行数据???
$sql = "SELECT qq,qqid,subject FROM `news` LIMIT 30 ";
$list = mysql_query($sql);
while ($row = mysql_fetch_array($list, MYSQL_NUM))
{
echo $row['qq'];
}
$list = mysql_fetch_array($list);
echo $list[qq];mysql_fetch_array这个函数 只是返回mysql中你的sql语句查询的第一行信息
你要循环取出每行的信息...
while($rows=mysql_fetch_array($list))
{
echo $rows["qq"]."<br/>";
}
$sql = "SELECT * FROM `news` WHERE `qq` = 96658 order by id desc LIMIT 0, 10";
@mysql_select_db($dbname) or die(mysql_error());
$sql = "SELECT qq,qqid,subject FROM `news` order by `自增的ID字段名 或 插入时间的字段名` desc LIMIT 0,10";
$list = @mysql_query($sql) or die(mysql_error());;
while ($row = mysql_fetch_array($list, MYSQL_ASSOC))
{
echo $row['qq'];
}