WHERE IN() Formatting Issue

[Submerged]

I think I am just messing up the syntax of the IN() function in this where clause:

[code=php:0]<?
$array[1] = '1';
$array[2] = '2';

$implode = implode("','",$array);

$query = "SELECT * FROM `sites` WHERE IN '('$implode')' ORDER BY rating DESC";

?>

Query prints out as:
SELECT * FROM `sites` WHERE IN '('1','2')' ORDER BY rating DESC[/code]



It should print out several hundred entries from my database, and I've tested enough code with this script to know that the entries themselves aren't the problem.  It's just when I added the "IN()" part that it screwed up.  Probably something simple :)  Thanks!

-Submerged

[AndyB]

SELECT * FROM `sites` WHERE [b]some_field_name[/b] IN ('1','2') ORDER BY rating DESC

[Submerged]

Oh... lol, I had the category in there before, must've accidently deleted it while I was messing with the code.  But it was the use of apostrophies I really needed to see, and now it's working great so thanks :)