meanster99
Well-known member
Hi all,
Does anyone know how if it's possible to have a URL query (similar to the ones talked about here: personalised query ) that will return all records with a date field (date_of_event) containing today's date? In other words I want to query all the current days events, everyday, whenever I click the link. Going one step further, I would like the URL query to return records for the next 5 days. Are either of these even possible?
I found this mySQL where clause: SELECT * FROM 'myTable' WHERE DATE('myDate') = DATE(NOW())
...but I'm not sure Dadabik would recognise the NOW() function (I also read I could use CURDATE() ).
Please can anyone help me get a where clause with URL encoding that would do what I'm after?|
Thanks,
Matt
Does anyone know how if it's possible to have a URL query (similar to the ones talked about here: personalised query ) that will return all records with a date field (date_of_event) containing today's date? In other words I want to query all the current days events, everyday, whenever I click the link. Going one step further, I would like the URL query to return records for the next 5 days. Are either of these even possible?
I found this mySQL where clause: SELECT * FROM 'myTable' WHERE DATE('myDate') = DATE(NOW())
...but I'm not sure Dadabik would recognise the NOW() function (I also read I could use CURDATE() ).
Please can anyone help me get a where clause with URL encoding that would do what I'm after?|
Thanks,
Matt