RE: [PHP-DB] Mysql result resource error
| From: | Shannon Doyle | Date: | Thu, 20 Dec 2001 23:25:12 +0000 |
| Subject: | RE: [PHP-DB] Mysql result resource error | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-15171@lists.php.net to get a copy of this message | ||
Hi Jim,
Ahh yes of course....I have corrected this.
I am still getting the error on the first query...not sure why. And now
I am getting a whole bunch of empty lines being output to the screen.
Like there is supposed to be data in those lines, but nothing happening.
Plus I am getting repeats of the same data. Its like it is doing each
query three times or something.
Don't know why it is doing that.
- Shannon
> -----Original Message-----
> From: Jim Lucas [mailto:jimphp@bend.com]
> Sent: Friday, 21 December 2001 03:52 AM
> To: Shannon Doyle; php-db@lists.php.net
> Subject: Re: [PHP-DB] Mysql result resource error
>
>
> 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" <shannon@bigblue.net.au>
> To: <php-db@lists.php.net>
> 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: php-db-unsubscribe@lists.php.net
> > For additional commands, e-mail: php-db-help@lists.php.net
> > To contact the list administrators, e-mail:
> php-list-admin@lists.php.net
> >
> >
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail:
> php-list-admin@lists.php.net
>
>