Help me i am makeing a login

[samuelsmcvids]

I m coding a log in for my site and it gives me this error Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/a8737860/public_html/register.php on line 93.

here is my coding 

 

<?php $title = "Samuelsmcvids Community- Register";?>
<?php require("styles/top.php"); ?>
    <div id='full'>
    <?php


$form = "<form action='register.php' method='post'>
<table>
<tr>
   <td>
   <p>Required = <font color='red'>*</font></p>
</td>
</tr>
<tr>
   <td>Full name:<font color='red'>*</font></td>
<td><input type='text' name='fullname'></td>
</tr>
<tr>
   <td>Last name:<font color='red'>*</font></td>
<td><input type='text' name='lastname'></td>
</tr>
<tr>
   <td>Username:<font color='red'>*</font></td>
<td><input type='text' name='username'></td>
</tr>
<tr>
   <td>Email:<font color='red'>*</font></td>
<td><input type='text' name='email'></td>
</tr>
<tr>
   <td>Password:<font color='red'>*</font></td>
<td><input type='password' name='password'></td>
</tr>
<tr>
   <td>Confirm Password:<font color='red'>*</font></td>
<td><input type='password' name='repassword'></td>
</tr>
<tr>
   <td>Avatar:</td>
<td><input type='file' name='avatar'></td>
</tr>
<tr>
   <td>Website address:</td>
<td><input type='text' name='website'></td>
</tr>
<tr>
   <td>Youtube username:</td>
<td><input type='text' name='youtube'></td>
</tr>
<tr>
   <td>Bio/about:</td>
<td><textarea name='bio' cols='35' rows='5'></textarea></td>
</tr>
<tr>
<td><input type='submit' name='submitbtn' value='Register'></td>
</tr>
</table>
</form>";


if ($_POST['submitbtn']) {


$firstname = strip_tags($_POST['firstname']);
$lastname = strip_tags($_POST['lastname']);
$username = strip_tags($_POST['username']);
$email = strip_tags($_POST['email']);
$password = strip_tags($_POST['password']);
$repassword = strip_tags($_POST['repassword']);
$website = strip_tags($_POST['website']);
$youtube = strip_tags($_POST['youtube']);
$bio = strip_tags($_POST['bio']);


$name = $_FILES['avatar']['name'];
$type = $_FILES['avatar']['type'];
$size = $_FILES['avatar']['size'];
$tmpname = $_FILES['avatar']['tmp_name'];
$ext = substr($name, strrpos($name, '.'));
}




if ($firstname && $lastname && $username && $email && $password && repassword){


   }
else
    echo"You did not fill out all the forms. $form";
   if ($password == $repassword){


}
else
    echo"The two passwords you entered do not match. $form";


require("scripts/connect.php");


$query = mysql_query("SELECT * FROM users WHERE username='$username'");
$num_rows = mysql_num_rows($query);
if($num_rows == 0){


}
else
    echo "Sorry that username is taken. $form";


   $pass = md5(md5(password));
$date = date("F d, Y");


if ($name){
   move_uploaded_file($tmpname, "avatars/$username.$ext");
$avatar = "$username.$ext";
}
else
    $avatar = "avatars/default.jpg";




$code = substr(md5(rand(11111111111111111, 999999999999999999)), 2, 25);


mysql_query("INSERT INTO users VALUES '', '$firstname', '$lastname', '$username', '$email', '$pass', '$avatar', '$bio', '$website', '$youtube', '', '$code', '0', '', '0', '$date'");




$webmaster = "samuelojanes@yahoo.com";
$subject = "Activate your Account";
$headers = "From: Samuelsmcvids<$webmaster>";
$message = "Hello $firstname $lastname!Thanks for joining http://smvidscommunity.tk!, A.K.A Samuelsmcvids Community! below is a link to activate you account!\n\n click her to Activate:
http://smvidscommunity/activate.php?code=$code";


mail($email, $subject, $message, $headers);


echo "Thanks for joining!You must now activate your account through the activation email that has been sent to <b>$email</b>.You must activate your account to be able to login. If you have having problems please contact the site administrator at  <a href='mailto:samuelojanes@yahoo.com'>samuelojanes@yahoo.com</a>";




    echo "$form";


?>
</div>
<?php require("styles/bottome.php"); ?>

 

Edited January 13, 2014 by samuelsmcvids

[PravinS]

check the syntax of INSERT query

 

http://dev.mysql.com/doc/refman/5.6/en/insert.html