VFXArtPortal.com is a service where individuals and companies can publish their artwork, whether it's a 3D rendering, a paper sketch or a video, and connect with others in their industry. Users are also given the ability to create a rich profile where they can display information about themselves, their skill set and advertise their services.
The application was a collaboration between myself & Engageify, a Canadian web-service agency, and was built on my Community Gallery Manager product. The team over at Engageify did a truly remarkable job extending the core product into the finished site & I strongly recommend them if you're looking for an agency to handle the online side of your business.
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.
Creating a new "Reviews" page for the Fitter & Faster Swim Tour website, where users can submit text or video testimonials for one of the events organized by the Fitter & Faster Swim Tour.
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)"