Problem with WHILE LOOP
Posted: Tue Mar 24, 2009 6:55 am
Hi
This is my code:
But the out put is
Job Name:ManagerManagerManagerManagerManagerManagerManagerManager
I was expecting:
Job Name: Manager...
What do i need to change??
This is my code:
Code: Select all
$sql= "SELECT Person_Skill . * , ID_Table . * , Job_ID.Job_Name
FROM Person_Skill, ID_Table
JOIN Job_ID
USING ( Job_ID )
WHERE Job_Name='Manager'";
$result1 = mysql_query($sql) or die ("Couldn't execute query.");
while ($row=mysql_fetch_array($result1))
{
echo "Job Name: ".$row['Manager'] . " ";
}
?>
Job Name:ManagerManagerManagerManagerManagerManagerManagerManager
I was expecting:
Job Name: Manager...
What do i need to change??