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. -- Diana Soares (sql) --------------------------------------------------------------------- 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