I recently worked with another developer to convert a lot of MSSQL stored procedures into PHP/MySQL functions. Along the way I learned a bunch of new things which I figured would be helpful to you.
The MSSQL “ISNULL(expr1,expr2)” equivalent in MySQL is “IFNULL()”.
The MSSQL “TOP” keyword (to limit returns returned) equivalent in MySQL is “LIMIT”.
SQL query […]
One of the greatest headaches for a web developer is making sure things work the same regardless of platform or browser. One of the biggest problems for a Windows-only guy like me, is making sure that things work on a Mac — specifically Safari. But, those days are over…
Apparently Safari is now being developed for Windows. […]
Being a freelancer is awesome for so many reasons. However, it comes with a whole lotta responsibility. I don’t really mind the responsibility, especially since I deal with stress pretty well. But sometimes it can really eat into your personal live, and it’s hard finding time to have fun. Such has been my life over […]
Everytime you want to create a UniqueID, don’t bother with hashing or using a random number generator… Instead, use the System.Guid.NewGuid() function to generate a 128-bit integer.
Read more about using the GUID creation function, with examples.
An interesting article giving an overview of the various character types under Unicode and what C#/dotNet provide.
If you’re looking for a new IDE, check out the Eclipse project which is an open-source java-based IDE that supports plugins for a variety of features and languages including PHPEclipse. This is an extremely robust application, tho I haven’t had much time to play around with it yet.
I also found a program the other night […]
Incase you haven’t heard of “Open Source“, check out the Wikipedia description of it.
I have recently been playing with open-source projects during the last few months, and as a programmer, I am thrilled at the concept of free software that is robust, easy to install, and (generally) easy to configure. I also love the ability […]
Picasa is a terrific photo cataloging program from Google which allows you to catalog photos, create labels, manipulate your photos and share them with friends.
Picasa has a Webpage Export feature where you can export selected images into webpage templates for gallery-style viewing, and it will automatically resize the images and create thumbnails for you. You […]