Insert into but only if not existant.

[Marsha]

Heya, I am wondering how I would make the following form add to the database (like it does already), but only if both of the two values do not exist in the same column in the table. I have sensored the password and DB fields.

 

<?

$username=$_GET['UN'];

$postid=$_GET['PID'];

mysql_connect("###########", "###########", "###########") or die(mysql_error());

mysql_select_db("###########") or die(mysql_error());

mysql_query("INSERT INTO `data` VALUES ('$username', '$postid')");

Print "Your information has been successfully added to the database.";

?>

 

Thanks

[Maq]

You should do a SELECT first to check if the values exist.

[Marsha]

I am not familiar with select, could you maybe show me how I would add that to my code?

 

Thanks

[Maq]

I am not familiar with select, could you maybe show me how I would add that to my code?

 

No, but here are some helpful links with examples:

mysql_query

mysql_num_rows

[ttocskcaj]

For anyone who's interested;

mysql_connect($mysql_info);
$result=mysql_query("
    SELECT * FROM table_you_want_to_check 
    WHERE column_you_want_to_check = values_your_checking_for ");
$rows = mysql_num_rows($result);
//If less than one row exists, insert the new row.
if($rows<1){
    //insert query here
}

Good luck.