PHP - Duplicate Key In Array

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

I am inserting the two records below simultaneously (one after the other), but what I want to do write the second ONLY if the first isn't a duplicate. Help?

Code: [Select]
//FIRST INSERT
mysql_query("INSERT INTO spam (id, scm_mem_id) VALUES('', '$social_mem_id' ) ON DUPLICATE KEY UPDATE scm_mem_id=$social_mem_id") or die(mysql_error()); 

//SECOND INSERT
mysql_query("INSERT INTO sc_messages (smg_from, smg_to, smg_subject, smg_body, smg_sent_del, smg_postdate) VALUES ('$social_mem_id','1','$subject','$body','1','$time')") or die(mysql_error());

Hey guys!

I know, I know this problem is EVERYWHERE but i just dont understand! I have a solid knowlage of php but my SQL skills are low, so i dont know too much about Keys and stuff. But my error is: Duplicate entry '' for key 2.

The thing that im working on at this section is logging in with facebook. The code that presents my error is:

    $sql = "SELECT * FROM users WHERE uid=".$uid;
    $fbid = mysql_query($sql);
$num_rows = mysql_num_rows($fbid);

if(mysql_num_rows($fbid) < 1) {
echo "You are not logged in.    ";
mysql_query("INSERT INTO `users` (`uid`) VALUES ('".$uid."')")
or die(mysql_error());  

} else {
mysql_query("UPDATE users SET logged = '1' WHERE uid=".$uid);
//mysql_query("UPDATE users SET full_name = $me WHERE uid=".$uid);

echo "Your Logged in ";
echo $me['name'];
?> Continue to <a href="removed :)"> My Settings </a>. <?
}


Any help is welcome

Hi there, I know I'm doing something stupid, but i've tried for hours to try and figure this out and I just cant seem to figure out why tutorials i've seen seem to work yet my own code doesnt.
basically i've got two functions: getAll() and get($id) inside a class, calling getAll, returns an array with one of the same record as opposed to all the records (which is my intended result).  Can anyone help? thanks.

Code: [Select]
class Test{
        protected $_db;
        protected $_table = "table";
       
        protected $_friends = array();
       
        public function __construct($db) {
            $this->_db = $db;
        }
       
        public function getAll()
        {
            $db = $this->_db;
            $sql = "SELECT * FROM $this->_table";
            $db->query($sql);
            while($data = $db->fetch_array())
            {
                $this->_friends[$data['id']] = $this->get($data['id']);
            }
            return $this->_friends;
        }
       
        public function get($id)
        {
            $db = $this->_db;
            $sql = "SELECT * FROM $this->_table WHERE id='$id'";
            $db->query($sql);
            $data = $db->fetch_array();
           
            return (object)$data;
           
        }
}

$test = new Test(new mysqlConnClass());
$arrayOfAllAsObjects = $test->getAll();

hi, i have some code that i need to update existing columns in a table, but i just cant seem to get it to work if anyone caan please help it would be appreciated.

Quote

// select the database
mysql_select_db($database)
or die ("Could not select database because ".mysql_error());

$insert = mysql_query("insert into $table values ('NULL', '".$_POST['email']."', '".$_POST['password']."', '".$_POST['name']."', '".$_POST['Gender']."', '".$_POST['Age']."', '".$_POST['Race']."', '".$_POST['SpecialtyOne']."', '".$_POST['Feet']."', '".$_POST['Weight']."', '".$_POST['Eyes']."', '".$_POST['Hair']."', '".$_POST['Strength']."', '".$_POST['Stamina']."', '".$_POST['Perception']."', '".$_POST['Agility']."', '".$_POST['Intelligence']."', '".$_POST['Tech']."', '".$_POST['Luck']."', '".$_POST['Appearance']."', '".$_POST['Background']."', '".$_POST['Weapons']."', '".$_POST['Armour']."', '".$_POST['Items']."', '".$_POST['Enhancements']."', '".$_POST['Skills']."')")
or die("Could not insert data because ".mysql_error());

?>

<?php

Hi..

So im currently working on a script..
My script generates a "oid" based on timestamp.

Ive made the "oid" field unique in my db, so if i do a quick refresh i get the message:

Duplicate entry '1283195988' for key 'oid'

Is there some way i can check if its a dublicate, and if it is + it with 1 or something?

Code: [Select]
foreach ($items as $product ) {
echo $product;
?><input type="text" size="2" value="<?php  
\\display quantity here
  ?>" name="quantity" /><?php
}
$items is an array.  It has multiple values, some duplicate. How do i count the duplicate values in the array and display in this foreach loop?

i know array_count_values($product) but putting that in the foreach loop won't accomplish what i want.

another thing. i can get the foreach loop  to not display duplicates by doing this

Code: [Select]
foreach (array_unique($items) as $product ) {
echo $product;
?><input type="text" size="2" value="<?php  
\\display quantity here
  ?>" name="quantity" /><?php
}

