Why am I getting duplicate entries?

1 New Member

This is blowing my mind. I've got a system where sales reps can write notes on contacts in the DB. The issue is, I'm getting duplicate notes, but they're happening at different times. Each note is time stamped, and the duplicates are happening sometimes 3 or 4 hours later, after the user is no longer on the site. I'm totally stumped with this. So here are the 2 pages that are used in the site.

The first one is the index page, every page gets loaded within it.

Expand|Select|Wrap|Line Numbers

  
<?

session_start();

include('includes/db.inc.php');
 
if (isset($_SESSION['mycontent']))

{

    $username = $_SESSION['mycontent'];

    $query = "SELECT * FROM users WHERE username = \"$username\"";

    $result = mysql_query($query) or die('Sorry, could not get cookie at this time ');    

    $row = mysql_fetch_array($result, MYSQL_ASSOC);

    $username = $row['username'];

    $fname = $row['fname'];

    $lname = $row['lname'];

    $admin = $row['admin'];

    $userid = $row['userid'];

    $userID = $userid;

    $fullName = "$fname $lname";

        } else { die ( "<h2>You must be logged in to view this content. </h2><br>
 
                 <form action=\"validate.php\" method=\"post\" >

User Name:

<input name=\"username\" type=\"text\" class=\"search_box\" size=\"20\" id=\"username\">

Password:<input name=\"password\" type=\"password\" class=\"search_box\" size=\"20\"> 

<input type=\"submit\" class=\"search_box\" value=\"Login\">

</form>
 
                 \n");

}
 
?>
 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<title></title>

<link href="cc.css" rel="stylesheet" type="text/css" />
 
<script language = "javascript" type = "text/javascript">

    <!-- Start hiding JavaScript statements
 
      var Request = false; 

      if (window.XMLHttpRequest) {

        Request = new XMLHttpRequest();

      } else if (window.ActiveXObject) {

        Request = new ActiveXObject("Microsoft.XMLHTTP");

      }
 
      function checkingAlerts() {

    checkAlerts()

    setInterval("checkAlerts()",15000);
 
    }
 
      function checkAlerts() {
 
        var url = "alertsCheck.php?userid=" + <? echo $userID; ?>;
 
        if(Request) {

          var target2 = document.getElementById('alerts'); 

          Request.open("GET", url, true); 

          Request.onreadystatechange = function() { 

            if (Request.readyState == 4 && Request.status == 200) { 

                target2.innerHTML = Request.responseText; 
 
            } 

          } 

          Request.send(null); 

        }

}
 
function startup(){

checkingAlerts();

checkingStatus()

}

</script>
 
</head>

<body onLoad="startup()">
 
<table width="100%" border="0" cellspacing="0" cellpadding="0">

  <tr>

    <td align="right" class="usermenu" bgcolor="#2E3E57"><? include('userMenu.php'); ?></td>

  </tr>

  <tr>

    <td align="left" class="menu_content"><h1>myCommand Center v0.0.5</h1></td>

  </tr>

  <tr>

    <td><ol>

      <li><a href="index.php?content=contacts/view-all.php">Contacts</a>

      </li>

      <li><a href="index.php?content=clients/view-all.php">Clients</a></li>

      <li><a href="#">Schedule</a></li>

      <li><a href="#">Resources</a></li>

      <li><a href="#">Reports</a></li>

      <li><a href="#">Compensation &amp; Incentives</a></li>

    </ol>    </td>

  </tr>

  <tr>

    <td><?

$contactID = $_GET['contactID'];
 
?><script language = "javascript" type = "text/javascript">

    <!-- Start hiding JavaScript statements
 
      var Request = false; 

      if (window.XMLHttpRequest) {

        Request = new XMLHttpRequest();

      } else if (window.ActiveXObject) {

        Request = new ActiveXObject("Microsoft.XMLHTTP");

      }
 
      function checkStatus(target) {

                  var userid = "<? echo $userid; ?>";
 
        var url = "status.php?contactID=" + <? echo $contactID; ?> + "&userid=" + userid;
 
        if(Request) {

          var target2 = document.getElementById(target); 

          Request.open("GET", url, true); 

          Request.onreadystatechange = function() { 

            if (Request.readyState == 4 && Request.status == 200) { 

                target2.innerHTML = Request.responseText; 
 
            } 

          } 

          Request.send(null); 

        }

}
 
    function checkingStatus() {

    checkStatus('status')

    setInterval("checkStatus('status')",15000);
 
    }
 
    function newNote(belongsTo) {

        var note = document.getElementById('note').value;

        var rep = "<? echo $fullName; ?>"

        var repID = "<? echo $userID; ?>"

        var belongsTo = belongsTo

        var url = "addNote.php?contactID=" + <? echo $contactID; ?>+ "&rep=" + rep + "&repID=" + repID + "&belongsTo=" + belongsTo + "&note=" + note;
 
        if(Request) {

          var target2 = document.getElementById('notesBox'); 

          Request.open("GET", url, true); 

          Request.onreadystatechange = function() { 

            if (Request.readyState == 4 && Request.status == 200) { 

                target2.innerHTML = Request.responseText; 
 
            } 

          } 

          Request.send(null); 

        }
 
    }
 
    function claimContact() {

        var rep = "<? echo $userid; ?>"

        var url = "claimContact.php?contactID=" + <? echo $contactID; ?>+ "&rep=" + rep;
 
        if(Request) {

          var target2 = document.getElementById('status'); 

          Request.open("GET", url, true); 

          Request.onreadystatechange = function() { 

            if (Request.readyState == 4 && Request.status == 200) { 

                target2.innerHTML = Request.responseText;

                checkStatus('status');

            } 

          } 

          Request.send(null); 

        }
 
    }

    function makeClient() {
 
        var url = "makeClient.php?contactID=" + <? echo $contactID; ?>;
 
        if(Request) {

          var target2 = document.getElementById('status'); 

          Request.open("GET", url, true); 

          Request.onreadystatechange = function() { 

            if (Request.readyState == 4 && Request.status == 200) { 

                target2.innerHTML = Request.responseText;

                checkStatus('status');

            } 

          } 

          Request.send(null); 

        }
 
    }

    function makeContact() {
 
        var url = "makeContact.php?contactID=" + <? echo $contactID; ?>;
 
        if(Request) {

          var target2 = document.getElementById('status'); 

          Request.open("GET", url, true); 

          Request.onreadystatechange = function() { 

            if (Request.readyState == 4 && Request.status == 200) { 

                target2.innerHTML = Request.responseText;

                checkStatus('status');

            } 

          } 

          Request.send(null); 

        }
 
    }
 
    function unclaimContact() {

        var rep = "<? echo $userid; ?>"

        var url = "unclaimContact.php?contactID=" + <? echo $contactID; ?>+ "&rep=" + rep;
 
        if(Request) {

          var target2 = document.getElementById('status'); 

          Request.open("GET", url, true); 

          Request.onreadystatechange = function() { 

            if (Request.readyState == 4 && Request.status == 200) { 

                target2.innerHTML = Request.responseText;

                checkStatus('status');

            } 

          } 

          Request.send(null); 

        }
 
    }
 
    function deleteNote(noteID, belongsTo) {

        var belongsTo = belongsTo
 
        var url = "deleteNote.php?contactID=" + <? echo $contactID; ?> + "&belongsTo=" + belongsTo + "&noteID=" + noteID;
 
        if(Request) {

          var target2 = document.getElementById('notesBox'); 

          Request.open("GET", url, true); 

          Request.onreadystatechange = function() { 

            if (Request.readyState == 4 && Request.status == 200) { 

                target2.innerHTML = Request.responseText;
 
            } 

          } 

          Request.send(null); 

        }
 
    }
 
    // End hiding JavaScript statements -->
 
    </script>
 
    <link href="../cc.css" rel="stylesheet" type="text/css">
 
  <?
 
          $query = "SELECT * from contacts WHERE contactID = $contactID";

        $result = mysql_query($query) or die('Sorry, could not get entires at this time ');
 
echo "<div class=\"subMenu\" align=\"left\">";

echo "<a href=\"index.php?content=contacts/view-all.php\">all contacts</a> | <a href=\"index.php?content=contacts/view-mine.php\">my contacts</a> | <a href=\"index.php?content=contacts/view-claimed.php\">all claimed</a> | <a href=\"index.php?content=contacts/view-unclaimed.php\">unclaimed</a> | <a href=\"index.php?content=contacts/view-blacklisted.php\">blacklisted</a>";

echo "</div>";
 
echo "<div id=\"borderPad\" align=\"left\">";

$row=mysql_fetch_array($result, MYSQL_ASSOC);
 
       $contactID = $row['contactID'];

       $repID = $row['repID'];

       $phone= $row['phone'];

       $busName = $row['busName'];

       $fname = $row['fname'];

       $lname = $row['lname'];

       $status = $row['status'];

       $email = $row['email'];

       $address = $row['address'];

       $city = $row['city'];

          $state = $row['state'];

          $title = $row['title'];

          $zip = $row['zip'];

          $website = $row['website'];

          $industry = $row['industry'];

        $belongsTo = $repID;

// Contact Status

if ($status == 0){

    $statusMsg = "Has not been contacted (<span onClick=\"claimContact()\" style=\"cursor:pointer;\">claim</span>)";

} elseif ($status == 1){

    $statusMsg = "Contact is not interested.  <u>DO NOT CONTACT</u>";

} elseif ($status == 2){

    $statusMsg = "Contact has been assigned to another rep";

} else {

    $statusMsg = "Contact is a client";

}
 
if ($title){

    $ifTitle = $title; 

} else {

    $ifTitle = '';

}
 
$fullAddress = 0;
 
if (!$address){

    $fullAddress = 1;

}
 
if (!$city){

    $fullAddress = 1;

}
 
if (!$state){

    $fullAddress = 1;

}
 
if (!$zip){

    $fullAddress = 1;

}
 
$proAddress = str_replace (' ', '+', $address);

$proCity = str_replace (' ', '+', $city);
 
echo "<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">";

echo "<tr>";

echo "<td>";
 
// Left column

echo "<h2>$busName</h2>";

echo "Industry: $industry<br><br><strong>Contact Info</strong><br>Contact: $fname $lname $ifTitle<br>Phone: $phone <br> Email: $email (compose email)<br>Website: $website<br><br>";

echo "<strong>Address</strong><br>$address <br>$city, $state $zip"; 
 
if ($fullAddress == 0) {

echo "(<a href=\"http://maps.google.com/maps?f=q&source=s_q&hl=en&geocode=&q=$proAddress+$proCity+$state+$zip\" target=\"blank\">get directions</a>)";

}
 
echo "</td>";
 
// Right Column

echo "<td valign=\"top\" align=\"right\">"; 
 
?><div id="status"></div>

<? 
 
echo "</td>";

echo "</tr>";

echo "</table>";

echo "</div>";
 
?>

<div id="notesBox">

<?       
 
          $query2 = "SELECT noteID, contactID, salesRep, DATE_FORMAT( noteDate, '%c/%e/%Y @ %l:%i %p'), note FROM notes WHERE contactID = $contactID ORDER BY noteDate ASC";

        $result2 = mysql_query($query2) or die('Sorry, could not get entires at this time ');

        while($row2=mysql_fetch_array($result2, MYSQL_ASSOC))

   {

       $noteID = $row2['noteID'];

       $contactID = $row2['contactID'];

       $salesRep = $row2['salesRep'];

       $noteDate = $row2["DATE_FORMAT( noteDate, '%c/%e/%Y @ %l:%i %p')"];

       $note = $row2['note'];

echo "<div class=\"notes\" align=\"left\">";

echo "$noteDate - $salesRep <span onClick=\"deleteNote('$noteID','$belongsTo')\" style=\"cursor:pointer;\">[delete comment]</span><br>$note";

echo "</div>";

}

echo "<span class=\"cursor\" onClick=\"document.getElementById('noteForm').style.display=''\">add note</span>";

echo "<div id=\"noteForm\" style=\"display:none;\">

<label>

  <textarea name=\"note\" cols=\"65\" rows=\"8\" class=\"notes\" id=\"note\"></textarea>

</label>

    <label><br>

    </label>

    <label>

      <input type=\"button\" name=\"button2\" id=\"button2\" value=\"Nevermind\" onClick=\"document.getElementById('noteForm').style.display='none'\">

    </label>

  <input type=\"button\" name=\"button\" id=\"button\" value=\"Submit\" onClick=\"newNote('$belongsTo')\">";
 
?>

</div>
 
</div>

    </td>

  </tr>

  <tr>

    <td><? include('../includes/footer.inc.php'); ?></td>

  </tr>

</table>

</body>

</html>

Then is the PHP script that adds the comment, then adds an alert to all users who have commented on that contact...

Expand|Select|Wrap|Line Numbers

 
<?

$con = // server connection info ;
 
$contactID = $_GET['contactID'];

$newNote = $_GET['note'];

$salesRep = $_GET['rep'];

$repID = $_GET['repID'];

$belongsTo = $_GET['belongsTo'];

// Add new comment

$query = "INSERT INTO notes (`noteID`,`contactID`,`salesRep`,`noteDate`,`note`, `salesRepID`)VALUES (NULL ,  '$contactID',  '$salesRep', NOW( ) ,  '$newNote', '$repID')";

$result = mysql_query($query) or die('Our note system appears to be having issues.  One of the Matts probably broke it. Error 1');
 
$query1 = "INSERT INTO alertsNote (`alertID` ,`contactID` ,`toto` ,`from`) VALUES (NULL ,  '$contactID',  '$belongsTo',  '$salesRep')";

$result1 = mysql_query($query1) or die('Our note system appears to be having issues.  One of the Matts probably broke it.');
 
// All passed, show the new comments.
 
          $query2 = "SELECT noteID, contactID, salesRep, DATE_FORMAT( noteDate, '%c/%e/%Y @ %l:%i %p'), note FROM notes WHERE contactID = $contactID ORDER BY noteDate ASC";

        $result2 = mysql_query($query2) or die('Sorry, could not get entires at this time ');

        while($row2=mysql_fetch_array($result2, MYSQL_ASSOC))

   {

       $noteID = $row2['noteID'];

       $contactID = $row2['contactID'];

       $salesRep = $row2['salesRep'];

       $noteDate = $row2["DATE_FORMAT( noteDate, '%c/%e/%Y @ %l:%i %p')"];

       $note = $row2['note'];

?>

<?       

echo "<div class=\"notes\" align=\"left\">";

echo "$noteDate - $salesRep <span onClick=\"deleteNote($noteID, $belongsTo)\" style=\"cursor:pointer;\">[delete comment]</span><br>$note";

echo "</div>";

}

echo "<span class=\"cursor\" onClick=\"document.getElementById('noteForm').style.display=''\">add note</span>";

echo "<div id=\"noteForm\" style=\"display:none;\">

<label>

  <textarea name=\"note\" cols=\"45\" rows=\"5\" class=\"notes\" id=\"note\"></textarea>

</label>

    <label><br>

    </label>

    <label>

      <input type=\"button\" name=\"button2\" id=\"button2\" value=\"Nevermind\" onClick=\"document.getElementById('noteForm').style.display='none'\">

    </label>

  <input type=\"button\" name=\"button\" id=\"button\" value=\"Submit\" onClick=\"newNote('$belongsTo')\">";
 
          $query2 = "SELECT DISTINCT salesRepID FROM notes WHERE contactID = $contactID";

        $result2 = mysql_query($query2) or die('Sorry, could not get entires at this time ');

        while($row2=mysql_fetch_array($result2, MYSQL_ASSOC))

   {

       $salesRepID = $row2['salesRepID'];
 
       echo $userID;

       echo "<br>";

       echo $salesRepID;

       if($salesRepID == $belongsTo){} else {
 
$query1 = "INSERT INTO alertsNote (`alertID` ,`contactID` ,`toto` ,`from`) VALUES (NULL ,  '$contactID',  '$salesRepID',  '$salesRep')";

$result1 = mysql_query($query1) or die('Our note system appears to be having issues.  One of the Matts probably broke it.');

       }
 
   }
 
?>

It's a lot of code, so if you need something cleared up, let me know.

Thanks!

Apr 28 '11 #1

Subscribe Reply

1163

Similar topics

838

v4 error on insert with duplicate entries

by: Gary Lundquest | last post by:

It appears to me that MySQL version 4 returns an error messge when doing an Insert that results in duplicate entries. Version 3 did NOT return an error - it dropped the duplicate entries and ran to completion. Version 4 seems to STOP when it encounters a duplicate entry, so that the records before the duplicate are inserted and the records after the duplicate are not inserted. 3.22.27.1 - previous ver MySQL that did not return error...

MySQL Database

6939

Best way for finding duplicate entries in table?

by: andreas.maurer1971 | last post by:

Hi all, since a few years I use the following statement to find duplicate entries in a table: SELECT t1.id, t2.id,... FROM table AS t1 INNER JOIN table AS t2 ON t1.field = t2.field WHERE t1.id < t2.id

MySQL Database

1668

Over the years, I've used query wizard to list duplicate entries...

by: MLH | last post by:

I never quite figured out how to reconfigure it to automatically delete redundant entries. Of course, one cannot always blatantly blow redundant records away w/o regard to which one it is that you wish to keep. But, sometimes you can. Anybody developed anything like this? (used powrmail tblEFaganReps) ==> ignore personal alzheimer note

Microsoft Access / VBA

4388

Removing Duplicate entries in a file...

by: sri2097 | last post by:

Hi all, I'm storing number of dictionary values into a file using the 'cPickle' module and then am retrieving it. The following is the code for it - # Code for storing the values in the file import cPickle book = {raw_input("Name: "): } file_object = file(database, 'w+') cPickle.dump(book, file_object)

Python

2223

Duplicate entries in a matrix

by: Chris Lasher | last post by:

Hello Pythonistas! I'm looking for a way to duplicate entries in a symmetrical matrix that's composed of genetic distances. For example, suppose I have a matrix like the following: A B C A 0.000000 0.500000 1.000000 B 0.500000 0.000000 0.500000 C 1.000000 0.500000 0.000000

Python

1885

NO duplicate entries

by: calebm12 | last post by:

Quick Question. I gotta a database with fields firstname, lastname, and hobby, etc. I dont want to allow duplicate entries for the name. For instance....no john smith twice....but there can be a repeated john. Well i created a multi-field index and that is fine....the problem is that my form is very long....there is lots of data to enter and the user could very well end up adding all this data then going to close it and find out it wont work. I...

General

3993

Deleting duplicate entries from MySQL database table

by: Manish | last post by:

The topic is related to MySQL database. Suppose a table "address" contains the following records ------------------------------------------------------- | name | address | phone | ------------------------------------------------------- | mr x | 8th lane | 124364 | | mr x | 6th lane | 435783 | | mrs x | 6th lane | 435783 |

PHP

20806

removing duplicate entries in an array

by: joestevens232 | last post by:

Hello Im having problems figuring out how to remove the duplicate entries in an array...Write a program that accepts a sequence of integers (some of which may repeat) as input into an array. Write a function that processes the array so that any duplicate values are eliminated. Write an output function that prints out the values of the array. You can assume that there are no more than 20 integers in the input. But there may be less. Zero...

C / C++

2936

rupdating duplicate entries with random numbers

by: php_mysql_beginer911 | last post by:

Hi .. i am trying to update a table where if field contents any duplictaed entries than one of the field should be updated with random number which is unique so i can make all entries unique i searched a lot but couldn't find any solution which i could understand easily . is it very difficult in sql to update duplicate entries with new unique random values? table example ----------------------

Microsoft SQL Server

1777

Restrict Duplicate entries

by: niths | last post by:

hi all, i had a users page in which the Admin can add users.so while adding a user i am able to restrict the duplicate entries(same names).Those users will be displayed in a table, and there is a edit button, so Admin can edit users account(like active,inactive etc). here is my problem when i click on edit button a pop up wil open and i didnt change any thing and click update button, as i didnt change anything it should update but i am getting...

PHP

9645

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9481

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10095

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8978

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6741

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5383

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5513

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4054

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3655

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP