[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
To: [EMAIL PROTECTED]
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
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
] 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
'];
Haven't tried it, but I think it would work.
good luck
Howard
-Original Message-
From: Trevor Lanyon [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 28 August 2001 4:13 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Accessing fields with the same name in MySQL
tbl_job
---
id
name_id
job