Problem querying DB for current date

Hi all,
If i have the following query:

$sql = "SELECT * FROM orders WHERE processed = 'N' AND order_date = '$current_date'";

how can i get it to select only those rows with the current date.
I'm currently using

$current_date = date('Ymd');

but the problem is that the date that is stored in the mySQL DB is in UNIX timestamp form. eg

2003-07-07 15:44:36

Can anyone tell me how to write the correct statement?

Cheers,
chrima

$current_date = date ('Y-m-d');

Thanks for the reply,
I've tried that already. My problem is that the string in the DB is longer than just the Y-m-d generated by the date()

What do the dates look like?
If it's full date + time, you could just change your query:

SELECT * FROM orders WHERE processed = 'N' AND order_date = NOW()

(are you sure you don't mean '<=' ?)

This, BTW, is not a unix timestamp:
2003-07-07 15:44:36

It's the way mysql stores dates. A timestamp is a large integer (number of seconds since 1980).

SELECT
*
FROM
orders
WHERE
processed = 'N'
AND
order_date >= '$current_date'
AND
order_date <= '$current_date 23:23:59'