check if there

[Dillenger]

Hi I'm trying to input data into a database, which works fine, but I'm trying to get it to check if the nprojectID and date values are already input, and if they are, I don't want a duplicate record, so I want it to not input the data.

//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
		if (isset($updated_tender_calls)){

	$SQL2 = " UPDATE project_master SET ";
	$SQL2 = $SQL2 . " newproject = '', ";
	$SQL2 = $SQL2 . " updatedtender = 'YES' ";
	$SQL2 = $SQL2 . " WHERE project_address = '$project_address' ";
	$result2 = mysql_db_query($db,"$SQL2",$connect);


	$sql = "select nprojectID from project_master WHERE project_address= '$project_address'";
	$result = mysql_query($sql);
	$owners = mysql_fetch_array($result);

	$nprojectID=$owners['nprojectID'];


	$insertproject = "INSERT INTO updatedtender_data (nprojectID, date) VALUES('$nprojectID', '$updissue_date' ) ";
	$updatedInsert = mysql_query($insertproject, $connect);

	}else{
	$SQL2 = " UPDATE project_master SET ";
	$SQL2 = $SQL2 . " updatedtender = '' ";
	$SQL2 = $SQL2 . " WHERE project_address = '$project_address' ";
	$result2 = mysql_db_query($db,"$SQL2",$connect);
	}
	//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

[chads2k2]

Well what's the problem bud? Is it duplicating records, do you have errors, are the ID's not coming/going right?

A trick is to echo your SQL statements and see if everything is coming out right. That is a troubleshooting technique I use when in a jam.

Let me know how that works out for ya,

Chad