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
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("".$array[$i]["Code"]."")><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]