how would i accomplish both.

basically i want it to display the quantity without displaying duplicate rows.  aka shopping cart.

Hey folks,

Sorry for being a pain in the ass.

I am trying to submit data to my database via a form and when I click Submit, I get:

Duplicate entry '' for key 1

I understand that it means I have a duplicate entry with the ID of 1 or something like that. I can't find where the issue is.

Here is the form:


<form actin="" id="settings" name="settings">
                    <table class="listing form" cellpadding="0" cellspacing="0">
                        <tr>
                            <th class="full" colspan="2"><?php echo $lang_settings; ?></th>
                        </tr>
                        <tr>
                            <th colspan="2"><?php echo $lang_settings_description; ?></th>
                        </tr>
                        <tr>
                           <td><?php echo $lang_sitename; ?>: </td> <td><input type="text" name="sitename" value="<?php echo $site_name; ?>" width="172" /> <em>Site name for logo</em></td>
                        </tr>
                        <tr>
                           <td><?php echo $lang_email; ?>: </td> <td><input type="text" name="email" value="<?php echo $site_email; ?>" width="172" /> <em>Your email address</em></td>
                        </tr>
                        <tr>
                           <td><?php echo $lang_yourname; ?>: </td> <td><input type="text" name="name" value="<?php echo $your_name; ?>" width="172" /> <em>Your own name</em></td>
                        </tr>
                        <tr>
                           <td><?php echo $lang_meta_description; ?>: </td> <td><input type="text" name="meta-description" value="<?php echo $description; ?>" width="172" /> <em>SEO</em></td>
                        </tr>
                        <tr>
                           <td><?php echo $lang_keywords; ?>: </td> <td><input type="text" name="meta-keywords" value="<?php echo $keywords; ?>" width="172" /> <em>Separate with Commas</em></td>
                        </tr>
                       <tr>
                       <td><input type="submit" class="button" name="submit" value="<?php echo $lang_button_savesettings; ?>"></td>
                       </tr>
                    </table>
</form>


Here is the Insert code:

$insert = "INSERT INTO settings (site_name, description, keywords, email, name) 
VALUES ('$sitename', '$meta_description', '$meta_keywords', '$site_email', '$your_name')"; 
mysql_query($insert) or die(mysql_error());


Can anyone please tell me where I am going wrong here?

Much appreciated.

Hey guys just wondering if this piece of code is correct because i get a mysql error saying Duplicate entry '*********' for key 2 this is the code i have and table structure.

$sql = " INSERT INTO `IP_Address`
         VALUES(NULL,'".$ip."','".$date."','".$time."')
         ON DUPLICATE KEY UPDATE `date` =  `".$date."`, `time` = `".$time."`

";

I am quite new so I am sure this is an easy fix for some of the experts around here.

I am using the canned script below to add urls to the database as text.  The problem is if you update one of the form text boxes it loads all the urls into the database again resulting in a lot of duplicates.

My question is, How do I get the form to only post the new changes and not re-post the existing urls?


