I Can't join and Display tables.

Hi

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?

Thanks
Lisa

<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">code:</font><HR><pre>
SELECT *
FROM tutors t, course c
WHERE c.course_id = t.course_id
[/code]
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.

Thank you
But I'm still struggling to display the results of the join in PHP. Any suggestions?

Lisa

here's a good tutorial:
http://hotwired.lycos.com/webmonkey/programming/php/tutorials/tutorial4.html


------------------

Thanks!