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!