POST variable in SELECT statement

I created a form to submit a date to a php file, but how do you get the QUERY statement to search for the date submitted by the form?

$query = select * from mytable where myfield = $_POST[myformfield]";

The statement above actually received the variable, but the results are blank. I had to enclose the $_POST[variable] in quotes for it to work. I received "syntax error" without the quotes around $_POST. Help me.

post the code you are currently using that gets tyhe error so I can take a look.

if (isset ($_POST[submit])) {
}
$query = 'SELECT * FROM Tickets LEFT JOIN Students ON Tickets.`Student Id`=Students.Id WHERE Date="2004-03-25" AND `Comment Id` = "$_POST[code]" ORDER BY `Student Id`';

// Define the query
if ($r = mysql_query ($query)) {

try the query like this

$query = "SELECT * FROM Tickets LEFT JOIN Students ON Tickets.`Student Id`=Students.Id WHERE Date='2004-03-25' AND `Comment Id` = '$_POST[code]' ORDER BY `Student Id`";

see if that makes any difference. another thing to do would be to echo the query before executing it to see if the query is well formed.

I don't think arrays get expanded automatically, since it is ambiguous. Try changing $_POST[code] in the query statement to ${_POST['code']}.