Re: Accessing fields with the same name in MySQL

Don't do a SELECT *. Instead, list out the columns you want to select. When you choose the ID columns, alias them. For example: SELECT tbl_job.id job_id, tbl_name.id name_id, . . . . . . A better option, if you have it, is to change your naming conventions in your database. Instead of using ID for your primary key fields, have TABLE_NAME_id instead. That eliminates this type of problem. New here so sorry if this has been answered earlier, and I missed the message. Joe "Rick Emery" <remery@excel.com> wrote in message news:EAA093B474ABD311A71E00508B5FE08305C2C832@adntex03.us.excel.com... > > Since you're matching on "id", why does it matter which table it came from? > It came from both. > > Perhaps, I do not understand your question. > > rick > -----Original Message----- > From: Trevor Lanyon [mailto:trevor@clearoption.com] > Sent: Monday, August 27, 2001 1:13 PM > To: php-db@lists.php.net > Subject: [PHP-DB] Accessing fields with the same name in MySQL > > > tbl_job > ------- > id > name_id > job > > tbl_name > -------- > id > first > last > > SQL > --- > select * from tbl_name, tbl_job where tbl_name.id = tbl_job.name_id; > > I use mysql_fetch_object to retrieve a row from the above result set. I > have two objects, objName and objJob. The constructor for both objects > accept a result object. How do I reference what table the "id" column came > from. These objects are generic so aliasing is not an option. > > So how to I differentiate what table each column comes from? > > Trevor Lanyon > ClearOption Technologies > 204.889.1906 - Office > 204.831.7243 - Fax > 204.229.2625 - Cellular > http://www.clearoption.com > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net