PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
$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'];
}
So basically I want all the skill_id's and the weights associtated with a particular job_id.
$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'];
}