[PHP-DB] RE: [PHP] Enum table entry

2002-10-19 Thread John W. Holmes
There should really be another table for all of this information. Say you're tracking school information for a specific person. That person would have an ID number and you'd store the school information in a separate table that stores the user's ID and the school ID. You could even expand this to t

Re: [PHP-DB] Re: [PHP] Enum table entry

2002-10-19 Thread Ignatius Reilly
<[EMAIL PROTECTED]> Cc: "Shiloh Madsen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, October 19, 2002 9:15 AM Subject: [PHP-DB] Re: [PHP] Enum table entry > You know, I didn't even think about serializing the array. I h

[PHP-DB] Re: [PHP] Enum table entry

2002-10-18 Thread John Nichel
You know, I didn't even think about serializing the array. I have a table set up for spells, one for schools, and a linking table using the spell id and the school id(s). I could have done without the linking table. Some of you people are pretty freakin' smart. :) One note though, when you p

[PHP-DB] Re: [PHP] Enum table entry

2002-10-18 Thread Tom Rogers
Hi, Saturday, October 19, 2002, 2:48:14 PM, you wrote: SM> Have a question that im trying to figure out how to resolve. I have a field type in mysql that is of the enum type. Unless youre familiar with Dungeons and Dragons, you wont get what the values SM> mean, but hopefully youll get the gist