-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
* and then DL Neil declared.... > > > > > > > > > > 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. > > > Starting with the author: either the author already exists in the > table (SELECT=successful), in which case his/her AuthId needs to be > ascertained and fed to 'part two'; or the author's details are not 'on > file' and therefore must be INSERTed (and the AuthId noted...'part > two'). > > Once the AuthId is known, 'part two' can take place, and the tip > written to the content tbl. > > Thus two tasks: (1) deal with the author 'issue', and (2) save the > tip. Fantastic, thanks for taking time out to help me, very much appreciated and you're right of course. - -- Nick Wilson Tel: +45 3325 0688 Fax: +45 3325 0677 Web: www.explodingnet.com -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE8YVKSHpvrrTa6L5oRAowcAKCwDeTodQtamgUfuxXVpYtiJi4FQACghP9w Bl/cpWlrX0jVLET3HH+DHEM= =2z22 -----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
