[RESOLVED] Selecting data from two tables

[Tezread]

I have a procedure (see code below) which selects course details from a table called courses. I was wondering how I can add another select to lookup data from another table called courseaims. Is there a more efficient way of doing this other than repeating this code below?

<?php 
if (isset($_GET['course'])) { 
$user = "root"; 
$host = "localhost"; 
$password = ""; 
$connection = mysql_connect($host, $root, $password) or die ("Couldn't connect to server."); 
$database = "courses"; 
$db = mysql_select_db($database) or die ("Couldn't select database."); 

$course = mysql_real_escape_string($_GET['course']); 
$res = "SELECT * FROM trainingtopics WHERE coursename = '$course'"; 
$result = mysql_query($res) or die(mysql_error()); 
if (mysql_num_rows($result) > 0) { 
while ($row = mysql_fetch_assoc($result)) { 

echo ' 
<tr> 
<td width="100%"><strong><p align="center" class="style4 style11"><td>' . $row['coursename'] .'</td></strong></p> 
<br>
<td width="79%"><strong><p align="left" class="style4 style11">Aimed at</strong></p>
<br>
<td>' . $row['aimedat'] . '</td> 
<br>
<td width="79%"><strong><p align="left" class="style4 style11">Level 1?</strong></p>
<br>
<td>' . $row['level1'] . '</td> 
<br>
<td width="79%"><strong><p align="left" class="style4 style11">Level 2?</strong></p>
<br>
<td>' . $row['level2'] . '</td>
<br>
<td width="79%"><strong><p align="left" class="style4 style11">Level 3?</strong></p>
<br>
<td>' . $row['level3'] . '</td> 
<br>
<td width="79%"><strong><p align="left" class="style4 style11">Available through e learning?</strong></p>
<br>
<td>' . $row['elearning'] . '</td> 
<br>
<td width="79%"><strong><p align="left" class="style4 style11">Availble through face to face classroom based training?</strong></p>
<br>
<td>' . $row['facetoface'] . '</td> 
<br>
<td width="79%"><strong><p align="left" class="style4 style11">Available through blended learning? (face to face and e learning)</strong></p>
<br>
<td>' . $row['blendedlearning'] . '</td>
<br> 
<td width="79%"><strong><p align="left" class="style4 style11">E learning study time</strong></p>
<br>
<td>' . $row['elearntime'] . '</td> 
<br>
<td width="79%"><strong><p align="left" class="style4 style11">Face to face learning study time</strong></p>
<br>
<td>' . $row['facetime'] . '</td>
<br>
<td width="79%"><strong><p align="left" class="style4 style11">Blended learning study time</strong></p>
<br>
<td>' . $row['blendedtime'] . '</td> 
<br>
</tr> 
';

} 

} else { 
//course name not found 
//note: the query may have failed to so maybe check for that. 
} 
} else { 
//no course specified 
} 
?>

[toplay]

I don't really understand exactly what you want to do considering you're talking about a table called "courses" and "courseaims" but show us code related to "trainingtopics". And "courses" is not a table but a database name.

Yes, there is a way to select more than one table, but there's lots of ways to do it depending on what result you want, and if there's a common column that can link the two together.

Learn about joins at this tutorial and maybe you can then figure it out for yourself:

http://www.keithjbrown.co.uk/vworks/mysql/mysql_p5.shtml

hth.

[Tezread]

Thankyou for the pointer