Work
Efficiently Selecting Random Rows From a MySQL Table
It’s tempting to simply use MySQL’s RAND() function to select random records from a table. Consider the following query: However, when considering overhead, this is a rather expensive method to [...]
Parsing Large XML Files Using PHP
I ran into a situation where I needed to parse a large (1 GB) XML file in order to extract the data into a MySQL table. As usual, I did [...]
Oh My Word!
About a month ago, we ran into a problem with hyperlinks in a Microsoft Word document. Wait! What? H-y-p-e-r-l-i-n-k-s? Yup. The most basic operation known in the history of the [...]
