See http://www.mysql.com/doc/en/INSERT.html Edward Dudlik Becoming Digital www.becomingdigital.com ----- Original Message ----- From: "Jake Malone" <jake@therussianjudge.com> To: <php-db@lists.php.net> Sent: Monday, 05 May, 2003 02:14 Subject: adding a new record is there some way to construct an INSERT query such that it only adds the record if certain values don't already exist in the table? (not unlike SELECT DISTINCT). or do i have to make a seperate SELECT statement to check before adding? thanks, -jake -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
