Entry

How can I restrict an INSERT if the two fields to be inserted exist?

Mar 12th, 2003 18:02
Alan, taylor gerring, Chris,

You must first perform a SELECT query to ensure that the fields don't 
exists.
-------------
Put something like this:
<?php
$result = mysql_query('SELECT blah FROM bleh WHERE blah LIKE "'.$_POST
["blah"].'"');
if (mysql_num_rows($result) == 1) {
	echo "Sorry! It already exists. Try again";
} else {
// The processing codes here
}
?>