fetch array from several tables

admin

Administrator
Staff member
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!!
 
Back
Top