<?php
session_start();

   if(isset($_SESSION['userSession']) && !empty($_SESSION['userSession']))
   {
        include_once("dbc.php");

        if($_POST)
        {
            $c = 0;
            
            $errMssg = "";

            for($i=0;$i<count($_POST['url']);$i++)
            {
                if($_POST['url'][$i]=="")
                {
                    $c++;
                }
            }
            if($c==5)
            {
                $errMssg = "Submission error . Please fill at least 1 url.";
            }
            else
            {
                for($j=0;$j<count($_POST['url']);$j++)
                {
                    if(!empty($_POST['url'][$j]))
                    {
                        $sql = mysql_query("INSERT INTO images (id ,url ,user_id)VALUES (NULL , '".$_POST['url'][$j]."',".$_SESSION['userId'].")");    

                     }
                                    
                }
                
            }
        }    

        
        

        $sqlresult = mysql_query("SELECT * FROM images WHERE user_id =".$_SESSION['userId']);
        
        $count = 0;
            
        while($data = mysql_fetch_array($sqlresult))
        {
            $image[$count] = $data['url'];

            $count++;

        }
         
?>

Hello everyone.

I'd like to know how to duplicate a product through a php back-office.

That product consists of an ID in the "products" table of my DB. Then we have another table called "sub_products" that links its sub-products through a column named "product_id".

So I have product with ID "1000", and sub-products associated with it on another table with ID's "2021", "2022", "2023".

What's the routine I can use to duplicate both the product and its sub-products? I need to duplicate them because they fit 2 categories so I'm changing the category column during this duplicate.

Could really use some help. Thank you in advance! 

Hi, I got this script which checks a username does not exist, before writing the users registration info to the database. It was working fine, but now for some reason says there is a duplicate username in the database, when there isnt

Code: [Select]
<?php


$password1 = $_POST['password1'];
$password2 = $_POST['password2'];

if ($password1 != $password2) {

echo "Your passwords did not match, please go back and register again";

} else {

// Check Passwords Match


// Get Posted Variables

$username = $_POST['username'];
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$address = $_POST['address'];
$town = $_POST['town'];
$county = $_POST['county'];
$postcode = $_POST['postcode'];
$email = $_POST['email'];
$approved = "no";

// MySQL Connection

include_once("data/mysql.php");

$mysqlPassword = (base64_decode($mysqlpword));

$con = mysql_connect("$localhost", "$mysqlusername", "$mysqlPassword") or die(mysql_error());
mysql_select_db("$dbname", $con) or die(mysql_error());


$query = "SELECT COUNT(*) AS count FROM members WHERE username='$username'";
$results = mysql_query($query) or die ("Error reading from database");
$existingUsername = mysql_fetch_array($results);
 
if ($existingUsername['count'] > 0) {
echo "I'm sorry our database already contains that username please choose a new username to continue.";
} else {
    

$sql = "INSERT INTO members (username, firstname, lastname, address, town, county, postcode, email, password, approved)
VALUES
('$_POST[username]','$_POST[firstname]','$_POST[lastname]','$_POST[address]','$_POST[town]','$_POST[county]','$_POST[postcode]','$_POST[email]','$_POST[password2]','$approved')";

mysql_query($sql,$con);

?>

<meta http-equiv="REFRESH" content="5;url=../login.html">

<?php

}

mysql_close($con);
}
?>
Im sure it is something simple, I just cant see what it is.

As always, any help is much appreciated

Hi everyone, I need a little bit of help finishing off my code. Ive managed to get this far.

Code: [Select]
<?php
mysql_connect("") or die ("Not Connected to MYSQL");
echo "</br>";
mysql_select_db("") or die ("Not Connected to DB");
// Database Connection stuff

$partialNumber = $_POST['partialNumber']; // Post the Partial number
$partialNumber = strtoupper($partialNumber);
$numberSearch = mysql_query("SELECT * FROM product_option_value_description WHERE name LIKE '%$partialNumber%'") or die (mysql_error()); // Query to select the key number

//Query to get product ID //

$productId = "SELECT product_id FROM product_option_value_description";

//Query to get product ID //

while ($keyNumber = mysql_fetch_array($numberSearch)) {
$id = $keyNumber['product_id'];
// Query for the images // 
$query = "SELECT image FROM product WHERE product_id = '$id'";
$result = mysql_query($query);
$row = mysql_fetch_array($result) or die(mysql_error());

$query2 = "SELECT product_option_id FROM product_option_value WHERE product_id = '$id'";
$result2 = mysql_query($query2);
$row2 = mysql_fetch_array($result2) or die(mysql_error());

$query3 = "SELECT product_option_value_id FROM product_option_value WHERE product_id = '$id'";
$result3 = mysql_query($query3);
$row3 = mysql_fetch_array($result3) or die(mysql_error());
?>
    <div>
   
    <br /><br />
    Key Number: <? echo $keyNumber['name']; ?></a>
   
    <form action="http://www.co.uk/teststore/index.php?route=checkout/cart" method="post" enctype="multipart/form-data" id="product">
<br />
<table style="width: 100%;">
<tr>
<td>
Colour:
<select name="option[<? echo $row2['product_option_id']; ?>]">
<option value="<? echo $row3['product_option_value_id']; ?>"></option>
</select></td>
</tr>
</table>
<div class="content"> Qty: <input type="text" name="quantity" size="3" value="1" />
    <input type="hidden" name="product_id" value="<? echo $id; ?>" />
    <input name="submit" type="submit" value="Add to Cart" />

</div>
</form>
<? echo $row3['product_option_value_id']; ?>
</div>
<br />
<img height="150" width="150" src='http://www.co.uk/teststore/image/<? echo $row['0']; ?>'/>
<? }
 ?>

And here is my SQL Table code.

Code: [Select]
product_option_value_id product_option_id product_id
599                302                49
598                302                49
589                297                42
588                297                42

So as you can probably tell, it is a search program that looks for products on a shopping cart. The products will have different option values, and the php script will grab the option values and echo them in a form to post back to the cart to add the product to the basket.

The problem is that the "product_option_value_id" can have lots of different values, but my code echos only the first one it finds. So when I click the add to cart button, it will only add the first option value for the product it finds.

For some reason I am having a hard time explaining this, so I hope someone can help me.

Thanks for looking.

Hi Friends !

I need to discuss a problem with you.
When we fill a customer info form, and redirect to other page. but go back by browser's back button and resubmit the form.
In this case duplicate data is inserted. Or when we refresh a page multiple data is inserted, so HOW TO AVOID this terrible problem ?

Hi! I have a question about Enthusuast 3. Is there any way to allow forms with duplicate emails? Right now the form gives an error when trying to sent it with an email that's already in the database. I want to change this so that multiple entried with the same email are allowed on the same table. Thank you.