Problem with mysql/php

[APUTP08]

$query = 'SELECT FROM WHERE >=Now() AND ='$_POST['select']'';
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
where post select is from a previous page, select works in basic text, the error message i get is:
Parse error: parse error in C:\wamp\www*Status.php on line 22

[coldwerturkey]

unescaped apostrophes as highlighted in red:

$query = 'SELECT FROM WHERE >=Now() AND *** ='$_POST['select']'';

better would be:

$query = "SELECT * FROM **** WHERE **** >=Now() AND **** ='{$_POST['select']}'";

even better would be:

$query = "SELECT * FROM **** WHERE **** >=Now() AND **** ='".mysql_real_escape_string($_POST['select'])."'";

[APUTP08]

Problem solved, thanks for the help=)