Forum Moderators: coopster
if((all the variables pass verification)){
dbx_connect();//connect to database function
$duplicate="SELECT * From `table` Where var1 = 'var1eqv' AND ...
$dupe_result=mysql_query($duplicate) or die(mysql_error());
$dupe_rows = mysql_num_rows($dupe_result);
if (!$dupe_rows)
{
//insert non duplicate with status as 3
dbx_connect();
$sqlAR = "INSERT INTO table VALUES ('$null','etc',...)";
$resultAR = mysql_query($sqlAR);
}
else
//if duplicate put 99 as status
{
dbx_connect();
$sqlAR = "INSERT INTO table VALUES ('$null','etc',...)";
$resultAR = mysql_query($sqlAR);
}
<INPUT name="Submit" onclick="this.disabled=true;document.form2.submit();" type="submit" name="Submit" value="Finish">I turned on the disable function on one page yesterday and 3 today. I will monitor the pages all day today looking for these kinds of errors. I appreciate any advice y'all can give.