[RESOLVED] multiple query results

[Rahish]

SELECT * FROM categories, forums ORDER BY forums.order ASC;

This results give me results twice or sometime more as you can see from the picture.
http://img508.imageshack.us/my.php?image=picture1qo1.png

can anyone please help me:o

[alimadzi]

You need to add a constraint that connects the corresponding rows of each table. I'd have to see your DB schema to give you an exact answer, but it will probably be something like... WHERE categories.category_id = forums.category_id

This goes between your FROM and ORDER BY clauses.