NYCPHP Meetup

[Chris Bielanski]

Sounds like I'd look first at normalizing the data.
You'd end up with three tables by this example. 

One for all members, one for all membertypes and one associating table
between them.

Unless you really want to keep it all in one table, get away from solving
problems arising from using a single BMFT! (Big Mother-Fraggin Table) :)

Thanks,
Chris Bielanski
Web Programmer, 
International Trademark Association,
1133 Avenue of the Americas, 33rd Floor
New York, NY 10036
+1 (212) 642-1745, f: +1 (212) 768-7796
mailto:cbielanski at inta.org, www.inta.org  
INTA -- 125 Years of Excellence



> -----Original Message-----
> From: jaime bermudez [mailto:jaimeb82 at yahoo.com]
> Sent: Thursday, December 09, 2004 4:47 PM
> To: talk at lists.nyphp.org
> Subject: [nycphp-talk] primary key alphanumerical
> 
> 
> Hi there,
> Is there any way to make a Primary Key that is a
> combination of letters and numbers. I have an
> application form that collects teachers information,
> then every teacher should submit their school
> principal and their school supervisor, the problem is
> that each (PK) is just a consecutive number.
> Therefore, each application contains 3 diferent
> numbers like 001 (for the teacher) 002 (for the
> principal) and 003 (for the supervisor) this gets
> confusing when I try to separate them to transfer from
> MySQL into an Access database. It would be ideal if
> they are something like that : TEA001, PRI001, SUP001,
> etc...
> 
> Any ideas or paths so I can start researching...?
> 
> Thanks in advance, Jaime.
> Gilder Lehrman Institute of American History
> 
> 
> 
> 		
> __________________________________ 
> Do you Yahoo!? 
> Yahoo! Mail - Easier than ever with enhanced search. Learn more.
> http://info.mail.yahoo.com/mail_250
> _______________________________________________
> New York PHP Talk
> Supporting AMP Technology (Apache/MySQL/PHP)
> http://lists.nyphp.org/mailman/listinfo/talk
> http://www.newyorkphp.org
>