Whos up late? Need simple help! Please?

[Anon]

Hello,

Ok...easy question for any pro, and it'll help me out a ton.

I have a MySQL DB.

It has 4 columns. The 3rd coulm is a CATEGORY column, defined by a number.

Now out of the 350 rows in the DB, there are only 7 different CATEGORIES these rows can get assigned to.

SOooo, how do I call, via PHP everything in just ONE CATEGORY?

For instance: Entry 51, 87, 243, 111, and 103 ARE ALL in Category 1. How do I call all of these guys in just category 1?

Here's the PHP I've got so far...please help!!! (I put question marks on the part I'm not sure about)

        $sql = "SELECT trailerId, title, link, category ";
		$sql.= "FROM Trailers ";
        $sql.= "GROUP BY ??????? ";
		$sql.= "ORDER BY title DESC ";

	$res = mysql_query( $sql );

$i = 1;
while ( $arr = mysql_fetch_row($res) )

[daarius]

SELECT trailerId, title, link, category FROM Trailers WHERE category=1 ORDER BY title DESC

should do the trick.