fetch array from several tables

[Anon]

Hi all,

i need help..
for a sql query like this:
$sql="SELECT * FROM table1, table2, table3 WHERE table1.id = table2.id AND table1.id = table3.id";

while ($row=mysql_fetch_array($result)) {
$name = $row["table1.Name"];
$phone = $row["table2.phone"];
echo $name;
echo $phone;
}

and it doesn't return any result.
can someone help me????
thank you so much!!

[arktkbear]

if i'm not mistaken this particular query will result in one table being returned. so you'll only have one row of data, therefore no 'table1.name'. but you will have 'Name'

doug

[Anon]

First, I don't see you actually issuing the query anywhere.

Second, you can't use a '.' in PHP for an array index, so fetch_array won't use that. If the two tables have a field with the same name the LAST one returned by the query will be the ONLY one referred to by that index. If this is the case, you'll need to alias the fields in your query.