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.


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

--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]

Reply via email to