使用mysql_result()来获取数据：mysql_result

XML/HTML代码

php
    //连接并选择到数据库服务器
    $connection = mysql_connect ("localhost", "root", "");
    mysql_select_db("Books", $connection);
    //插入一条记录
    $query="INSERT INTO Computers (name,price,publish_date) ";
    $query.="VALUES ('数据结构',20.00,'2001-1-1')";
    //echo $query."<br>";
    $result=mysql_query($query);
    if(!$query)
        echo "insert data failed!<br>";
    else{
        //查询数据
        $query="SELECT * FROM Computers ";
        $query.="WHERE price >= 20";
        //echo $query."<br>";
        $result=mysql_query($query,$connection);
        //用mysql_result获得数据，并输出
        for($rows_count=0;$rows_count<1;$rows_count++)
        {
            echo "书名：   ".mysql_result($result,$rows_count,"name")."<br>";
            echo "价格：   ".mysql_result($result,$rows_count,"price")."<br>";
            echo "出版日期： ".mysql_result($result,$rows_count,"publish_date")."<br>";
            echo "<br>";
        }
    }
?>