Join causing Error?
| From: | Keith Spiller | Date: | Sun, 25 Feb 2001 08:30:08 +0000 |
| Subject: | Join causing Error? | ||
| Groups: | php.db php.general | ||
| Request: | Send a blank email to php-db+get-6931@lists.php.net to get a copy of this message | ||
Can anyone tell me why this:
Line 282 mysql_select_db("centraldb",$db);
Line 283 $qorder++;
Line 284 $result = mysql_query("SELECT q.questid, q.question, q.answer, q.qorder,
q.depart, q.catid,
q.active, q.global, q.adate, q.author, q.authoremail, q.askemail, c.catid,
c.category, c.under,
c.corder, c.active FROM central_groupfaqq q, central_groupfaqcat c WHERE q.active
= '1' AND
q.global = '1' AND c.active = '1' ORDER BY c.under, c.order,
q.qorder",$db);
Line 285 while ($myrow = mysql_fetch_row($result))
Would cause this error:
Warning: Supplied argument is not a valid MySQL result resource in faqbody.php3 on line 285
When changing the same SELECT statement to:
Line 284 $result = mysql_query("SELECT * FROM central_groupfaqq WHERE active =
'1' ORDER BY
qorder",$db);
Works perfectly?
Keith Spiller
a.k.a. Larentium