[PHP-DB] Mysql result resource error

[Shannon Doyle]

Hi People,

I am getting a Not a valid Mysql result resource error with the
following code, can someone take a look at this for me and see if there
is anything that stands out 

Advertising

Thanks,

Shannon

<?
$cattyname = "";
$sql = "select Minor_Category main where Page = 'wines' order by
Minor_Category";
$dbh = @mysql_connect($dbhost,$dbuser,$dbpass);
$results2 = mysql_db_query($db,$sql,$dbh);
  for($j = 0; $j < mysql_num_rows($results2); $j++) {
  $array[$j] = mysql_fetch_array($results2);
}
mysql_close($dbh);
for ($h = 0; $h < count($array); $h++)  {

if ($array[$h]["Minor_Category"] != $cattyname) {
  $cattyname = $array[$h]["Minor_Category"];
  echo "<tr><td colspan='4'><a
name='".$cattyname."'></a><b>".$cattyname."</b></td></td></tr>";


$catname = "";
$sql = "select Category,Code,Description,Pack,Unit,Price from main where
Page = 'wines' && Minor_Category = $cattyname order by Category";
$dbh = @mysql_connect($dbhost,$dbuser,$dbpass);
$results = mysql_db_query($db,$sql,$dbh);
  for($i = 0; $i < mysql_num_rows($results); $i++) {
  $array[$i] = mysql_fetch_array($results);
}
mysql_close($dbh);

for ($i = 0; $i < count($array); $i++)  {

if ($array[$i]["Category"] != $catname) {
  $catname = $array[$i]["Category"];
  echo "<tr><td colspan='4'><a
name='".$catname."'></a><b>".$catname."</b></td><td
align='center'><p><b>Carton Size</b></p></td><td
align='center'><p><b>Unit</b></p></td><td
align='right'><p><b>Price</b></p></td><td><a href='#top'><img
src='images/arrow.gif' border='0'></a></td></tr>";
}

  echo "<tr><td></td><td><p><a
href=javascript:order_now(&quot;".$array[$i]["Code"]."&quot;)><img
src='images/order.gif' border='0'></a></td><td></td><td
align='left'><p>".$array[$i]["Description"]."</p></td><td
align='center'><p>".$array[$i]["Pack"]."</p></td><td
align='center'><p>".$array[$i]["Unit"]."</p></td><td
align='right'><p>$".$array[$i]["Price"]."</p></td></tr>\n";
}
}
}
?>


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]