Register error php, help plz

[fenixblade]

if i proced to register:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/f47870/public_html/mw/register2.php on line 55

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/f47870/public_html/mw/register2.php on line 56
Your account has been registered! Check your email for your password!

<?php
session_start();
include_once"includes/db_connect.php";
if (isset($_SESSION['username'])){
header("Location: logged_in.php");
exit();
}

$from_user=strip_tags($_POST['ref']);
if ($_POST['Submit']){
// Define post fields into simple variables
$reg_username = $_POST['reg_username'];
$email = $_POST['email'];
$email1 = $_POST['email1'];
$location=strip_tags($_POST['location']);
$reg_username=trim($reg_username);
$today = gmdate('Y-m-d h:i:s');
$reg_username = stripslashes($reg_username);
$email = stripslashes($email);
$quote = stripslashes($quote);
$reg_username = strip_tags($reg_username);
$email = strip_tags($email);
if($sn != $_SESSION['scriptnumber']){
echo "Script numbers dont match!";
include 'register.php';
exit();
}
if((!$reg_username) || (!$email) || (!$location)){
echo "Please fill in all fields!";
include 'register.php';
exit();
}else{
if ($email != $email1){
echo "Emails dont match!";
include 'register.php';
exit();
}elseif ($email == $email1){
if (ereg('[^A-Za-z0-9]', $reg_username)) {
echo "Username can only contain letters!";
include 'register.php';
exit();
}elseif (!ereg('[^A-Za-z0-9]', $reg_username)) {
if (strlen($reg_username) <= 3 || strlen($reg_username) >= 40){
echo "The username is to big or to small!";
include 'register.php';
exit();
}elseif (strlen($reg_username) > 3 || strlen($reg_username) < 40){


$sql_email_check = mysql_query("SELECT email FROM users
WHERE email='$email' AND status='Alive'");
$sql_username_check = mysql_query("SELECT username FROM users
WHERE username='$reg_username'");

$email_check = mysql_num_rows($sql_email_check);
$username_check = mysql_num_rows($sql_username_check);

if(($email_check > 0) || ($username_check > 0)){
echo "Im sorry but there has been an error please read on..<br />";
if($email_check > 0){
echo "That email is already being used!";
include 'register.php';
exit();
unset($email);
}
if($username_check > 0){
echo "Your desired username is already in use!";
include 'register.php';
exit();
unset($reg_username);
}


}else{


if ($location == 'England'){
$uk[0] = rand(51,104);
$uk[1] = rand(90,412);
$uk[2] = rand(68,296);
$uk[3] = rand(23,47);
$uk[4] = rand(2705,3312);
$implodething = implode("-", $uk);
////japan////
$city="Cambridgeshire";
}elseif ($location == 'Japan'){
$japan[0] = rand(149,259);
$japan[1] = rand(113,582);
$japan[2] = rand(12,74);
$japan[3] = rand(82,150);
$japan[4] = rand(1700,2832);
///colombia///
$city="Chiba";
$implodething = implode("-", $japan);
}elseif ($location == 'Colombia'){
$colombia[0] = rand(31,301);
$colombia[1] = rand(80,397);
$colombia[2] = rand(23,118);
$colombia[3] = rand(90,123);
$colombia[4] = rand(316,812);
///usa////
$city="Bogota";
$implodething = implode("-", $colombia);
}elseif ($location == 'Usa'){
$usa[0] = rand(51,104);
$usa[1] = rand(90,412);
$usa[2] = rand(60,192);
$usa[3] = rand(98,116);
$usa[4] = rand(472,1003);
$city="Bogota";
///safrica////
$implodething = implode("-", $usa);
$city="New York";
}elseif ($location == 'South Africa'){
$safrica[0] = rand(78,112);
$safrica[1] = rand(170,194);
$safrica[2] = rand(118,132);
$safrica[3] = rand(110,506);
$safrica[4] = rand(1500,1703);

//mexico//

$implodething = implode("-", $safrica);
$city="Alberton";
}elseif ($location == 'Mexico'){
$mexico[0] = rand(70,159);
$mexico[1] = rand(33,68);
$mexico[2] = rand(110,191);
$mexico[3] = rand(12,19);
$mexico[4] = rand(1001,1308);
$implodething = implode("-", $mexico);
$city="Acapulco";
}



$ip = $_SERVER['REMOTE_ADDR'];

$random_password22=rand(11111,99999999);

mysql_query("INSERT INTO `user_info` ( `id` , `username`)
VALUES (
'', '$reg_username')");

mysql_query("INSERT INTO `users` ( `id` , `username` , `password` , `activated` , `money` , `online` , `crimechance` , `lastcrime` , `rankpoints` , `userlevel` , `lasttop` , `status` , `regged` , `rank` , `layout` , `email` , `quote` , `image` , `location` , `bullets` , `gtachance` , `lastgta` , `lasttravel` , `bank` , `banktime` , `last_race` , `music` , `crew` , `get_away_time` , `get_away` , `health` , `energy` , `last_ext` , `lasttran` , `drugprices` , `drugs` , `l_ip` , `r_ip` , `crew_invite` , `referral` , `weapon` , `mission` , `points` , `lpv` , `page` , `editor` , `food_chance` , `last_food` , `last_order` , `freinds` , `protection` , `plane` , `married` , `oc` , `last_oc` , `atm` , `last_bank` , `last_attempted` , `last_kill` , `ver_code` , `last_script_check` , `global` , `poll` , `clicks` , `click_rate` , `tut` , `drugs_from` , `total_drugs_mission` , `city` )
VALUES (
'', '$reg_username', '$random_password22', '1', '10000', '', '0-0-0-0-0-0-0', '', '0', '0', '', 'Alive', '$today', 'Tramp', '0', '$email', 'No quote', 'images/default.jpg', '$location', '0', '0-0-0', '', '', '0', '', '', '', '0', '', '0', '100', '100', '', '', '0-0-0-0-0', '0-0-0-0-0', '127.0.0.1', '$ip', '0', '0', 'None', '1', '0', '', '', '0', '0-0-0', '', '', 'None', 'None', 'None', '', '0', '', 'False', '', '', '', '456', '', '0', '', '0', '', '0', '', '0', '$city'
)");





$userid = mysql_insert_id();
// Let's mail the user!
$subject = "Gangster-Town";
$message = "Dear $reg_username,
Hello $reg_username , we now have your account in the malibu mobsters database.

Login with the following information:
Username: $reg_username
Password: $random_password22

Thanks!
Gangster-Town staff.

This is an automated response, please do not reply!";

mail($email, $subject, $message,
"From: Gangster-Town<info@gangster-town.nl>");
echo "
<link href=\"includes/out.css\" rel=\"stylesheet\" type=\"text/css\">
Your account has been registered! Check your email for your password!";
} }}}}}

?>

what is wrong ? plz i need hlp

[fenixblade]

but if i click and try to register it will apear


Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/f47870/public_html/Mafia Warz/register2.php on line 55

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/f47870/public_html/MW/register2.php on line 56
Your account has been registered! Check your email for your password!

nothing was send.

<?php
session_start();
include_once"includes/db_connect.php";
if (isset($_SESSION['username'])){
header("Location: logged_in.php");
exit();
}

$from_user=strip_tags($_POST['ref']);
if ($_POST['Submit']){
// Define post fields into simple variables
$reg_username = $_POST['reg_username'];
$email = $_POST['email'];
$email1 = $_POST['email1'];
$location=strip_tags($_POST['location']);
$reg_username=trim($reg_username);
$today = gmdate('Y-m-d h:i:s');
$reg_username = stripslashes($reg_username);
$email = stripslashes($email);
$quote = stripslashes($quote);
$reg_username = strip_tags($reg_username);
$email = strip_tags($email);
if($sn != $_SESSION['scriptnumber']){
echo "Script numbers dont match!";
include 'register.php';
exit();
}
if((!$reg_username) || (!$email) || (!$location)){
echo "Please fill in all fields!";
include 'register.php';
exit();
}else{
if ($email != $email1){
echo "Emails dont match!";
include 'register.php';
exit();
}elseif ($email == $email1){
if (ereg('[^A-Za-z0-9]', $reg_username)) {
echo "Username can only contain letters!";
include 'register.php';
exit();
}elseif (!ereg('[^A-Za-z0-9]', $reg_username)) {
if (strlen($reg_username) <= 3 || strlen($reg_username) >= 40){
echo "The username is to big or to small!";
include 'register.php';
exit();
}elseif (strlen($reg_username) > 3 || strlen($reg_username) < 40){


$sql_email_check = mysql_query("SELECT email FROM users
WHERE email='$email' AND status='Alive'");
$sql_username_check = mysql_query("SELECT username FROM users
WHERE username='$reg_username'");

$email_check = mysql_num_rows($sql_email_check);
$username_check = mysql_num_rows($sql_username_check);

if(($email_check > 0) || ($username_check > 0)){
echo "Im sorry but there has been an error please read on..<br />";
if($email_check > 0){
echo "That email is already being used!";
include 'register.php';
exit();
unset($email);
}
if($username_check > 0){
echo "Your desired username is already in use!";
include 'register.php';
exit();
unset($reg_username);
}


}else{


if ($location == 'England'){
$uk[0] = rand(51,104);
$uk[1] = rand(90,412);
$uk[2] = rand(68,296);
$uk[3] = rand(23,47);
$uk[4] = rand(2705,3312);
$implodething = implode("-", $uk);
////japan////
$city="Cambridgeshire";
}elseif ($location == 'Japan'){
$japan[0] = rand(149,259);
$japan[1] = rand(113,582);
$japan[2] = rand(12,74);
$japan[3] = rand(82,150);
$japan[4] = rand(1700,2832);
///colombia///
$city="Chiba";
$implodething = implode("-", $japan);
}elseif ($location == 'Colombia'){
$colombia[0] = rand(31,301);
$colombia[1] = rand(80,397);
$colombia[2] = rand(23,118);
$colombia[3] = rand(90,123);
$colombia[4] = rand(316,812);
///usa////
$city="Bogota";
$implodething = implode("-", $colombia);
}elseif ($location == 'Usa'){
$usa[0] = rand(51,104);
$usa[1] = rand(90,412);
$usa[2] = rand(60,192);
$usa[3] = rand(98,116);
$usa[4] = rand(472,1003);
$city="Bogota";
///safrica////
$implodething = implode("-", $usa);
$city="New York";
}elseif ($location == 'South Africa'){
$safrica[0] = rand(78,112);
$safrica[1] = rand(170,194);
$safrica[2] = rand(118,132);
$safrica[3] = rand(110,506);
$safrica[4] = rand(1500,1703);

//mexico//

$implodething = implode("-", $safrica);
$city="Alberton";
}elseif ($location == 'Mexico'){
$mexico[0] = rand(70,159);
$mexico[1] = rand(33,68);
$mexico[2] = rand(110,191);
$mexico[3] = rand(12,19);
$mexico[4] = rand(1001,1308);
$implodething = implode("-", $mexico);
$city="Acapulco";
}



$ip = $_SERVER['REMOTE_ADDR'];

$random_password22=rand(11111,99999999);

mysql_query("INSERT INTO `user_info` ( `id` , `username`)
VALUES (
'', '$reg_username')");

mysql_query("INSERT INTO `users` ( `id` , `username` , `password` , `activated` , `money` , `online` , `crimechance` , `lastcrime` , `rankpoints` , `userlevel` , `lasttop` , `status` , `regged` , `rank` , `layout` , `email` , `quote` , `image` , `location` , `bullets` , `gtachance` , `lastgta` , `lasttravel` , `bank` , `banktime` , `last_race` , `music` , `crew` , `get_away_time` , `get_away` , `health` , `energy` , `last_ext` , `lasttran` , `drugprices` , `drugs` , `l_ip` , `r_ip` , `crew_invite` , `referral` , `weapon` , `mission` , `points` , `lpv` , `page` , `editor` , `food_chance` , `last_food` , `last_order` , `freinds` , `protection` , `plane` , `married` , `oc` , `last_oc` , `atm` , `last_bank` , `last_attempted` , `last_kill` , `ver_code` , `last_script_check` , `global` , `poll` , `clicks` , `click_rate` , `tut` , `drugs_from` , `total_drugs_mission` , `city` )
VALUES (
'', '$reg_username', '$random_password22', '1', '10000', '', '0-0-0-0-0-0-0', '', '0', '0', '', 'Alive', '$today', 'Tramp', '0', '$email', 'No quote', 'images/default.jpg', '$location', '0', '0-0-0', '', '', '0', '', '', '', '0', '', '0', '100', '100', '', '', '0-0-0-0-0', '0-0-0-0-0', '127.0.0.1', '$ip', '0', '0', 'None', '1', '0', '', '', '0', '0-0-0', '', '', 'None', 'None', 'None', '', '0', '', 'False', '', '', '', '456', '', '0', '', '0', '', '0', '', '0', '$city'
)");





$userid = mysql_insert_id();
// Let's mail the user!
$subject = "Gangster-Town";
$message = "Dear $reg_username,
Hello $reg_username , we now have your account in the malibu mobsters database.

Login with the following information:
Username: $reg_username
Password: $random_password22

Thanks!
Gangster-Town staff.

This is an automated response, please do not reply!";

mail($email, $subject, $message,
"From: Gangster-Town<info@gangster-town.nl>");
echo "
<link href=\"includes/out.css\" rel=\"stylesheet\" type=\"text/css\">
Your account has been registered! Check your email for your password!";
} }}}}}

?>

so, what is wrong ?? plz

[ogar572]

From a quick glance, it looks like there is an error with your sql statement.