[PHP] SQL / PHP Join issue.

Hi, I'm having a little trouble with this join statement I'm working on. What I *think* is happening is that PHP is getting confused with the ID field that is the same for the three different tables. When I go through the result set, you can see that the field ID gets used a couple of times.

Re: [PHP] SQL / PHP Join issue.

You need to either alias the columns i.e. career.id as careerid or rename your columns i.e. change the id to careerid calendarid. The second option would be best because that way your columns are descriptive. HTH Clint -- Original Message -- From:

[PHP] SQL / PHP Join issue. - SOLVED

Hi all. Never mind my previous post. I fixed my SQL statements by using AS statements. For example: SELECT calendar.ID AS calendar_ID,calendar.Calendar_Title AS Calendar_Title,calendar.Add_To_Scroller AS calendar_Add_To_Scroller... That worked like I wanted it to. Thanks! mto --