[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 -- Mich

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: Mich

[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