[SOLVED] MYSQL Error

[Aureole]

My query is...

 

$query ="SELECT * FROM `topics` WHERE topic_parent_id='{$_GET['id']}' INNER JOIN topics ON members.mem_id=topics.topic_author_id";

 

The error I receive is:

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INNER JOIN topics ON members.mem_id=topics.topic_author_id' at line 1

 

What's up with that?

[MmmVomit]

Your WHERE clause needs to go after all the JOINs.

[Aureole]

Thanks but now I'm getting:

 

Not unique table/alias: 'topics'

 

Never had that error before, any ideas?

[BlueSkyIS]

if joining a table to itself you'll need to alias it:

 

$query ="SELECT * FROM `topics` A INNER JOIN 'topics' B ON A.mem_id = B.topic_author_id" WHERE A.topic_parent_id='{$_GET['id']}' ;

 

 

but you reference members.mem_id in your join, so i'm thinking you don't mean to join topics to itself??

[Aureole]

No I'm trying to join topics to members so I can get all of the member info like no. of posts etc. without querying again.

[MmmVomit]

INNER JOIN members ON members.mem_id=topics.topic_author_id

[BlueSkyIS]

so you need to rewrite your query to join topics with members, more like this:

 

$query ="SELECT * FROM topics INNER JOIN members ON members.mem_id = topics.topic_author_id WHERE topic_parent_id='{$_GET['id']}' ";

[Aureole]

Ah I see now, silly mistake... thanks a lot.