Duplicate records

mparab

I have a page that is used to edit records. Upon editing it should update or insert and delete the records. Unfortunately I am getting two identical records returned.

Any ideas????

Here's My Code:
FUNCTION CALLS:

<html>
<head>
<title>Edit Timesheet</title>
</head>
<body>
<?php
if ($POST["update"])
{
update($POST);
}
else {
verify();
}
?>
</body>
</html>

/ Verify just populates a form for editing. /

$result = mysql_query($sql)or die(mysql_error());
$res = mysql_query($select)or die(mysql_error());
unset($result);
unset($res);

mysql_close();
}

Thanks in advance.

nemonoman

I've taken the liberty of adusting your code so I could understand it better.

the problem is that you have 2 if /else statements that test a single condition.

up[status]==Normal will execute either the true condition of test a AND the false condition of test b, or the false condition of test a AND the true condition of test b.

If you reduce your code logically, you get:

if($up[status]=='Normal')
{
mysql_query("UPDATE time_work
WHERE id='$up[id]'",$db);
$sql = "INSERT INTO time_work";
$select = "DELETE FROM time_off WHERE id='$up[id]'";
}
else
{mysql_query("UPDATE time_off
WHERE id='$up[id]'",$db);
$sql = "INSERT INTO time_off ";
$select = "DELETE FROM time_work WHERE id='$up[id]'";
}

In other words, you always do an update AND an insert regardless of the state of $up['status'], thus resulting in duplicate records.