<? echo

Project Statuses

Mental Fusion - 85%
FusionBB - 2%
This webpage is built with W3C compliant HTML5.
This webpage is built with W3C compliant CSS3.
Download: Fast, Fun, Awesome
Opera, the fastest and most secure web browser

MySQL Example Updates

The EAV Database Model

Posted: March 2, 2012 11:40 AM CST by Michael

I've been doing a bit of research lately into different design patterns and models for both PHP and MySQL. One that I came across for MySQL that I was unfamiliar with was the EAV model. I didn't have a firm grasp of the EAV model, so I read up a bit on it and can now share what I've learned with you.

What is the EAV model? EAV stands for entity-attribute-value. The idea ... continue reading

The MySQL JOIN Statement

Posted: February 14, 2012 11:32 AM CST by Michael

There are three major types of JOIN in MySQL. Those are: INNER, LEFT, and RIGHT.

Odds are, you've used INNER JOIN without even knowing it. INNER JOIN is synonymous with the MySQL comma operator (which is, you guessed ... continue reading

; ?>