Howdy,

I'm making a simple poll script, and i need to display the poll of todays date, so i threw a time() into the colom "date"
now, how would i display the poll of todays date?

something like:

$query = "SELECT pollid, date FROM poll WHERE date = ?" ;

thanks in advance

If the date column is only yyyy-mm-dd then you could try

SELECT pollid, date FROM poll WHERE date = NOW()

As Rich2k mentioned, it all depends how the date is stored.. Did you build a datestamp in PHP first? Use the mysql datestamp? I don't have the specifics, but you either need to build it into the query (if you're using mysql's datestamping abilities) or build a datestamp for today (if using php's)

i just used time()
which includes the seconds and minutes

someone

time() = seconds since the unix epoch, it woulda been easier if you used date() in conjunction with time so that you could just put the date in the date collumn.

like date(time())?