Problem: doesn't fetch correctly with WHILE

[Anon]

Here's the code:

$sql_result = mysql_query("SELECT * FROM developers,projects,pro_dev WHERE developers.id = pro_dev.did AND projects.id = pro_dev.pid");

while($row = mysql_fetch_array($sql_result_dev))
{
// define vars
$id = $row["id"];
$title = $row["title"];

echo( "<a href=\"projectdetail.php3?id=" . $id . "\">" . $title . "</a><br>\n");
}

This code is again inside a WHILE loop to fetch info for the individual developers. However the code above shows the same projects for every single developer again and again... meaning that every developer is involved in the same projects.

When I added the table's name in front of the "row" declarations the vars suddenly are empty:

e.g. $id = $row["project.id"];

Any ideas how I can solve it? I'm really confused and don't know what there should be wrong...

Thanks alot!

[Anon]

unless it's a typ0 in your message

you have "$sql_result = ...."

Then in your while statement you call it: "$sql_result_dev"

I believe they should match.

-Paul