August 23rd, 2000, 07:39 PM
Iím trying to join two tables called Tutors and Course along the Course id column. Iím not sure how to do this and especially how to display such a join. Can you help?
August 24th, 2000, 06:48 AM
<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">code:</font><HR><pre>
FROM tutors t, course c
WHERE c.course_id = t.course_id
should do the trick. If that behaviour isn't what you're looking for, check out the SELECT docs on the MySQL web page for info on left and outer joins.
August 24th, 2000, 07:15 AM
But I'm still struggling to display the results of the join in PHP. Any suggestions?
August 24th, 2000, 07:53 AM
August 27th, 2000, 04:42 PM