[SOLVED] PHP mysql query not working

[mike12255]

I have the following line:

 

<?php

$query = "SELECT * FROM `phpforum_tutorial` WHERE `postid` = $id AND WHERE `area` = math";
?>

 

I dont recive an error from the query but i tried importing it into phpmyadmin and nothing came up, well an error did so i know i did the query wrong, anyone know my mistake?

[allworknoplay]

bad query...use this:

 

<?php

$query = "SELECT * FROM `phpforum_tutorial` WHERE `postid` = $id AND `area` = math";
?>

[genericnumber1]

SELECT * FROM `phpforum_tutorial` WHERE `postid` = $id AND `area` = 'math'

 

You need quotes around math if you don't want it to think it's a non-string, and you only need to say WHERE once.

[mike12255]

ok, it worked, thanks mates. Wasnt sure about the second WHERE and had no idea about the quotes