PHP - Moved: Ignore Duplicate Records

hello every body... two I'm creating an IPN in paypal for my membership site but the problem I'm facing is that on successfull verification of the purchase, four rows are getting inserted in the database...   The code is

<?php   
    require '../db.php';
    $paypalmode     =   '.sandbox';        
    $req = 'cmd=' . urlencode('_notify-validate');
    foreach ($_POST as $key => $value) {
        $value = urlencode(stripslashes($value));
        $req .= "&$key=$value";
    }
    $ch = curl_init();
    curl_setopt($ch, CURLOPT_URL, 'https://www'.$paypalmode.'.paypal.com/cgi-bin/webscr');
    curl_setopt($ch, CURLOPT_HEADER, 0);
    curl_setopt($ch, CURLOPT_POST, 1);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER,1);
    curl_setopt($ch, CURLOPT_POSTFIELDS, $req);
    curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 1);
    curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 2);
    curl_setopt($ch, CURLOPT_HTTPHEADER, array('Host: www'.$paypalmode.'.paypal.com'));
    $res = curl_exec($ch);
    curl_close($ch);

    if (strcmp ($res, "VERIFIED") == 0)
    {
        $transaction_id = $_POST['txn_id'];
        $payerid = $_POST['payer_id'];
        $firstname = $_POST['first_name'];
        $lastname = $_POST['last_name'];
        $payeremail = $_POST['payer_email'];
        $paymentdate = $_POST['payment_date'];
        $paymentstatus = $_POST['payment_status'];
        $mdate= date('Y-m-d h:i:s',strtotime($paymentdate));
        $otherstuff = json_encode($_POST);
        $date = date("y-m-d");
        
            $q = $pdo->connect()->query("INSERT INTO payment (mid,username,amount,paypal_id,txn_id,received_date)   VALUES('{$_SESSION['user_id']}','{$_SESSION['uname']}','{$_POST['mc_gross']}','{$_POST['payer_email']}','{$_POST['txn_id']}','$date')");
            $q->execute();
            $q1 = $pdo->connect()->query("UPDATE members SET amount_loaded = amount_loaded + {$_SESSION['amount']} WHERE mid = '{$_SESSION['user_id']}'");
            $q1->execute();
            //header("Location: funds.php");
            echo "verified";
        
        
}



?>

two for the payment and in the members table, the amount is getting doubled. (i.e if anybody purchases For $2, it shows $4 in the database....)   Any help will be really appreciated...

hello ..

I have 3 tables: student - infractions - Actions and view1 it Includes all tables and i make view1 source my page.

my database structu

Table: student
Columns:
ID_student int(11) AI PK 
name varchar(45) 
Age varchar(45) 
Grade varchar(45)

Table: infractions
Columns:
ID_infractions int(11) AI PK 
infractions_text varchar(45) 
ID_student int(11)


Table: actions
Columns:
ID_Actions int(11) AI PK 
Actions_text varchar(45) 
ID_student int(11)

view1
SELECT student.ID_student AS ID_student,
student.name AS name,
student.Age AS Age,
student.Grade AS Grade,
infractions.ID_infractions AS ID_infractions,
infractions.infractions_text AS infractions_text,
actions.ID_Actions AS ID_Actions,
actions.Actions_text AS Actions_text
FROM (student
JOIN infractions ON student.ID_student = infractions.ID_student)
JOIN actions ON student.ID_student = actions.ID_student

php page code:
  PHP Code:

[ Newbie Alert ]   
Hi

i have an array of 39 arrays. Only 5 are shown below so that you have an idea before i ask my question.

<?
array(39) 
{
 [0]=> array(3) { [0]=> string(18) "unit name 1" [1]=> string(9) "category name 1" [2]=> string(20) "Course 1" }

 [1]=> array(3) { [0]=> string(54) "unit name 2" [1]=> string(15) "category name 2" [2]=> string(20) "Course 1" }
 
[2]=> array(3) { [0]=> string(29) "unit name 3" [1]=> string(15) "category name 2" [2]=> string(20) "Course 1" } 

[3]=> array(3) { [0]=> string(64) "unit name 4" [1]=> string(30) "category name 3" [2]=> string(20) "Course 2" }

[4]=> array(3) { [0]=> string(57) "unit name 5" [1]=> string(24) "category name 1" [2]=> string(20) "Course 1" }

[5]=> array(3) { [0]=> string(50) "unit name 6" [1]=> string(24) "category name 4" [2]=> string(20) "Course 2" }
}


i want a php solution to print category names in table headers , unit names in table rows and course name(s) in table caption.I have tried foreach loop but how to remove duplicate entries as you can see category name 1 and 2 will become two separate headers instead of one and same is the case with Course 1 and 2.
i have googled but could'nt find any solution. i don't want to remove duplicate entries , all i want to display them once in a table as described above.

First of all excuse me if this topic is inappropriate in this forum. But I think it's rather a PHP problem.

I can't figure out multiple duplicate database records on submitting a form.

The database table have two columns:  the first one 'Id' with AUTO_INCREMENT and the second one 'Name'.

Here's the php code for database insertion and the form:
------------------------------------------------------------------

<?php

if($_GET['add_name']){
    $host = *******;
    $user = *******';
    $pass = *******;
    $db = *******;
    $con = mysql_connect($host,$user,$pass) or die;
    mysql_select_db($db,$con);
   
    $name = $_GET['add_name'];
    $sql = "INSERT INTO names (Name) VALUES ('$name')";
    mysql_query($sql);
}

?>

<form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="GET">
Your Name:
<input name="add_name" type="text"  />
<input type="submit" value="Submit" />
</form>

------------------------------------------------------------------

After submitting the form to itself once I have multiple Name entries with different Ids. The curious thing is that with Chrome browser
I get two duplicate records, with Mozilla - three of them.
Seems like mysql_query runs multiple times.

It works fine when submitting the form to a separate script and not to itself.

Do I miss something? It must be very basic.

I need Delete Duplicate Email Records That Are Attached To One Account But Can Be Found In Multiple Accounts

I have a table, consumer_mgmt.  It collects consumer information from various forms.  These forms are available through different pages that are part of a business package.

A business can offer these signups to gather names and emails from consumers for various types of specials they may offer.  So a consumer my be in the consumer_mgmt table 5, 10, 15 times for that particular business.

But, that consumer may be in the consumer_mgmt table multiple times for a different business.  So multiple times for multiple businesses.

I need to remove duplicates for each business account so the consumer is only the consumer_mgmt only once for each business.

There are approximately 15,000 rows currently in the consumer_mgmt table.   I'm not sure where to begin on the logic.  Since there are multiple business accounts that the emails are attached to, would one have to build a case for each loop?