Error of query and insertion in php

0

My problem just happened to me, my code was quite good. The detail was that I modified a couple of things in Conect_Db and after that when I try to enter my data I see this error in my PHP code line, someone who can you help me? ...

  

Warning: mysql_num_rows () expects parameter 1 to be resource, boolean given in

Code:

<?php

    $realname=$_POST['realname'];
    $mail=$_POST['nick'];
    $pass= $_POST['pass'];
    $rpass=$_POST['rpass'];

    require("connect_db.php");
    $checkemail=mysql_query("SELECT * FROM login WHERE email='$mail'");
    $check_mail=mysql_num_rows($checkemail)or die(mysql_error());//or die (mysql_error()) -- se uso la sentencia para cerrar la comprobacion del check mail
        if($pass==$rpass){
            if($check_mail>0){
                echo ' <script language="javascript">alert("Atencion, ya existe el mail designado para un usuario, verifique sus datos");</script> ';
            }else{

                //require("connect_db.php");
                mysql_query("INSERT INTO login VALUES('','$realname','$pass','$mail','')")or die(mysql_error());
                //echo 'Se ha registrado con exito';
                echo ' <script language="javascript">alert("Usuario registrado con éxito");</script> ';
                mysql_close($link);
            }

        }else{
            echo 'Las contraseñas son incorrectas';
        }


?>
    
asked by Landa 04.12.2017 в 22:38
source

0 answers