[SOLVED] Select Statement help

[lmhart]

I need assistance to get this to work correctly.

 

I can not figure out how to put quotes around something in my select statement

 

This works from phpMyAdmin

select * from orders where date="11-06-09"

 

but my statement on my page does not work cause I can not figure out how to get the ""in the statement. I vefired by echoing $today was giving the correct var.

 

$result = mysql_query("SELECT * FROM orders where date = ".$today." ");

 

Thanks

[mrMarcus]

try:

 

$result = mysql_query("SELECT * FROM orders WHERE date = '".$today."'");

 

this is concatenation.

[lmhart]

thanks