WHERE + variable

[MarcusZ]

Hi.

I was wondering how to use WHERE and a variable in a query. I get an error message with this code:

$result = mysql_query('SELECT * FROM `reply` WHERE `id`=$date', $con);

Thanks

[fenway]

What error message??????

[MarcusZ]

I solved it myself.

The error message was something like: couldn't find $mdate coloumn.

But this code is working now:

$result = mysql_query("SELECT * FROM `reply` WHERE `id`='$date'", $con);