-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
* and then Diana Soares declared.... > On Wed, 2002-02-06 at 11:22, Nick Wilson wrote: > > 2 tables > > content ---- TipId | AuthId | title | keywords | desc | section | text > > author ---- AuthId | name | email | bio > > > > 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. > > You can always use INSERT for the "content" table and REPLACE for the > "author" table. I don't think that would work as it will change the AuthId and effect any other 'tips' I've written. Each author should have one entry in 'author' and as many in 'content' as tips they have written. Am I talking rubbish? - -- Nick Wilson Tel: +45 3325 0688 Fax: +45 3325 0677 Web: www.explodingnet.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8YRkMHpvrrTa6L5oRAuIwAKCt3FSi5j7NYOAKvcUujYsKoDFJ3gCffbBS f/vX8OWqQGBa6EzVCdeDq8c= =fZBS -----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