Fetching data from 2 mysql tables with the same column name

[eMonk]

I'm running a mysql select query and just found out both tables have a same column.

 

This is the column both tables have which is city_id:

 

$city_id = $row['city_id'];

 

I tried the following but it didn't work:

 

$city_id = $row['tablename.city_id'];

 

How can I do this?

[chintansshah]

You should use alias in mysql query.

 

Ex. Select table1.city_id as city_id1, table2.city_id as city_id2 from table1,table2

 

So, you will get $row['city_id1']; and $row['city_id2']

 

It will work