insert query problem

3 posts Page 1 of 1
Contributors
User avatar
seeker
New Member
New Member
Posts: 11
Joined: Fri Sep 09, 2011 6:26 pm

insert query problem
seeker
plz help me out in this query
Code: Select all
<?php 
    $a = $_POST['T1']; 
    $b = $_POST['T2']; 
    $c = $_POST['T3']; 
    $d = $_POST['T4']; 
    $e = $_POST['T5']; 
    $f = $_POST['T6']; 
     
    $con = mysql_connect("localhost", "root", ""); 
    if(!$con) 
    { 
    echo "error in connection".mysql_error(); 
    } 
    mysql_select_db("uc", $con); 
    $q = mysql_query("insert into members values('$a',$b','$c','$d','$e','$f'",$con); 
    if(!$q) 
    { 
    echo "error in query".mysql_error(); 
    } 
    
    
    session_start(); 
     
    $_SESSION['sname'] = $a; 
    header("location:confrmreg.php");     
    } 
    else 
    { 
    echo "invalid id or password try again"; 
    } 
?>
User avatar
mandai
Coding God
Coding God
Posts: 2585
Joined: Mon Apr 26, 2010 6:51 pm

Re: insert query problem
mandai
There appears to be a missing if statement on line 25.
User avatar
seeker
New Member
New Member
Posts: 11
Joined: Fri Sep 09, 2011 6:26 pm

Re: insert query problem
seeker
the error is "DUPLICATE KEY 0 TO 1"

i made changes in query it was run only one time and redirect to other page successfully

but again i try . its gives the above error
3 posts Page 1 of 1
Return to “Help & Support”