php - 无法解释的 PHP/MySQL 错误。代码可以在我的测试服务器上运行，但不能在永久服务器上运行

Question

http://zeel.dyndns.org/ss/home/

这是我的测试服务器上我的网站的主页，效果很好。所有其他页面也是如此。但是在我的永久远程服务器(justhost)上

http://cvca.ohiofbla.org/store/home/

我得到:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in
/home/ohiofbl1/public_html/schools/cvca/store/home/index.php on line 43

我在代码中没有发现任何问题，并且相同的代码在测试服务器上运行良好。
唯一的区别是我有一个包含文件，它定义了 SQL 用户/密码/数据库名的变量，这些变量根据服务器的不同而不同。但唯一不同的文件是包含文件。

我错过了什么吗？

<?php session_start(); require("../includes/config.php");?>
<?php $title = "Home"; ////////////////////////////////////////////?>
<?php require("../includes/head.php");
///////////////////////////////////////////////////////////////////?>
<?php
$con = mysql_connect($dbhost,$dbuser,$dbpass);
if (!$con)
{
  die('Could not connect: ' . mysql_error());
}?>

<div id="index_structure">
<div id="index_left">
<div id="index_top">
<h2>Welcome to the CVCA School Store! </h2>
<p>Here you can purchase items from the school store, and then pick them 
   up from school the next day. </p>
</div>

<div id="index_bottom">
<p align="center"><img src="../images/School Store 014.png" width="30%" />&nbsp;
<img src="../images/School Store 015.png" width="30%" />&nbsp;
<img src="../images/School Store 016.png" width="30%" /></p><br />
<p><strong>Hours:</strong> Mon - Fri, 7:45 - 8:05 AM. On school days. </p>
<p><strong>Location:</strong> Corner of west cafe </p>
<p>Backpack sales start in May - August for all new 7th graders. 
   Supplies are available year round.</p>
<p>Empty shoeboxes are accepted for Operation Shoebox at all times. </p>
<p>We are always looking for parent helpers and student employees. </p>
<p>School uniforms are available for fitting purposes. 
   Uniforms are available for purchase at 
<span class="bluelink"><a href="http://cvcastore.com/">cvcastore.com</a>
</span></p>
<p><img src="../images/shirts.png" width="32%" /></p></div></div>
<div id="index_sidebar">
<h3 align="left">Featured items:</h3><hr />

<?php
function random_one($dbname, $con) 
{ 
  mysql_select_db($dbname, $con);
  unset($result);
  unset($col);
  $i = 1;
  while($i = 1) 
  { 
    $result = mysql_query("SELECT * FROM items\n"."ORDER BY RAND()\n"."LIMIT 1");
    $col = mysql_fetch_array($result); //This is line 43 from the error
    if (file_exists("../" . $col['ImagePath']) == true)
    {
      echo "<h4><a href='../item/?item=" . $col['ItemNumber'] . "'>" .
           $col['ItemName'] . "</h4><br />
           <img src='../" . $col['ImagePath'] . "' border='0' /></a>";
      break;
    }
  }
  ?><hr /><?php
}  
random_one($dbname, $con);
random_one($dbname, $con);
random_one($dbname, $con);

?></div></div>    

<?php require("../includes/foot.php"); ///////////////////////////////?> 

Answer 1

嗯，我自己检查过的查询字符串没有任何问题(虽然我同意rineez的观点，但没有理由\n)。问题可能出在变量 $dbname 上，或者更可能出在 while 循环本身上。这是一个不会退出的无限循环，因为您没有对 $i 变量执行任何操作来更改它，从而退出 while 循环。