Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
03-30-2008, 03:47 PM #1
MySQL Select statement - any one any good at MySQl/SQL
hi i need to select all from teaching session where the couse course code... but there is no course code in teaching sessions only in the CourseModule table and Course,
a course contains many modules so how would i get all of the modules from searching a course and display all the teaching sessions for those modules that are in the course...
baffled...any one know?
"I have not failed, I've found 10,000 ways that don't work" Thomas Edison
04-15-2008, 07:41 AM #2
- Join Date
- Feb 2008
- Between the Lines
- Thanked 4 Times in 4 Posts
mysql_query( SELECT * FROM table WHERE course="TeachingSession" )
I think that's what you're wanting?
Show us your table, and try and be a little less vague. You know what you mean, we don't .