Dealing with Flickr Data

27 08 2010

I wanted to create a database on my local box of various flickr pics related primarily to flowers. Read the rest of this entry »





Triggers: An Introduction

22 07 2010

Triggers is one of the subjects you need to master in order to become certified as a MySQL Developer (see http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=41&p_exam_id=1Z0_872). Whereas only 5% of Exam II is devoted to this subject, Read the rest of this entry »





Joins: Inner vs Outer, etc.

18 07 2010

As a PHP Developer, there is one interview question you can usually count on which is actually a database-related question. Read the rest of this entry »





Multi-Dimensional Array Fun!

8 07 2010

Working with multi-dimensional arrays in PHP can actually be fun. There is virtually every array function built into PHP that you could hope for. That said, one must carefully choose the right one(s). Read the rest of this entry »








%d bloggers like this: