from regestarion database in php

<?php
 $con = mysql_connect("localhost","root","");
        if (!$con)
        {
          die('Could not connect: ' . mysql_error());
        }

        mysql_select_db("registration", $con);

        $sql="insert into registration (firstname,lastname,email,phone,bdate,password,re_password ) values ('$_POST[firstname]','$_POST[lastname]','$_POST[email]','$_POST[phone]','$_POST[bdate]','$_POST[password]','$_POST[re_password]')";

        if (!mysql_query($sql,$con))
        {
          die('Error: ' . mysql_error());
        }
        echo "1 record added";

        mysql_close($con)
        ?>