mysql query for upto a certain date

search from start date to current date

[rscrsc]

Hi I was wondering if someone would be kind enough to help me out with the following questions.

I am trying to do a query in mysql that will query a date table. A user will be entering a date and I need to query to search from the entered date upto the current time

For example if a user enters 2006-02-02 I would like to query from 2006-02-02 to todays date.

How would the mysql query look like

select ip_src, ip_dst, sport, dport, timestamp, sig_name from acid_event where timestamp between '2006-01-22%' and?

how would I tell the following script to search for upto today. Or if there is a better way to do it please advice.

thanks for the help and advice.

[mooger35]

you could use CURRENT_DATE

[Habtom]

I would set the $currentdate = date(SET THE FORMAT HERE);

and use the $currentdate in the query '. $currentdate .'