Php Associated array in join query has same keys

Question

I am trying to retrieve 'date_and_time' field from two different tables of a mysql database using join query. Since the field name in both tables are same, the key name in the return result of an associated array being overwritten by the new key. How to change the key name if it exists, or is there any possibility to add table name along with field name as a key of associative array.

Change the query: SELECT tableA.column AS yourColumnAlias, tableB.column as differentAlias ... — tillz
– tillz, Commented Sep 14, 2015 at 16:36
Thank u dude u save a lot it worked :) post it as an answer pls. — Crysis
– Crysis, Commented Sep 14, 2015 at 16:47

tillz · Accepted Answer · 2015-09-14 16:51:22Z

2

Ok, just for the people checking these post later: In SQL, tables & columns can be aliased: To fetch two columns which originally have the same name, it's easy to 'rename' them:

SELECT tableA.column AS yourColumnAlias, tableB.column as differentAlias FROM ...

will return a result-set in the form of

---------------------------------------------------------------------
|yourColumnAlias                     |differentAlias                |
|value from tableA.column            |value from tableB.column      |

P.S.: In complex Joins, this also helps to keep Queries readable, as Tables can also be aliased.

answered Sep 14, 2015 at 16:51

tillz

2,10815 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Php Associated array in join query has same keys

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related