Accessing fields with the same name in MySQL
| From: | Trevor Lanyon | Date: | Mon, 27 Aug 2001 18:12:41 +0000 |
| Subject: | Accessing fields with the same name in MySQL | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-11861@lists.php.net to get a copy of this message | ||
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