Tech Thought

Tech tips, hints, and general musings. PHP, Perl, Mysql, Javascript, AJAX, JSON, Linux, Mac OSX

Entries for the ‘database’ Category

How-To: Fix Problems with Google Maps and Internet Explorer: Grey Background, Clipping, Off centre etc

We’ve just developed a Google Maps application – all using Firefox – and started to test it in IE.  We were shocked to find that our map looks completely off centre and have a big grey backround across them.  Moving the map with the mouse causes them to clip and look shocking! See below: So [...]

Comments (1)

How-To: Add days to a date with Mysql

A common thing you need to do in mysql is add an interval of time to a date in a query.  Here is a simple example of how to do this: SELECT Risk.* FROM Risk WHERE (Risk.Next_Reminder_Due IS NULL OR Risk.Next_Reminder_Due < DATE_ADD(NOW(), INTERVAL 7 DAY)) This returns all ‘risks’ that either have a Next [...]

Leave a Comment