require"uap.php";
$link=mysql_connect($db_host,$db_username,$db_password);
if(!$link)
{
die ('Can not connect:'.mysql_error());
}
$number=range(1,5);
shuffle($number);
for($j=0;$j<5;$j++)
{
mysql_select_db($db2_name,$link);
$sql="select * from $table2_name where S_ID = $number[$j]";
mysql_query("set names 'gb2312'");
$result=mysql_query($sql,$link);
$m=$j+1;
while($row=mysql_fetch_array($result))
{
这段代码出现以下错误:
( ! ) Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\mainpage.php on line 68
$link=mysql_connect($db_host,$db_username,$db_password);
if(!$link)
{
die ('Can not connect:'.mysql_error());
}
$number=range(1,5);
shuffle($number);
for($j=0;$j<5;$j++)
{
mysql_select_db($db2_name,$link);
$sql="select * from $table2_name where S_ID = $number[$j]";
mysql_query("set names 'gb2312'");
$result=mysql_query($sql,$link);
$m=$j+1;
while($row=mysql_fetch_array($result))
{
这段代码出现以下错误:
( ! ) Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp\www\mainpage.php on line 68
$result=mysql_query($sql,$link);
//改为:
$result = mysql_query($sql, $link) or die(mysql_error());
出现了这样的错误信息,是查询没有成功,可是我在那一段代码上面也有相似的另一段代码可以成功
//$sql="select * from $table2_name where S_ID = $number[$j]";
$sql = "SELECT * FROM `{$table2_name}` WHERE `S_ID` = ".$number[$j];