CSS borders in Firefox and IE

FF will display borders OUTSIDE of a div element, adding the border width to the element widget. IE will squeeze borders INSIDE and the total width stays the same.

Workaround for this which makes FF behave like IE:

* {
-moz-box-sizing: border-box;

(* applies it to all elements, if you don’t need that, add it only to a desired element)

Dates in MySQL

PhpBB stores dates in INT fields in Unix time format, meaning the integer value equals to the number of seconds since 1/1/1970.

To view the date in standard format, use FROM_UNIXTIME(field) function:

select user_id, username, FROM_UNIXTIME(user_regdate) as d from phpbb_users

To select a time interval, we need to use FROM_UNIXTIME( ) function with a DATE_ADD() or DATE_SUB() .

Example: select fields created less than 23 hours ago:

select user_id from phpbb_users where
FROM_UNIXTIME(user_regdate) > DATE_SUB(NOW(), interval 23 hour)

MySQL date functions reference.

XSL: Several XML files into one file

We have a lot of separate files and want to put them together into one.

Step 1: Create a list of all filenames as XML file


Step 2: Create an XSL transform

<xsl:template match="//files">
<xsl:for-each select="file">
<xsl:copy-of select="document(.)"/>

Note the use of “copy-of” – it will copy all the nodes and attributes from the source XML.

VbScript: Number of days in month


daysInMonth = Day(DateSerial(thisYear, thisMonth + 1, 0))

It adds 1 to the month and uses DateSerial to get a Date representing the 0th day of the following month. That is the last day of the month you entered. The Day function gives you the number of that day, which equals the number of days in the month.