Warning....

[carcioghina]

salut....sunt inepator in php...am dat de o problema si anume codul acesta care-mi da eroare:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in <fisieru' asta> linia if (mysql_num_rows($login)):

Cod PHP:

/*-------------------------------------Autentificare-------------------------------------*/
    function login()
    {
        
    global $user_data;
    global $auth;
    global $page;
    global $msg;
    
    $user_data = array(
                                "id"=> array("value" =>$_POST["id"]),
                                "username"=> array( "value" => $_POST["user"]),
                                "pass"=> array( "value" => $_POST["pass"]),
                                "cookie"=> array( "value" => $_POST["cookie"])
                        );
    //verifica user & pass
    
    $proc = true;
    
    if (!$user_data["username"]["value"])
    {
        $msg["warning"] = warn("Campul de user este necompletat!");
        $page = "login";
        $proc = false;
    }
    if (!$user_data["pass"]["value"])
    {
        $msg["warning"] .= warn("<br>Campul de parola este necompletat!");
        $page = "login";
        $proc = false;
    }
    
        if ($proc == true)
        {
        $query = "SELECT * FROM users WHERE username = 
'".$user_data["username"]["value"]."' AND password = 
MD5('".$user_data["pass"]["value"]."')";
        $login = mysql_query($query);
            
if (mysql_num_rows($login))
            {
                $result = mysql_fetch_assoc($login);
                echo $result['admin'];
                $_SESSION['auth'] = array(
                                            "id" => $result['userID'],
                                            "user" => $result['username'],
                                            "pass" => $result['password'],
                                            "admin" => $result['admin']
                );                
                
                $msg["header"] = "Ati fost autentificat cu succes!<br>";
                if ($user_data["cookie"]["value"])
                {
                    setcookie("id", $result["userID"], time()+1209600);
                    setcookie("user", $result["username"], time()+1209600);
                    setcookie("pass", $result["password"], time()+1209600);
                    setcookie("admin", $result["admin"], time()+1209600);
                }
            }
            else {$msg["warning"] = warn("Userul sau parola incorecte!"); 
$page = "login";}
        }
    } 


se pare ca nu-i place mysql_num_rows()....scriptul merge cu brio pe alt server. am gasit undeva ca ar ajuta daca as pune @ in fata funcitei: @mysql_num_rows(....). Intr-adevar, nu mai arata warning-ul, dar nimic mai mult. poate sa ma ajute cineva? multumesc anticipat.

[comandrei]

mysql_query, daca te uiti in documentatia de la php.net, in cazul unei erori returneaza FALSE, rezultat cu care mysql_num_rows nu poate lucra (parametru trimis catre mysql_num_rows trebuie sa fie o resursa mysql).
Deci dai un

Cod PHP:

die($query); 


inainte de

Cod PHP:

$login=mysql_query($query) 


si ruleaza query-ul in phpMyAdmin si vezi ce zice. Bafta

[carcioghina]

nop..ca sa fiu sigur am dat echo la $query si copy paste in php my admin....din pacate merge. repet, am folosesc acest script fara probleme pe alt host.
ah..si btw..daca dau die imi face echo pe $query dupa care moare...nu mai afiseaza nimic.

[carcioghina]

problema rezolvata!!!!!

desi in cpanel (care btw...cam sucks) imi arata Privileges:ALL marcate pe userul si DB-ul respectiv a trebuit sa marchez macar selectul si a mers!

oricum merci