On Wed, 2002-02-06 at 11:52, Nick Wilson wrote: > > 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?
No. You're right! Unless you generate your own AuthId (with date, not auto-incremented), i think you will have to do a SELECT in the "author" table to get his ID /you will need it to insert a new tip in the "content" table), and then you'll know if the author exists or not. Hope someone gives a better solution! -- 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
