MySQL
How to Access MySQL at Web Hosts Without phpMyAdmin
While most web hosts have phpMyAdmin installed for their customers to use, there are plenty out there that do not. The phpMyAdmin interface is what most developers have become accustomed to when developing MySQL based websites. If phpMyAdmin is not installed on your web host, there are several options that will allow you to access [...]
MySQL Dump of the 50 U.S. States
There have been many times I have needed a list of the 50 U.S. States for web applications. I have probably typed these in a dozen times or more over the years. It seems everytime I search for this list as a MySQL dump I am bombarded with data services trying to sell it for [...]
The SEO Rapper… Again
I am not a big YouTube person. Every once in awhile, I will watch something like Charlie the Unicorn or Lebron James high school highlight reels when I am super bored. Today I had a web developer friend send over a link to a video called Design Coding. Obviously, many of you beat me to [...]
It Takes Lots of Water and Steroids to Grow a Web Developer
I had a conversation with a programmer friend yesterday morning that got me thinking about what it takes to be a successful programmer. Programming, whether it be for the web or software, is a unique and difficult business. The tough thing about being a programmer is that it is impossible to know everything you will [...]
LinkTogether – A Community for Web Designers
First, I would like to welcome all my new subscribers. I have been getting an abnormally large amount of traffic the last few days and I have also seen a big increase in RSS subscriptions so if you’re new around here, welcome! Yesterday, I saw a press release from Network Solutions announcing a new web [...]
University of Northern Colorado Promotional Video
This morning we released a fun and engaging Flash/video promotion for the University of Northern Colorado which I thought some of you may enjoy. Zipline completed the project in conjunction with MagnerSanborn advertising. The project builds on the earlier success of another MagnerSanborn/Zipline joint project, InspiredSeason.com. InspiredSeason.com is a viral video project which promotes Gonzaga [...]
How to Create a Simple Podcast RSS Feed using PHP and MySQL
Generating a podcast RSS feed with PHP is actually very easy. I have had to do it a few different times and every time I do it I have to look up the syntax of the XML document. To save myself time in the future I thought I would document the process here for myself [...]
MooTools / JavaScript Popup Calendar / Date Picker for HTML Forms
MooTools 1.1: If you’re using MooTools 1.1 on a project here is a great MooTools based calendar / date picker popup for use in HTML forms. It is very easy to get running and also to customize. Both the style and position of the calendar can easily be modified. The author also has good instructions [...]
Ranking MySQL Results by Multiple Columns
Today I got a request from a reader to make a post about how to rank MySQL results by multiple columns. This is actually really easy to do so it shouldn’t take long to explain. Basically when doing the query you can just add multiple items in the ORDER BY argument in your MySQL query. [...]
A Non-Review of Dreamweaver CS4
I have used Dreamweaver on and off for a long, long time. I have lived through many versions of the software. It has been my primary development environment for most of my web development career. During these years it has received a lot of criticism from developers because of bloated and messy code created by [...]