To find out if a cell contains the newline character in Excel, use this tip.
Excel: Finding the second (or Nth) largest number
To find out the second (or Nth) largest number in a column in Excel, just use the LARGE() function.
MySQL: Getting records near a date
I recently had to write a query in PHP that returned a ranking per a specified date and time. The rankings get saved every hour, but not precisely on the hour. The user does not know when the rankings were saved precisely but wants to know what the ranking was per “yyyy-mm-dd hh:mm” or as… Continue reading »
PHP: Switch structure to check variable
Suppose you want to use PHP check the variable $var and see if it smaller than, equal to or larger than zero. There are two ways to go about this: switch($var) { case 0: echo “Equal to zero”; break; case ($var<0): echo “Smaller than zero!”; break; case ($var>0): echo “Larger than zero!”; break; } The… Continue reading »
Use two sound outputs in Vista at the same time
If you want to listen to music on two different sound systems in Vista at the same time, read this!
Equations not displaying when printing/saving in Word 2007
If Word 2007 equations do not display when printing, try this solution.
PHP: Get last iteration in a for..each loop
Find out how to check if you are currently in the first or last iteration of your foreach loop in PHP.
Enable image upload in FCKEditor
My goal is to enable image uploading in FCKEditor. I am using FCKeditor in order to allow a customer to create HTML e-mails that can be sent to their clients using PHPList (2.10.12). What I would have thought is something that should work at the click of a button took me a few hours to… Continue reading »
Convert videos to iPod ready format
To simplify the process of converting videos to an iPod ready format, use the following script available here. This script works by running through all files in a folder. If the video has the .avi format, it will try to re-encode that video using the ffmpeg engine (included in the ZIP archive). The .bat file… Continue reading »