-
MySQL Bug
For some reason I can't compare a Date entry to the curDate() function in an SQL statement off of the mySQL server on bizhat.
On my installation I can use:
"SELECT * FROM Events WHERE date > curdate() ORDER BY Events.Date ASC LIMIT 0,3"
as a query to select the next 3 events in a calendar to display on the front page.
When I port this across to the bizhat server i just get a query returning nothing (not even an error) - has anyone got any ideas?
-
phpMyAdmin didnt wowk?????????/
why ??????????????
-
phpMyAdmin was fine, the query returning from mySQL was the problem - it just returned nothing...
Deleted the whole table and reinserted the data - that made it happy at least