SQL Question

[Manat]

<?php

$contest="foremacat";

$where = " WHERE Status='$d' AND Contest_name=$contest";

See I added the Contest_name=$contest
But the previous programmer added Status=$d

He put a $variable in single quotes, while I didn't.
His code worked before while it was in single quotes.

Is there something wrong with my code?
Am I not supposed to NOT put it in single quotes?

I'm using PHP4 and MySQL as the DB.

Thank You

[Lars_Berg]

It depends on which datatype your column has

if contest is char or datetime you need apostrophes around the vakue.

[Manat]

Contest_name field in the MySQL database is varchar(10).
So what would be the correct syntax?

$contest="blocktober";
$where = " WHERE Status='d' AND Contest_name=$contest";

OR

$contest="blocktober";
$where = " WHERE Status='d' AND Contest_name='$contest'";

OR

Something else?????

Thank You

[hand]

$contest="blocktober";
$where = " WHERE Status='$d' AND Contest_name='$contest'";