mysql和mysqli如何选择,PHP / MYSQL使用mysqli_query进行选择

I am struggling with my script and since switching to mysqli it will no longer work.I have checked the PHP manual but just cannot see what I am doing wrong, surely a beginners mistake.

Here is my code:

//Connect to database

include ('connection.php');

// Retrieve all the data from the table

$result = mysqli_query("SELECT * FROM gear") or die(mysqli_error());

echo "

echo "

Manufacturer Model Description ";

// keeps getting the next row until there are no more to get

while($gear = mysqli_fetch_array( $result )) {

// Print out the contents of each row into a table

echo "

";

echo $gear['manu'];

echo "

";

echo $gear['model'];

echo "

";

echo $gear['desc'];

echo "

";

}

echo "

";

?>

I am wondering if it is because of the fact that I am using another script to connect but it is complaining about my mysqli_query so I am getting this error:

[Wed Jan 01 21:14:54 2014] [error] [client ::1] PHP Warning: mysqli_error() expects exactly 1 parameter, 0 given in /var/www/eml/includes/query_gear.php on line 7

Any advice or suggestions would be appreciated.

解决方案

You are missing your resource identifier obtained with mysqli_connect() which is required with mysqli_* and not with mysql_*. Assuming you called yours $link:

$result = mysqli_query($link, "SELECT * FROM gear") or die(mysqli_error($link));