Re: Join table with clashing fieldnames

At 1:22 PM +0000 11/8/06, Kris Leech wrote:

I have an SQL query which has a simple join, this works and is fine the fields from the secondary table are added to the returned array. But what happens if I add another JOIN to a table which has fields which are the same name? Is there any way to have PHP prefix the key's (fieldnames) of the joined fields? Many thanks, Kris.

Kris: Both this list and you might be better served if you directed your mysql question to a mysql list. Try: http://lists.nyphp.org/mailman/listinfo/mysql Best, tedd -- ------- http://sperling.com http://ancientstones.com http://earthstones.com