写入MySQL失败

此时我有一个失败的if树。我不知道为什么php代码不写入MySQL数据库。非常感谢任何帮助。代码在第1行之后的某个时间失败。

if ($numrows == 0) {
                                        $password = md5(md5("qkIa4".$getpass."qwenm"));
                                        $date = date("F d, Y");
                                        $code = md5("fekwe".$password);
                                        //insert user into db
                                        mysql_query("INSERT INTO users VALUES ('', '$getuser', '$password', '$getemail', '0', '$code', '$date', '$fn', '0')");
                                        //check if entry was made into db
                                        $query = mysql_query("SELECT * FROM users WHERE username='$getuser'");
                                        $numrows = mysql_num_rows($query);
                                        if ($numrows == 1) {

                                            //email the user code
                                        }
                                        else
                                            $errormsg = "An error has occured. Your account was not created.";
                                            echo mysql_error();
                                            echo $getuser;
                                            echo "<br />";
                                            echo $password;
                                            echo "<br />";
                                            echo $getemail;
                                            echo "<br />";
                                            echo $code;
                                            echo "<br />";
                                            echo $fn;

代码只回显mysql_connect();弃用。

提前感谢!