Prudential Castle Point Realty needed modifications to the system used for creating high resolution printable PDF files to display property information in the windows of their branches.
Calculating someones age from a given date of birth using MySQL isn't especially complex but I've seen a few long-winded approaches to the problem so I thought I share my own method.
"SELECT FLOOR(DATEDIFF(NOW(), `date_of_birth`) / 365.25) AS 'age' FROM `users`"
The above example assumes there is a
DATE field called
date_of_birth in a table called
users. You could expand this example to search for users between a particular date range, for instance users between the ages 27 and 33.
"SELECT FLOOR(DATEDIFF(NOW(), `date_of_birth`) / 365.25) AS 'age' FROM `users` WHERE (age >= 27 AND age <= 33)"
MyJob is a service where users can search Yahoo Jobs, Monster, Indeed, SimplyHired, CareerBuilder using Yahoo Pipes to create an aggregated list of vacancies based on your search criteria.
Today we've launched the third version of our Playlists.net iOS app for iPad & iPhone. This version of the app runs on our new API which allowed features such as New Releases, Playlist Charts and Reviews to be implemented along with the ability to pin playlists to a location.
The app was developed by Fluid Pixel who put a truly staggering amount of work into delivering a product that exceeded all of our expectations, so a massive thanks must go out to them.