Page 1 of 1
differentiating between identical fields
Posted: Sun Sep 05, 2010 10:36 am
by delpi767
if I am joining two tables (golfers and residents) that both have the column "posted" how do I differentiate between these columns in php?
If I want to reference the column posted from both tables how do I do so?
Thanks,
Mac
Re: differentiating between identical fields
Posted: Sun Sep 05, 2010 12:11 pm
by josh
Column aliases
Re: differentiating between identical fields
Posted: Sun Sep 05, 2010 1:27 pm
by McInfo
If you don't assign aliases to each returned field in your query, you will have to fetch the result as a numeric array with a "fetch_row" function (for example, mysql_fetch_row()). You will not be able to fetch an associative array because there will be key conflicts which will be silently resolved by overwriting values.
Re: differentiating between identical fields
Posted: Sun Sep 05, 2010 1:41 pm
by califdon
Re: differentiating between identical fields
Posted: Mon Sep 06, 2010 9:01 am
by delpi767
Thank you gentlemen!