mysql_fetch_array from several tables in query
Posted: Thu Nov 06, 2003 10:43 am
Hello all,
I have a query which involves several tables that have the same fields.
How can i differ the field name in the mysql_fetch_array function?
suppose i have a date field in table1 and table2
when i write
which one will it give table1 date or table2 date? how can access them both?
Thanks
I have a query which involves several tables that have the same fields.
How can i differ the field name in the mysql_fetch_array function?
suppose i have a date field in table1 and table2
when i write
Code: Select all
$result=mysql_query($sql);
$resultAraay=mysql_fetch_array($result)
echo $resultAraay['date'];
?>Thanks