current date

[Anon]

Hi,
i have the following line in my script:

$query = \"SELECT * FROM picks WHERE appear_date=?\";

What do i need in place of the \"?\" to get the current date in the format \"n/j/Y\"?

Cheers,
micmac

[Anon]

$cdate = date("d-m-Y")

$query = "select * from picks where appear_date='$cdate'";
where d - day
m - month
y - year

Solomon