database syntax problem

[furtivefelon]

hi, i tried to query mysql database in my code, but it returns an error.. here is the code:

$query = "SELECT id, date, topic, description, content, " .  				"FROM notes " .  				"WHERE id={$_REQUEST['notesId']} ";

and here is the error:
couldn't query the notes table!
mySQL reports: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM notes WHERE id=6' at line 1

what do you think is wrong?

[devinemke]

$query = "SELECT id, date, topic, description, content FROM notes WHERE id = '" . $_REQUEST['notesId'] . "'";

[furtivefelon]

YES that works! can you tell me what i did wrong?

[furtivefelon]

ohhh, i got it, nevermind!