Duplicate Query Results

[pureDesi]

[code]SELECT boards.boardID, boards.title, categories.title FROM boards, categories[/code]

Whenever I run this query I get double results for everything, I'm almost certain this is an easy problem, however I'm just starting to learn MySQL.
Thanks for the help.

[jawapro]

It is selecting EVERYTHING in boards for each title in categories. It is then selecting all things in boards for each title in categories.

Very confusing - and hardly ever what you want.

Somehow you need to join the two tables. Such as if boards has a categoriesID or something to say what category it belongs in. Also assuming that categories also has a categoriesID. Ok, so you want to select the boardID, board.title, and categories.title BUT only the category.title that matches the categoriesID in the boards table. Make any sense?

[code]SELECT boards.boardID, boards.title, categories.title FROM boards, categories WHERE boards.categoriesID = categories.categoriesID[/code]

Assuming thats how you link the categories, that should work. Change it as required.

Hope I've been a help.

JP

[pureDesi]

Works like a charm, and not only that I now understand it. Thank you jawapro.

[jawapro]

Glad I could be of assistance.

I've been on boards like these asking silly questions myself plenty of times.

Good luck with it all.