How to make a Category pages with php ?

[thme01]

Hey

 

i want to make category pages with php.

so i have embeded youtube videos on my website

and i want to make a category so that every embeded link that is named under that category goes on the new web page

i am making.

so lets say i have a category in my table that is called "Call of duty black ops"

would the code be something like this ?

 

( and yes i want it to be ordered by date aswell )

 

 

$query = "SELECT *
          FROM `G4V_Videos`.`Category`.`Call of duty black ops`
          ORDER BY `Date added` DESC
          LIMIT 24";
$result = mysql_query($query);

 

thanks guys!