RE: [PHP-DB] adding a new record

Sorry, Outlook XP reformats line breaks - very anoying... trying again: $SQLresult = Query the DB to see if record(s) exists If(!$SQLresult){ insert new data; }else{ echo "Data already exists in table."; } Gav -----Original Message----- From: Gavin Amm Sent: Tuesday, 6 May 2003 12:02 PM To: php-db@lists.php.net Subject: RE: [PHP-DB] adding a new record Hi Jake, Not sure what your table structure is like... $SQLresult = Query the DB to see if record(s) exists If(!$SQLresult){ insert new data; }else{ echo "Data already exists in table."; } Cheers, Gav -----Original Message----- From: Jake Malone [mailto:jake@therussianjudge.com] Sent: Monday, 5 May 2003 4:14 PM To: php-db@lists.php.net Subject: [PHP-DB] 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