queries with left joints

http403

ok i have this query

SELECT users.id, users.username, content.id, content.author, content.moment FROM content LEFT JOIN users ON content.author=users.username where content.catid='$catid' ORDER BY content.id desc

and if u can see I have to fields on database called the same way "id" one in table users and other in table content.
The problem now is how can I fetch them? coz for example if I use fetchrow id it only returns me the content id...

any ideas?

thxs

bav

Alias it in the select statement

the_Igel

or you can use integer index.

$row = mysql_fetch_array(...));

$content_id = $row[3];

Weedpacket

Originally posted by the_Igel
or you can use integer index.

$row = mysql_fetch_array(...));

$content_id = $row[3];

Sure you don't mean $row[2]? 🙂🙂

Ah, the fun and games of living dangerously...🙂

Andy_B2

"SELECT users.id AS userID, users.username, content.id AS contentID....."

then after getting the array:

$myarray["userID"]

will give the value of users.id

http403

oh yes AS (alias)... thxs 😃