PHP help

[Porn Junkie]

I need to write a select statement that basically pulls records out for the current date. Kind of what link lists use to show the days current selections.

I use <?php echo(date('F j, Y'))?> in my submit form but can't seem to figure out how to do a select to retrieve just todays submissions.

I thought this would work but it doesn't. $query_rsfeatured = "SELECT * FROM tsoomain WHERE tsoomain.ldate='<?php echo(date('F j, Y'))?>'";

HELP