which one was giving you the problem? the first or second mysql try. if it was the second, try wrapping the $cattyname with single quotes like this Minor_Category = '$cattyname'. if the $cattyname var has anything but numbers, the statement won't work.
Jim ----- Original Message ----- From: "Shannon Doyle" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, December 19, 2001 4:19 PM Subject: [PHP-DB] Mysql result resource error > 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] > > -- 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]