Search
Search titles only
By:
Search titles only
By:
Home
Forums
What's new
Members
New posts
Search forums
VIP
OSA Radio
Chat
0
Features
Tunes
Mixes
Events
Flyers
Forums
Log in
Register
Search
Search titles only
By:
Search titles only
By:
What's new
Members
New posts
Search forums
Menu
Install the app
Install
Reply to thread
Welcome to Old Skool Anthems
The Old Skool Resource. Since 1998.
Join now
NATIVE INTERNET WEB RADIO PLAYER PLUGIN FOR SHOUTCAST, ICECAST AND RADIONOMY
powered by
Sodah Webdesign Mainz
Forums
Updates & Help
Help
Anyone know any SQL?
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Message
<blockquote data-quote="Tigger" data-source="post: 386762" data-attributes="member: 171"><p>Got me a bit of a problem with a site I'm doing...</p><p></p><p>I've got 2 tables in a MySQL database:</p><p></p><p>tbl_Course:</p><p>-course_ID</p><p>-course_Name</p><p>-course_Module1</p><p>-course_Module2</p><p>-course_Module3</p><p></p><p>tbl_Modules:</p><p>-module_ID</p><p>-module_Name</p><p>-module_Description</p><p></p><p>The course_Module[n] fields contains a number which refer to a module_ID in the other table. I need to construct an SQL query which returns the names of the modules for each of the modules in the course.</p><p></p><p>I know how to do this if there was only 1 module for each course but haven't a clue how to get it to look up 3 different names from the same table.</p><p></p><p>Any help would be greatly appreciated. <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite8" alt=":D" title="Big grin :D" loading="lazy" data-shortname=":D" /> </p><p></p><p>(I'm using PHP & MySQL in Dreamweaver MX2004)</p></blockquote><p></p>
[QUOTE="Tigger, post: 386762, member: 171"] Got me a bit of a problem with a site I'm doing... I've got 2 tables in a MySQL database: tbl_Course: -course_ID -course_Name -course_Module1 -course_Module2 -course_Module3 tbl_Modules: -module_ID -module_Name -module_Description The course_Module[n] fields contains a number which refer to a module_ID in the other table. I need to construct an SQL query which returns the names of the modules for each of the modules in the course. I know how to do this if there was only 1 module for each course but haven't a clue how to get it to look up 3 different names from the same table. Any help would be greatly appreciated. :D (I'm using PHP & MySQL in Dreamweaver MX2004) [/QUOTE]
Verification
Post reply
Forums
Updates & Help
Help
Anyone know any SQL?
Top
Bottom
