Menu
Community /Pin to ProfileBookmark
@NogDogJul 09.2006 — #You'll have to query the fields explicitly:
Now your mysql_fetch array keys will use the names following the "as" keywords in the query above.
searching two tables with the same field names
Morning All!
Simple one for experts like you, but confusing for me.
I have two tables which from which I need to search and extract data at the same time, in the same query. However, the tables share the same field names.
Can a kindly soul show me how my select satement should read, and how I can subsequently extract the data?
The first table is directory_editing. The second table is directory_published.
The field names in both tables are:
– directory_id
– directory_style_id
– directory_name
– time
– e_user_id
Thanks!
Simon
Sign in
to post a comment5 Comments(s) ↴
0
@NogDogJul 09.2006 — #You'll have to query the fields explicitly:<i>
</i>SELECT e.directory_id as e_directory_id,
e.directory_style_id as e_directory_style_id,
e.directory_name as e_directory_name,
e.time as e_time,
e.e_user_id as e_e_user_id,
p.directory_id as p_directory_id,
p.directory_style_id as p_directory_style_id,
p.directory_name as p_directory_name,
p.time as p_time,
p.e_user_id as p_e_user_id
FROM directory_editing e, directory_published p
WHERE <whatever where clause you want to use>
Now your mysql_fetch array keys will use the names following the "as" keywords in the query above.