Error from query

[86Stang]

My head hurts...

 

I've got this query:

 

"SELECT * FROM mytable WHERE signup_date >= $_POST['start_date'] AND signup_date <= $_POST['end_date'] ORDER BY signup_date DESC"

 

and it's throwing this error:

 

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /path/path/path/filename.php on line 13

 

I've ensured the post data is coming over from the form that starts this query so I'm guessing it has something to do with my syntax?

[lonewolf217]

you can try echo'ing the query to make sure it is what you expect

 

you can try this as well (braces around the variables)

"SELECT * FROM mytable WHERE signup_date >= {$_POST['start_date']} AND signup_date <= {$_POST['end_date']} ORDER BY signup_date DESC"

[rhodesa]

the braces should do the trick...also, you can shorten the query:
[code=php:0]$sql = "SELECT * FROM mytable WHERE signup_date BETWEEN {$_POST['start_date']} AND {$_POST['end_date']} ORDER BY signup_date DESC";

 

edit: another note...you should pass the $_POST['start_date'] through mysql_real_escape_string() to sanitize it