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
which gets the right results, but it returns something like this;
+-------+------------------------------------------------------+
| fname | course |
+-------+------------------------------------------------------+
| Beau | Graduate Certificate in Learning Technologies (K-12) |
| Beau | Graduate Certificate in Learning Technologies (K-12) |
| Grant | Short Course in Learning Technologies (K-12) |
| Grant | Short Course in Learning Technologies (K-12) |
+-------+------------------------------------------------------+
and it should only be returning one of each of those records.... any
suggestions?
thanks
Beau
--
Beau F Lebens, Technical Officer
National Key Centre for School Science and Mathematics
Science and Mathematics Education Centre
Curtin University of Technology,
GPO Box U1987 Perth, Western Australia 6845
t: +61 8 9266 7297 (has voice-mail)
f: +61 8 9266-2503 (ATT: Beau Lebens)
e: [EMAIL PROTECTED]
w: http://learnt.smec.curtin.edu.au/
--
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]