PHP query failed

Vote count:

-1

Im trying to insert data into phpmyadmin database using php but sql query fails for some reason and it prints failed !!doesanybody knw hw to correct this?

    $username = $_POST["username"];
    $password = $_POST["password"];
    $email=$_POST["email"];
    $confirm_password=$_POST["password_confirm"];
    echo "abcd";
    if( $password==$confirm_password)
    {

        $category="user";
         $a=1;

        // header( 'Location: http://localhost:8080/index.php' );
        $database = "traversepakistan";
        $db_handle = mysql_connect("127.0.0.1", "root", "usbw");
        $db_found = mysql_select_db($database, $db_handle);
        $query="INSERT INTO     person(id,userName,password,profile_pic,conact_no,category,userDisplayName,
        email,cover_photo) VALUES('".$a."','".$username."','".$password."','".NULL."','".NULL."',
        '".$username."', '".$email."', '".NULL."')";

        if(mysql_query($query))
        echo "Query successfull</br>";
        else
        echo "<h2>Failed!</h2></br>";
         //header( 'Location: http://localhost:8080/index.php' );
       }
        } 

      ?>

asked 21 secs ago

sarah

1

PHP query failed