Why am I getting duplicate entries?

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 Post Reply

1147

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...

MySQL Database

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...

MySQL Database

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...

Microsoft Access / VBA

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...

Python

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 ...

Python

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...

General

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 |...

PHP

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...

C / C++

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...

Microsoft SQL Server

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...

PHP

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

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,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

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...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

Why am I getting duplicate entries?

Similar topics