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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
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:[EMAIL PROTECTED]] // Sent: Thursday, 30 August 2001 12:31 PM // To: [EMAIL PROTECTED] // 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: [EMAIL PROTECTED] // For additional commands, e-mail: [EMAIL PROTECTED] // To contact the list administrators, e-mail: // [EMAIL PROTECTED] // -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] SELECT giving too much :)
Hi Beau-- Alternatively you could probably include an AND for the location ID to link up with whatever it is supposed to link up to in the WHERE clause. But I have no idea how you responded to my message in 2 minutes flat! Are you a remarkably complex AI autoresponder that knocks the socks off of ELIZA (or whatever it was) style programs? Dang! 2 minutes! Good job grin. Doug At 12:33 PM 8/30/01 +0800, Beau Lebens wrote: 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 [--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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
