MYSQL query order problem
Right now I have this:
It orders the categories by ID and then the files within the categories by file_id.
mysql_query("SELECT games.*, categories.* FROM games, categories WHERE categories.category_id = games.category_id AND $cat_q games.verified = 1 AND games.added_date <= '" . strtotime(date('Y-m-d')) . "' ORDER BY file_id DESC LIMIT 4");
How do I changed it so it ordered the categories by a "ordered" field I've created. I want the categories to display in a specific order.