NYCPHP Meetup

[Analysis & Solutions]

Hi Joshua:

I'd second Hans' motion to normalize the data.  First, because it allows 
adding, editing, deleting categories throughout the database by adjusting 
the values in one field, rather than having to issue several ALTER TABLE 
queries.  Second, it allows long term portability of your schema to other 
database management systems.

Considering your setup, I'd use a char(1) field so you can quickly make
sense out of the abbreviated value when viewing the output from the main
table.

--Dan

-- 
     FREE scripts that make web and database programming easier
           http://www.analysisandsolutions.com/software/
 T H E   A N A L Y S I S   A N D   S O L U T I O N S   C O M P A N Y
 4015 7th Ave #4AJ, Brooklyn NY    v: 718-854-0335   f: 718-854-0409