怎样利用php获取数据库中指定的记录

这是PHP获取数据库信息的代码 希望能给你带来启发
$conn=mysql_connect("localhost","root","");
$select=mysql_select_db("books",$conn);
$query="insert into computers(name,price,publish_data) ";
$query.="values('JSP',28.00,'2008-11-1')";
$query="select * from computers";
$result=mysql_query($query);
//以下是使用mysql_result()函数来获取到查询结果
$num=mysql_num_rows($result);
for($rows_count=0;$rows_count<$num;$rows_count++){
echo "书名：".mysql_result($result,$rows_count,"name");
echo "价格：".mysql_result($result,$rows_count,"price");
echo "出版日期：".mysql_result($result,$rows_count,"publish_data")."
";
}
//以下是使用mysql_fetch_row()函数来获取到查询结果
while($row=mysql_fetch_row($result))
{
echo "书号：".$row[0]."
";
echo "书名：".$row[1]."
";
echo "价格：".$row[2]."
";
echo "出版日期：".$row[3]."
";
echo "
";
}
//以下是使用mysql_fetch_array()函数来获取到查询结果
while($row=mysql_fetch_array($result))
{
echo "书号：".$row[0]."
";
echo "书名：".$row[1]."
";
echo "价格：".$row["price"]."
";
echo "出版日期：".$row["publish_data"]."
";
echo "
";
}
//以下是使用mysql_fetch_object()函数来获取到查询结果
while($row=mysql_fetch_object($result))
{
echo "书号：".$row->id."
";
echo "书名：".$row->name."
";
echo "价格：".$row->price."
";
echo "出版日期：".$row->publish_data."
";
echo "
";
}
?>