[SOLVED] Call Fields With same name

[lordzardeck]

I was just wondering how you would call a field in mysql over two tables with the same name. My select statement is below:

SELECT item.author, item.itemid, item.title, item.publisher, item.gradelevelid, item.accessionnum, itemsubject.itemid, itemsubject.subject, item.accessionnum, circulation.datedue, circulation.itemid FROM item LEFT OUTER JOIN itemsubject on itemsubject.itemid=item.itemid LEFT OUTER JOIN circulation on circulation.itemid=item.itemid

[Mark Baker]

You assign an alias to the column:

SELECT item.author, 
       item.itemid, 
       item.title, 
       item.publisher, 
       item.gradelevelid, 
       item.accessionnum, 
       itemsubject.itemid AS itemsubject_itemid, 
       itemsubject.subject, 
       item.accessionnum, 
       circulation.datedue, 
       circulation.itemid AS circulation_itemid
  FROM item 
  LEFT OUTER JOIN itemsubject 
               ON itemsubject.itemid=item.itemid 
  LEFT OUTER JOIN circulation 
               ON circulation.itemid=item.itemid

Then when you use $row = mysql_fetch_assoc() you can reference $row['circulation_itemid'] or $row['itemsubject_itemid']

[lordzardeck]

Thanks, I should have realized that. I feel so stupid.