problem with duplicate entry of data

[Mystical-16]

Duplicate entry of data is taking place on refreshing the page while updating the data.
please let me know the solution to this asap!

[Jprashant08]

Can you please elaborate, in what part you're getting error like in PHP or in specifically in Database?

[Jprashant08]

$query=mysql_query("SELECT * FROM emptype WHERE typename = '$emptype' AND typedesc='$typedesc') or die(mysql_error());

if (mysql_num_rows($query)<=0)
{
$query=mysql_query("insert into emptype(typename,typedesc)values('$emptype','$typedesc')")or die("<script>alert('Error');</script>");
/* See if it helps */

[bofa26]

has this been fixed'

[Jprashant08]

No

…

On Mon, 24 Apr, 2023, 8:37 pm bofa26, ***@***.***> wrote: has this been fixed' — Reply to this email directly, view it on GitHub <#4 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AWDDWKVPDU7EA6JLVHLDMETXC2JLHANCNFSM5LYP56VQ> . You are receiving this because you commented.Message ID: ***@***.***>

[rinae-del]

The best way is to refresh the page after updating the data. You can do this by first checking if data successfully updated then adding header('location: currentpage.php')