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
differentiating between identical fields
Moderator: General Moderators
Re: differentiating between identical fields
Column aliases
Re: differentiating between identical fields
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
http://www.geeksengine.com/database/bas ... -alias.phpjosh wrote:Column aliases
Re: differentiating between identical fields
Thank you gentlemen!