[SOLVED] How do I only select certain MySQL records?

[Klance]

Ok, so I have a form where you can enter the type of console and the difficulty of the game and it's put into one table. So say I want to view PS2 difficulty HARD how would I select only records that have console PS2 AND difficulty HARD using a MySQL query?

[darkfreaks]

<?php
$sql="SELECT *FROM ps2_console WHERE  hard=$hard ORDER BY $hard";
$result= mysql_query($sql) or die(mysql_error());
?>

[CrustyDOD]

SELECT FROM ...
WHERE console = 'PS2'
AND difficulty = 'HARD'

 

That's about it

[Klance]

Thank you that worked.