<?php //(1)打开数据库连接并使用数据库 $connection=mysql_connect ("localhost","database_user_name","password"); mysql_select_db("database_name",$connection); //(2)通过连接在数据库上运行查询 $result=mysql_query("select * from table_name ORDER by id DESC LIMIT 3;",$connection); //(3)当结果集中还有行时, //将当前行取回数组$row中 while ($row=mysql_fetch_row($result)) { //(4)输出$row中的每一个元素, //也就是输出属性的值 for ($i=0;$i<mysql_num_fields($result);$i++) echo $row[$i] . " "; //输出一个回车以使输出整洁 echo "\n"; } //(5)关闭数据库连接 mysql_close($connection); ?>
//(2)通过连接在数据库上运行查询 $result=mysql_query("select * from table_name ORDER by id DESC LIMIT 3;",$connection);改为//(2)通过连接在数据库上运行查询 $result=mysql_query("select * from table_name ORDER by id DESC LIMIT 3",$connection); ~~注意:没有分号
//(1)打开数据库连接并使用数据库
$connection=mysql_connect ("localhost","database_user_name","password");
mysql_select_db("database_name",$connection); //(2)通过连接在数据库上运行查询
$result=mysql_query("select * from table_name ORDER by id DESC LIMIT 3;",$connection); //(3)当结果集中还有行时,
//将当前行取回数组$row中
while ($row=mysql_fetch_row($result))
{
//(4)输出$row中的每一个元素,
//也就是输出属性的值
for ($i=0;$i<mysql_num_fields($result);$i++)
echo $row[$i] . " "; //输出一个回车以使输出整洁
echo "\n";
}
//(5)关闭数据库连接
mysql_close($connection);
?>
$result=mysql_query("select * from table_name ORDER by id DESC LIMIT 3;",$connection);改为//(2)通过连接在数据库上运行查询
$result=mysql_query("select * from table_name ORDER by id DESC LIMIT 3",$connection);
~~注意:没有分号