RE: [PHP-DB] Conflicting results using PHP/Mysql

2002-03-13 Thread Kevin Bucknum
transactions.CourseID='$Course_ID' is not the same as the three part join that you have in that query. Are your sure your other two joins aren't restricting the query? -Original Message- From: George Pitcher [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 10:09 AM To: [EMAIL

Re: [PHP-DB] Conflicting results using PHP/Mysql

2002-03-13 Thread George Pitcher
not necessarily relate just to these records. Hope this clarifies rather than confuses. George - Original Message - From: Kevin Bucknum [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 13, 2002 4:17 PM Subject: RE: [PHP-DB] Conflicting results using PHP/Mysql

RE: [PHP-DB] Conflicting results using PHP/Mysql

2002-03-13 Thread Kevin Bucknum
PROTECTED]] Sent: Wednesday, March 13, 2002 10:20 AM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Conflicting results using PHP/Mysql Kevin, Simply, no I'm not sure. To explain fully: I have a web page where a lecturer/librarian can view their reading list. The CourseID holds it together as far