RE: [PHP-DB] SELECT giving too much :)

Actually yes I do :) thanks for that - it fixes it when i remove the "FROM locations" although I didn't want to have to pull it, because it is going to mean some ugly testing and stuff that I wanted to avoid - oh well, looks like I have no choice now :) Cheers beau // -----Original Message----- // From: Doug Semig [mailto:dougslist@semig.com] // Sent: Thursday, 30 August 2001 12:31 PM // To: php-db@lists.php.net // Subject: Re: [PHP-DB] SELECT giving too much :) // // // Hi Beau-- // // This is just a wild guess (I've only glanced at your SQL), // but do you have // two locations in your locations table? // // You might want to try yanking locations out of the join // since you're not // using it in your WHERE clause or showing any info from it. // // Doug // // At 12:06 PM 8/30/01 +0800, Beau Lebens wrote: // >Hi guys, I have a set-up to query a database by allowing // the user to build a // >query from selecting fields, restrictions etc etc. // > // >It produces the following; // > // >SELECT students.fname, courses.title AS course FROM // students, courses, // >course_enrolments, groups, locations, staff WHERE // >(students.studentID=course_enrolments.studentID AND // >course_enrolments.courseID=courses.courseID) AND // >(students.groupID=groups.groupID) AND // (staff.staffID=courses.staffID) ORDER // >BY fname ASC // [--snip--] // // --Doug's Signature File---------------------------------------- // ~ ~ ~ I'm proud to work for GLISnet, Michigan's best ISP ~ ~ ~ // --1.888.445.4763---8am to 8pm every day---http://www.glis.net-- // The views and opinions expressed in this email are my // own and may not be those of my employer. // // // -- // 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 //