Issue parsing joins

[nextgengames]

Hey,

Im having some problems with parsing a join with the query below. Both tables have a id field but i need the id from the articles field for the link to content.php.

Any ideas on how to display this ?

Query:
SELECT * FROM cs_articlesJOIN cs_categories ON cs_articles.category = cs_categories.alt_id ORDER BY cs_articles.id DESC LIMIT 0 , 5

Tried using mysql_assoc:

echo ['cs_articles.id']

[Weedpacket]

Try using print_r() on the array returned by mysql_assoc() to see what names are used. Better yet, explicitly state which columns you require (instead of blindly writing *) and then you can use aliases and name the returned columns whatever you want.