Código:
porfavor diganme que esta mal esto es lo que me sale################################################################################ #------------------------------------------------------------------------------# # Register #------------------------------------------------------------------------------# ################################################################################ function Register(){ include("header.php"); register_form(); include("footer.php"); } function register_form(){ global $username, $password, $email, $fullname, $user_taken_err, $email_taken_err; echo "<center><font class=\"title\">Registration form</font></center><br>\n"; echo "<center>Fields marked with a * are required. <form name=\"RegisterForm\" method=\"POST\" action=\"users.php\" onsubmit='return CheckRegisterForm(RegisterForm)'> <table align=\"center\" border=\"1\" width=\"400\" id=\"table1\" cellpadding=\"2\" bordercolor=\"#C0C0C0\"> <tr> <td width=\"100\" align=\"right\">Username:</td> <td><input type=\"text\" name=\"username\" size=\"18\" value=\"$username\"> * $user_taken_err</td> </tr> <tr> <td align=\"right\">Password:</td> <td><input type=\"password\" name=\"password\" size=\"18\" value=\"$password\"> *</td> </tr> <tr> <td align=\"right\">Email:</td> <td><input type=\"text\" name=\"email\" size=\"27\" value=\"$email\"> * $email_taken_err</td> </tr> <tr> <td align=\"right\">Full Name:</td> <td><input type=\"text\" name=\"fullname\" size=\"27\" value=\"$fullname\"></td> </tr> <tr> <td> </td> <td> <input type=\"hidden\" name=\"maa\" value=\"do_Register\"> <input type=\"submit\" value=\"Register\"></td> </tr> </table></form>"; } function do_Register(){ global $db, $prefix, $username, $password, $email, $fullname, $user_taken_err, $email_taken_err; global $site_name, $site_email, $site_url; $username = mysql_real_escape_string($_POST['username']); $password = mysql_real_escape_string($_POST['password']); $email = mysql_real_escape_string($_POST['email']); $fullname = mysql_real_escape_string($_POST['fullname']); //this function will check fields incase of javascript not working. if((!$username) || (!$password) || (!$email)){ if(trim(empty($username))){ } if(empty($password)){ } if(trim(empty($email))){ } //print the error message and load the form. include("header.php"); echo "<center><font class=\"error\">Error:<br>Please fill all fields.</font></center>\n"; register_form(); include("footer.php"); exit(); } /*--nothing empty? lets do the register-------------------------------------------------------------*/ $sql_email_check = mysql_query("SELECT email FROM ".$prefix."_users WHERE email='$email'"); $sql_username_check = mysql_query("SELECT username FROM ".$prefix."_users WHERE username='$username'"); $email_check = mysql_num_rows($sql_email_check); $username_check = mysql_num_rows($sql_username_check); if(($email_check > 0) || ($username_check > 0)){ //define error message for usage in multi plces. $exist_msg= "<font class=\"error\">(Already Taken!.)</font>"; if($email_check > 0){ $email_taken_err = $exist_msg; unset($email); } if($username_check > 0){ $user_taken_err = $exist_msg; unset($username); } //if the username or email already been taken load the form and print errors. include("header.php"); register_form(); include("footer.php"); exit(); } $md5_password = md5($password); $result = mysql_query("INSERT INTO ".$prefix."_users ( username,password,email,fullname) VALUES('$username','$md5_password','$email','$fullname')") or die ("Error in registration sql:". mysql_error()); $subject = "Your info at $site_name"; $message = " Welcome to $site_name Please keep this email for your records. Your account information is as follows: ---------------------------- Username: $username Password: $password ---------------------------- Your account is currently active. You can use it by visiting the following link: $site_url Please do not forget your password as it has been encrypted in our database and we cannot retrieve it for you. However, should you forget your password you can request a new one which will be sent to your email. Thank you for registering. -- - $site_name $site_url This email was automatically generated. Please do not respond to this email or it will ignored."; if(!mail($email,$subject,$message, "FROM: $site_name <$site_email>")){ die ("Faild sending registration email, please report this to the webmaster ($site_email)"); }else{ include("header.php"); echo "registration was successfull.....!! you can now log in"; login_form(); include("footer.php"); } }
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/atlvip/public_html/login/users.php on line 259
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/atlvip/public_html/login/users.php on line 260
Error in registration sql:Table 'atlvip_usuarios.maaking_users_users' doesn't exist
gracias espero me puedan ayudar