Mysql erroDuplicate entry '1' for key 'PRIMARY'

Question

0.00/5 (No votes)

See more:

getting error althogh there is no record in table
i need to insert clgid in couse and seat table bt i m gettig error on primary key .

PHP

$query="insert into clgmaster (ClgId,ClgName,ClgAddrs,FeeAmt,CntNo,Email,Pwd) values ($id,'$clgnm','$addrs',$fees,$cntno,'$eml','$pwd')";

    $result = mysql_query($query);//Excecuting clg query

    echo $result."<br>";

    echo "helllo query <br>";
    if ($result)
    {
        echo "<br>You Have Successfully REGISTERED this Record!";

    }

    $fetchData=mysql_query("select * from clgmaster");

    while($data=mysql_fetch_array($fetchData))
    {
        $id1= $data['ClgId'];
        echo $id1;

        //echo $data['ClgId'];
        echo "<br>";


    }

    //  **** inserting data into course table ****

    $query1="insert into course (ClgId,CourseName) values ($id1,$course)";
    echo $query1;

            $result1 = mysql_query($query1);//Executing course query
            echo $result1;

            if(!$result1)
            {
                die(" <br> Mysql erro".mysql_error());
            }
            else
                echo " <br> record inserted successfully in course";

Posted 22-Aug-15 23:48pm

Member 10011989

Updated 23-Aug-15 2:00am

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2015-08-23T00:30:00

Solution 1

Basically there are two options for primary key violaiton, either the record already exists or you call the insert twice (which is basically the same).

Based on your code, it looks like you fetch the value if Id after you have inserted a row into clgmaster. However the select does not restrict any rows so could it be possible that you actually fetch a random row from clgmaster and use that rows id when inserting into course. Since you have just inserted the row into clgmaster, is it necessary to fetch the row at all. Why not use the same value when inserting to course that was used when inserting into clgmaster.

Posted 23-Aug-15 0:30am

Wendelius

Comments

Member 10011989 23-Aug-15 6:51am

thanks Mr wendelius ,
i have tried it bt still i m getting same error. i had deleted all the record and execute the code bt still getting same error. i need to insert the same value of clgid into course table . plz suggest some idea. i m confused wht is going wrongwith my code, if u find any plz point me out

Wendelius 23-Aug-15 7:28am

While having a closer look it looks like you're executing the insert to clgmaster twice.

Instead of

$result1 = mysql_query($query);//Executing course query

try

$result1 = mysql_query($query1);//Executing course query

Also if the idea is to use common id for clgmaster and course, consider simplifying the code to

$query="insert into clgmaster (ClgId,ClgName,ClgAddrs,FeeAmt,CntNo,Email,Pwd) values ($id,'$clgnm','$addrs',$fees,$cntno,'$eml','$pwd')";

$result = mysql_query($query);//Excecuting clg query

echo $result." ";

echo "helllo query ";
if ($result)
{
echo " You Have Successfully REGISTERED this Record!";
}

// **** inserting data into course table ****
$query1="insert into course (ClgId,CourseName) values ($id,$course)";
echo $query1;

$result1 = mysql_query($query1);//Executing course query
echo $result1;

if(!$result1)
{
die(" Mysql erro".mysql_error());
}
else {
echo " record inserted successfully in course";
}

Member 10011989 23-Aug-15 8:02am

thhanks for pointing my silly mistake near $query1. bt same problem arises after the changes u suggest.
.when i modify my query by inserting manual clgid then i found strang error i.e. Unknown column 'BSc' in 'field list'.where BSc is name of my course name. :(

Wendelius 23-Aug-15 10:24am

Should the

$query1="insert into course (ClgId,CourseName) values ($id,$course)";

be

$query1="insert into course (ClgId,CourseName) values ($id,'$course')";

Member 10011989 23-Aug-15 11:09am

thanks but i have done it by myself..
thanks for your support..i am very gratefull to you

Wendelius 23-Aug-15 11:12am

Could you post the complete code and explain once again what problem you currently have.

Member 10011989 23-Aug-15 11:46am

ya for sure. i have posted my solution

Member 10011989 · Answer 2 · 2015-08-23T05:45:00

I am Trying to insert record in 2 tables which are in primary and foreign key relationship. but i were facing a problem "duplicate primary key" error eventhough the table being totally empty.i need to insert clgId in both the table it will be foreign key for the course table .so here i have solved the problem with using help of expert Mr Mika

here is my complete solution

Quote:
// **** Inserting data into clgmaster table ****

$query="insert into clgmaster (ClgId,ClgName,ClgAddrs,FeeAmt,CntNo,Email,Pwd) values ($id,'$clgnm','$addrs',$fees,$cntno,'$eml','$pwd')";

$result = mysql_query($query);//Excecuting clg query

echo $result."
";

if ($result)
{
echo "
You Have Successfully REGISTERED this Record!";

}
else
die("
mysql error ".mysql_error()); //Checking for Error
echo "
";

// **** inserting data into course table ****

$query1="insert into course (ClgId,CourseName) values ($id,'$course')";
echo $query1;

$result1 = mysql_query($query1);//Executing course query

if(!$result1)
{
die("
Mysql erro".mysql_error());
}
else
echo "
record inserted successfully in course";
}