Alternatively Mark, you can replace your query on the date with:
SELECT Count(PageUrl) AS PageCount, PageUrl AS URL FROM tbltracker WHERE HitDateTime BETWEEN '2001-01-01' AND '2001-01-06'AND id='biz' GROUP BY PageUrl ORDER BY Count(PageUrl) DESC
MySQL date format is yyyy-mm-dd
I'm assuming...
query = "SELECT * FROM cal_events AS E INNER JOIN cal_dates AS D" _
& " ON (E.event_id = D.event_id) " _
& " WHERE event_date BETWEEN " _
& ' 2001-03-01 ' _
& " AND " ' 2001-03-31 '
This is an example that works. You may need to check your version of...
Use this if pointing to an ODBC.ini file (you would need to set these values in the ODBC.ini file on your web server along with port address usually 3306) - assumes ODBC MySQL driver is installed.
conn = "DSN=[database name]; UID=[userid]; PWD=[password]; SERVER=[MySQL server IP address]...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.