1st sql:
Code: Select all
$query1 = "SELECT * FROM Job_ID WHERE Job_Name ='$_SESSION[Job_Name]'";
$result2 = mysql_query($query1)
or die ("Couldn't execute query.");
while ($row2=mysql_fetch_array($result2)){
$Job_ID1=$row2['Job_ID'];
}Code: Select all
$sql2="SELECT * FROM ID_Table WHERE Job_ID IN (SELECT Job_ID FROM Job_ID WHERE Job_ID=$Job_ID1)";
$result3 = mysql_query($sql2)
or die ("Couldn't execute query.");
while ($row3=mysql_fetch_array($result3)){
$Skill_ID[]=$row3['Skill_ID'];
$Weight[]=$row3['Weight'];
}For example, my job table, the job id 1 has skills 1, 2 and 3. In the skills table the skill_id's (1,2 and 3) are associated with C, Java and C#. And I want to display these. I am baffled!