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]
