|
|
Posted by alvonsius on 11/17/05 11:39
Of course when you use SELECT A.name, B.name blah blah you would get
the same column "name" as result (you can try this in console too), so
the best idea is using alias that representing the column like this :
SELECT
A.name AS name_A,
B.name AS name_B
FROM A, B WHERE A.id = B.id
and to access it just use $row['name_A'] ... the variable name still
gave me the information I need
PS: why don't you use LEFT JOIN ??
Navigation:
[Reply to this message]
|