mysql_num_rows() error

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/ultimatum/test/members/register.php on line 27

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/export/www/vhosts/funnetwork/hosting/ultimatum/test/members/register.php on line 27

<?php

include "config.php";

if(isset($_POST["submit"])) {
$name = $_POST["name"];
$pass = $_POST["pass"];
$cpass = $_POST["cpass"];
$mail = $_POST["mail"];

if ($name==NULL) {
echo "You have to choose an username";
} elseif ($pass==NULL) {
echo "You have to enter a password";
} elseif ($cpass==NULL) {
echo "You have to confirm your password";
} elseif ($mail==NULL) {
echo "You have to enter an email address";
} elseif ($pass!=$cpass) {
echo "Passwords must be the same";
} else {

$user = mysql_query("SELECT name FROM members WHERE name='$name'");
$user_exist = mysql_num_rows($user);

$email = mysql_query("SELECT mail FROM members WHERE mail='$mail'");
$mail_exist = mysql_num_rows($mail);

if ($user_exist>0) {
echo "That username is already taken";

}elseif ($mail_exist>0) {
echo "That email address is already in use";

}else {
$insert = "INSERT INTO members (name, pass, mail) VALUES ('$name', '$pass', '$mail')";
mysql_query($insert) or die(mysql_error());
echo "The user $name has succesfully created";
}
}
}

?>


<form action="register.php" method="post">
Name:<br /><input type="text" name="name" size="25" maxlength="100" /><br />
Password:<br /><input type="password" name="pass" size="25" maxlength="100" /><br />
Confirm Password:<br /><input type="password" name="cpass" size="25" maxlength="100" /><br />
E-mail:<br /><input type="text" name="mail" size="25" maxlength="125" /><br /><br />
<input type="submit" name="submit" value="Submit" />
</form>

<?php
 
include "config.php";
 
if(isset($_POST["submit"])) {
$name = $_POST["name"];
$pass = $_POST["pass"];
$cpass = $_POST["cpass"];
$mail = $_POST["mail"];
 
if ($name==NULL) {
echo "You have to choose an username";
} elseif ($pass==NULL) {
echo "You have to enter a password";
} elseif ($cpass==NULL) {
echo "You have to confirm your password";
} elseif ($mail==NULL) {
echo "You have to enter an email address";
} elseif ($pass!=$cpass) {
echo "Passwords must be the same";
} else {
 
$user = mysql_query("SELECT name FROM members WHERE name='$name'");
$user_exist = mysql_num_rows($user);
 
$email = mysql_query("SELECT mail FROM members WHERE mail='$mail'");
$mail_exist = mysql_num_rows($mail);
 
if ($user_exist>0) {
echo "That username is already taken";
 
}elseif ($mail_exist>0) {
echo "That email address is already in use";
 
}else {
$insert = "INSERT INTO members (name, pass, mail) VALUES ('$name', '$pass', '$mail')";
mysql_query($insert) or die(mysql_error());
echo "The user $name has succesfully created";
}
}
}
 
?>
 
 
<form action="register.php" method="post">
Name:<br /><input type="text" name="name" size="25" maxlength="100" /><br />
Password:<br /><input type="password" name="pass" size="25" maxlength="100" /><br />
Confirm Password:<br /><input type="password" name="cpass" size="25" maxlength="100" /><br />
E-mail:<br /><input type="text" name="mail" size="25" maxlength="125" /><br /><br />
<input type="submit" name="submit" value="Submit" />
</form>

<?php

$link = mysql_connect("localhost", "username", "password");
mysql_select_db("database", $link);

$result = mysql_query("SELECT * FROM table1", $link);
$num_rows = mysql_num_rows($result);

echo "$num_rows Rows\n";

?> 

<?php
 
$link = mysql_connect("localhost", "username", "password");
mysql_select_db("database", $link);
 
$result = mysql_query("SELECT * FROM table1", $link);
$num_rows = mysql_num_rows($result);
 
echo "$num_rows Rows\n";
 
?>

$result = mysql_query("SELECT * FROM table1", $link) or die(mysql_error());
$num_rows = mysql_num_rows($result);

$result = mysql_query("SELECT * FROM table1", $link) or die(mysql_error());
$num_rows = mysql_num_rows($result);

<?php
include 'config.php';   // config includen

if($_SERVER['REQUEST_METHOD'] == "POST")
{
$name = $_POST["name"];
$pass = $_POST["pass"];
$cpass = $_POST["cpass"];
$mail = $_POST["mail"];

if ($name==NULL)
{
    echo "You have to choose an username";
}
  elseif ($pass==NULL)
  {
      echo "You have to enter a password";
  }
    elseif ($cpass==NULL)
    {
        echo "You have to confirm your password";
    }
      elseif ($mail==NULL)
      {
          echo "You have to enter an email address";
      }
        elseif ($pass!=$cpass)
        {
            echo "Passwords must be the same";
        }
          else
          {

              $user = mysql_query("SELECT name FROM members WHERE name='".$name."'") or die(mysql_error());
              $user_exist = mysql_num_rows($user);

              $email = mysql_query("SELECT mail FROM members WHERE mail='".$mail."'")or die(mysql_error());
              $mail_exist = mysql_num_rows($mail);

              if ($user_exist > 0)
              {
                  echo "That username is already taken";
              }
                elseif ($mail_exist > 0)
                {
                    echo "That email address is already in use";
                }

                  else
                  {
                      mysql_query("INSERT INTO members (name, pass, mail) VALUES ('".$name."', '".$pass."', '".$mail."')") or die( mysql_error());
                      echo "The user ".$name." has succesfully created";
                  }
          }
}

?>

<?php
include 'config.php';   // config includen
 
if($_SERVER['REQUEST_METHOD'] == "POST")
{
$name = $_POST["name"];
$pass = $_POST["pass"];
$cpass = $_POST["cpass"];
$mail = $_POST["mail"];
 
if ($name==NULL)
{
    echo "You have to choose an username";
}
  elseif ($pass==NULL)
  {
      echo "You have to enter a password";
  }
    elseif ($cpass==NULL)
    {
        echo "You have to confirm your password";
    }
      elseif ($mail==NULL)
      {
          echo "You have to enter an email address";
      }
        elseif ($pass!=$cpass)
        {
            echo "Passwords must be the same";
        }
          else
          {
 
              $user = mysql_query("SELECT name FROM members WHERE name='".$name."'") or die(mysql_error());
              $user_exist = mysql_num_rows($user);
 
              $email = mysql_query("SELECT mail FROM members WHERE mail='".$mail."'")or die(mysql_error());
              $mail_exist = mysql_num_rows($mail);
 
              if ($user_exist > 0)
              {
                  echo "That username is already taken";
              }
                elseif ($mail_exist > 0)
                {
                    echo "That email address is already in use";
                }
 
                  else
                  {
                      mysql_query("INSERT INTO members (name, pass, mail) VALUES ('".$name."', '".$pass."', '".$mail."')") or die( mysql_error());
                      echo "The user ".$name." has succesfully created";
                  }
          }
}
 
?>

<?
$user = mysql_query("SELECT * FROM members WHERE name='".$name."'");
$user_exist = mysql_num_rows($user);

$email = mysql_query("SELECT * FROM members WHERE mail='".$mail."'");
?>

<?
$user = mysql_query("SELECT * FROM members WHERE name='".$name."'");
$user_exist = mysql_num_rows($user);
 
$email = mysql_query("SELECT * FROM members WHERE mail='".$mail."'");
?>