join question - field names

when joining 2 tables and in the tables they both have a field that has the same name, is there a way to display both when doing the call?

when doing something like

Code:

SELECT table1.time_created, table2.time_created FROM table1 left join table2

it shows only one time_created

[Free WordPress Themes]

SELECT table1.time_created AS time1, table2.time_created AS time2 FROM table1 left join table2

gah...i should have known that...i know i have used that AS command before hehe

[Join us @ facebook]

Hmmm, I believe the first implementation will work too, but you will have to call them with their numbers not names ( eg. $rec[0] . $rec[1] )

[Free WordPress Themes]

Hmmm, I believe the first implementation will work too, but you will have to call them with their numbers not names ( eg. $rec[0] . $rec[1] )

yes sure but it works so good working with acc. arrays or objets

[Join us @ facebook]

I agree, it's the worst way to do this, I just wanted to point out that it can be done this way too

[Free WordPress Themes]

I have very often dynamic field names like:

$sql = sprintf("SELECT name%s FROM table1", $lang);

in this case it's the best way to use some new "name" in your statement

[Guest]

[35.717]

Googlebot, Yahoo crawler