php操作mysql问题如果我想让它显示前N条 SELECT TOP 8 * FROM WebInfo WHERE TypeID=1 这样写怎么不对啊

显示全部楼层 · 2011-3-17 07:25:59

?php
$con = mysql_connect(\"localhost\",\"root\",\"\");
mysql_query(\"SET NAMES GBK\");

if (!$con)

{

die(\'Could not connect: \' . mysql_error());

}

mysql_select_db(\"jminformation\", $con);

$result = mysql_query(\"SELECT * FROM WebInfo WHERE TypeID=1\");

while($row =mysql_fetch_array($result))

{

echo \"lidiv style=\'float:left\'a href=\'\'\".$row[\'WebTitle\'].\"/a/div

div style=\'float:right\'span[\".$row[\'SetTime\'].\"]/span/divdiv style=\'clear:both\'/div/li\";

}
mysql_close($con);
?

千问 · 2011-3-17 07:25:59

<pre id=\"best-answer-content\" class=\"reply-text mb10\">SELECT * FROM WebInfo WHERE TypeID=1 LIMIT 0,8

哈哈，知道了吧。不会的问老吴别问百度

php操作mysql问题 如果我想让它显示前N条 SELECT TOP 8 * FROM WebInfo WHERE TypeID=1 这样写怎么不对啊

php操作mysql问题如果我想让它显示前N条 SELECT TOP 8 * FROM WebInfo WHERE TypeID=1 这样写怎么不对啊