MYSQL PHP查询未插入数据

此代码将表单中的数据插入名为"test"的数据库和名为"signup"的表中。插入查询不起作用：

   <?php
    echo"working2";
    if(isset($_POST['submit']))
    {
    echo"woerking";
    $conn = mysql_connect("localhost", "root", "", "test") or die("error connecting");
    echo"woerking1";
        $flag=0;
        $Rno=$_POST['rno'];
        echo$Rno;
        $fname=$_POST['fname'];
        echo $fname;
            $lname=$_POST['lname'];
        $email=$_POST['uemail'];
            $pswd=$_POST['pswd'];
        $repswd=$_POST['repswd'];

        //$choice="select Rollno from signup where Rollno='$Rno' ";
        //$chk=mysql_query($choice);
            //echo $chk;
        //while($row=mysql_fetch_array($chk))
        //{
            //echo "<font color='red'>ROLL-NUMBER ALREADY EXIST!!!!</font>";
            //$flag=1;
        //}

        if($flag==0)
    {
       $query="INSERT INTO `signup`(`Rollno`, `fname`, `lname`, `email-id`,    `password`, `retype`)     VALUES($Rno,'$fname','$lname','$email','$pswd','$repswd')";
*##//query not working##* 
            $tem=mysql_query($query);
                    if(isset($tem))
            {
                echo"REGISTERED SUCCESSFULLY";
            }
        }
    }
    ?>