mysqli_connect不報錯，但此後操作都顯示not a valid MySQL-Link resource

<code>$connect = mysqli_connect("host","user","password","db") or die("Error " . mysqli_error($connect));
$result = mysql_query('select * from admin',$connnet);
print(mysql_num_rows($result));
mysql_close();
</code>

報錯：

<code>Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource
Warning: mysql_close(): no MySQL-Link resource supplied
</code>

而使用物件導向方法則沒有問題
請問這是什麼問題？

回覆內容：

<code>$connect = mysqli_connect("host","user","password","db") or die("Error " . mysqli_error($connect));
$result = mysql_query('select * from admin',$connnet);
print(mysql_num_rows($result));
mysql_close();
</code>

報錯：

<code>Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource
Warning: mysql_close(): no MySQL-Link resource supplied
</code>

而使用物件導向方法則沒有問題
請問這是什麼問題？

因為你寫錯字母了...
第一個變數是 $connect
第二個變數是 $connnect
多了一個n，好不？
當然，也要用mysqli_query而不是mysql_query

mysql_query -> mysqli_query
mysql_num_rows -> mysqli_num_rows
mysql_close -> mysqli_close

哥們你用mysqli_connect建立的連接得用mysqli_xxx來用
mysqli_xxx和mysql_xxx是不能混用的