Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Regular Coder maxvee8's Avatar
    Join Date
    Feb 2008
    Location
    UK
    Posts
    185
    Thanks
    19
    Thanked 18 Times in 18 Posts

    Question 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

  • #2
    Regular Coder Deacon Frost's Avatar
    Join Date
    Feb 2008
    Location
    Between the Lines
    Posts
    279
    Thanks
    31
    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 .


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •