Im using PHP5 with MySQL, and have created a table with a DateTime field.
Firstly, how do i insert the current date/time into it?
INSERT INTO MyTable (RegistrationDate) VALUES (NOW()) ?
Secondly, how can I then query the table, and check between two date ranges, e.g.
SELECT Blarp, Blarp2 FROM MyTable WHERE Registration IS AFTER StartDate AND Registration IS BEFORE EndDate
I've checked the documentation and can't find any good examples, any help please?