[SOLVED] Need WHERE in query select with inner join

[Thundarfoot]

I am a noob: here is my sign  ???

 

I have a query select that is joining 3 tables, works great (thanks to the help here).

I am trying to build in a WHERE clause but am having trouble with the syntax.

 

The below code is what I am working with, the red text is where I am trying to add the WHERE

 

$query_Recordset1 = "SELECT * FROM lt_skillcards [color=red]WHERE mobid = 1 [/color] INNER JOIN mobs ON lt_skillcards.mobid = mobs.id INNER JOIN skill_cards ON lt_skillcards.armsid = skill_cards.id ";

 

Thank you in advance for your time.

[Thundarfoot]

hmm guess you cant use colored text inside code block

 

SELECT * FROM lt_skillcards WHERE mobid = 1 INNER JOIN mobs ON lt_skillcards.mobid = mobs.id INNER JOIN skill_cards ON lt_skillcards.armsid = skill_cards.id ";