I think he's trying to figure out how to use GET values.
M24KPM, the superglobal $_GET contains all GET values passed to a script. So in your example, you could have something like:
$category = $_GET['category'];
$sql = "SELECT * FROM downloads WHERE file_category = $category";
$resource = mysql_query($sql);
while($file = mysql_fetch_assoc($resource)) {
echo $file['filename'] . " " . $file['title'] . " " . $file['size'];
}