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 as the Course table is concerned and there is also data displayed (or used in calculations from the other two tables which do 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 > 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 PROTECTED]; [EMAIL PROTECTED] > Subject: [PHP-DB] Conflicting results using PHP/Mysql > > > Hi all, > > Posted this yesterday and got no response. Trying again today. > > I'm having a small problem with a biggish query. > > The query: > > $Itemlistquery= "select [a whole load of fields from 3 tables] ending with > "; > $Itemlistquery.= "transactions.Pdownload "; > $Itemlistquery.= "from bib_extract,scanrates,transactions where "; > $Itemlistquery.= "(transactions.CourseID = '$Course_ID' and "; > $Itemlistquery.= "bib_extract.E_ID=transactions.ExtractID and "; > $Itemlistquery.= "scanrates.finrate=transactions.finrate) "; > > The problem: > > If I do a simple count of transactions.CourseID='$Course_ID' I get 18 (for a > particular course) and the above query only displays 3 results. > > Any suggestions? I didn't want to clog the list with the whole query but I > can if it's necessary. > > George, in Edinburgh > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
