Database trouble!

[bart]

I am using the following code to retrive information from 2 database tables.

$sql = "SELECT $team_table.*, $undercollection_table.* FROM $team_table, $undercollection_table WHERE $team_table.team_name = '$undercollection_table.SalesManager'"; 
$result = mysql_query($sql); 
if (!$result) { 
mysql_err(); 
exit; } 

How do I now assign $name to the table field team_name etc...?

is it simply a case of

while ($query_data = mysql_fetch_array($result)) 
{ 
$name = $query_data["team_table.name"]; 
echo "ect etc etc..."; 
}

?

Sorry if it should be obvious!

[sarahk]

If you are trying to update the database table then

$sql = "UPDATE $team_table set $team_table.team_name = $name";
echo $sql;

assuming that all your substitutions work properly. I've coded it to echo out, look at that, paste it into phpMyAdmin directly and play around with it.