PHP help
 

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 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=''";

HELP |banghead|

Try something like this, define the date first. No coffee in my system yet so it might not work.

worked like a freakin charm!

Greatly appreciated JK :)

Other options are:

SELECT * FROM tablename WHERE date = now();

OR

SELECT * FROM tablename WHERE date BETWEEN '2007-06-01 00:00:00' AND '2007-06-01 23:59:59'

really depends on your database structure. Always multiple ways to skin a cat.

Just to explain why it is what you did, didn't work... The tags are used to tell your server that what lies between them is going to be PHP code. The thing is, given that you had a variable, $query_rsfeatured, in your script already, you probably had those tags somewhere else before and after the code you quoted above. Placing another pair between those tags would produce an error. In other words, if you've already written .