-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Hi all, I'm planning a *very* simple DB to place tips on small biz websites on. I'm having a little trouble conceptualizing how it might work. My schema runs like this: 2 tables content ---- TipId | AuthId | title | keywords | desc | section | text author ---- AuthId | name | email | bio 'section' will be an enum field containing 3 values, the rest is self explanatory. My question is: If I enter a 'tip' and put myself as the author, when /I/ come to write another tip how do I make my query avoid putting another entry in author? I'll be using PHP for the front end. I don't need tecnical help (yet) just a hand seeing how I might plan the code. Many thanks in advance.... - -- Nick Wilson Tel: +45 3325 0688 Fax: +45 3325 0677 Web: www.explodingnet.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8YRHcHpvrrTa6L5oRAhqgAJ4gRJBvjf/bkAWVaP/3rGtNcEvzSgCfe43q eUYlWvn+VzfMQ8RqfjgkiuY= =OwBR -----END PGP SIGNATURE----- --------------------------------------------------------------------- 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