I've been having this debate in my mind and alternated my method on the past few projects I've worked on, and now I ask you, the MySQL community.
What is the best way to have a preferences table? Here's what I've been doing: Table preferences basepath varchar(255) adminemail varchar(255) and on and on, a different field for each variable I want stored. Alternatively: Table preferences key varchar(255) value text With a different row for each variable. This is much more dynamic, but is it worth the extra coding? I'd like to hear some opinions on it. Mike -- "I can't believe I ate the whole thing." --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
