Is it possible to combine two sql queries?
Posted: Sun Mar 22, 2009 2:32 pm
Hi, This is my code:
I get an invalid arguement error...is what I am trying to do even possible?
Code: Select all
$sql= "SELECT Job_ID.Job_name, ID_Table.Skill_Name, ID_Table.Weight
FROM Job_ID
JOIN ID_Table USING (Job_ID)
WHERE Job_ID.Job_Name = 'Manager'
";
$sql2="SELECT Person_ID.Person_Name, Person_Skill.Skill_Name, Person_Skill.Score
FROM Person_ID
JOIN Person_Skill USING (Person_ID)
WHERE Person_ID.Person_Name='Nish'";
$result1 = mysql_query($sql,$sql2)
or die ("Couldn't execute query.");
while ($row1=mysql_fetch_array($result1))
{
$tblRows .= "<tr>";
$tblRows .= "<td>{$row['Skill_Name']}</td>";
$tblRows .= "<td>{$row['Weight']}</td>";
$tblRows1 .= "<td>{$row1['Score']}</td>";
$tblRows1 .= "</tr>\n";
}