jasom

wait minute how can you join that's table even each table there is no same field to join it, do i wrong this issue?

You can do INNER JOIN but it will results with duplicated rows. Sollution will consist from some kind of PHP hack.

Thank you for your hint.

Hi guys,

I'm new in PHP. I cannot find tutorial about how to get all categories article is listed in together with article title, author printed on the article list.

I have 4 tables in DB:

articles = DB for articles detailse: id, title, user_id, post_date

articles_categories = id, category_id

categories = category_id, category_name

users = user_id, user_name, user_mail

I want to do this:

Which script logic do you suggest? Any kind of help is welcomed.