$hostname = SAE_MYSQL_HOST_M.':'.SAE_MYSQL_PORT;
$dbuser = SAE_MYSQL_USER;
$dbpass = SAE_MYSQL_PASS;
$dbname = SAE_MYSQL_DB;
$link = mysql_connect($hostname, $dbuser, $dbpass);
if (!$link) {
die('Could not connect: ' . mysql_error());
}
//select db
mysql_select_db($dbname, $link) or die ('Can\'t use dbname : ' . mysql_error());
$sql = "SELECT * \n"
. "FROM `rank` order by point desc\n"
. "LIMIT 0 , 3";
$resultStr = mysql_query($sql,$link);
while($row = mysql_fetch_array($resultStr))
{
echo $row['place'] . " " . $row['point'];
echo "
";
}
mysql_close($link);
?>整个的代码就是这样,但是访问时错误提示为:
Fatal error: Call to undefined function mysql_query() in rank.php
就是说
$resultStr = mysql_query($sql,$link);
这句话有问题。求大神指点。
我想要的功能只是想连接数据库,实现查询功能,再把查询的结果输出到屏幕上。如此而已。
展开