-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
* and then Diana Soares declared.... > 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! No, I think you're right, Query the 'author' table first and eiter insert into both or just 'content' using the authors id. Cheers... - -- Nick Wilson Tel: +45 3325 0688 Fax: +45 3325 0677 Web: www.explodingnet.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8YSgqHpvrrTa6L5oRArpCAKCtiMCqjzvX/RzyYGHI47FdAU+bywCfVkuV T6+05Nf+cHGRDOtbJB77hfY= =g0fB -----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