Spiller [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 25, 2001 2:30 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Join causing Error?
Can anyone tell me why this:
Line 282mysql_select_db("centraldb",$db);
Line 283$qorder++;
Can anyone tell me why this:
Line 282mysql_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,
Sir, I don't see anything wrong with the syntax in your query. If I
haven't over looked something, and if you haven't misspelled
anything, then you have a data problem. Since your first query
returns a Cartesian product, you should get something if the WHERE
clause returns = 1 row for each