Insert Querry in PHP

Discussion in 'PHP' started by mandarj123, Apr 4, 2009.

0
  1. #1
    $userreg=$_POST['UserName'];
    $passreg=$_POST['Password'];
    $agereg=$_POST['Age'];
    $dobreg=$_POST['DOB'];
    if($msconnect)
    {
    $querryRegister="INSERT INTO UserData 'UserName','Password','Age','DateOfBirth' VALUES '$userreg','$passreg','$agereg','$dobreg' ";

    see if this querry is rite??
    obviously its not coz its givin error invalid syntax near UserName

    please correct it;):eek:
     
    mandarj123, Apr 4, 2009 IP
  2. PoPSiCLe

    PoPSiCLe Illustrious Member

    Messages:
    4,623
    Likes Received:
    725
    Best Answers:
    152
    Trophy Points:
    470
    #2
    Change it to:

    $querryRegister="INSERT INTO UserData (UserName,Password,Age,DateOfBirth) VALUES ('$userreg','$passreg','$agereg','$dobreg')";
     
    PoPSiCLe, Apr 4, 2009 IP
  3. ActiveFrost

    ActiveFrost Notable Member

    Messages:
    2,072
    Likes Received:
    63
    Best Answers:
    3
    Trophy Points:
    245
    #3 
    INSERT INTO Table (first_field, second_field, third_field) VALUES ('first_value', 'second_value', 'third_value')
    Code (markup):
     
    ActiveFrost, Apr 4, 2009 IP