Student help needed please

[jamesyrawr]

Hi

I get the following error when running this file.

Fatal error: Call to undefined function mysqql_query() in C:\wamp\www\Isis\login.php on line 14]

 

I'm not sure if i have missed something or typed something wrong but a second opinion is always better

 

<?php


    $username = $_POST['username'];
    $password = $_POST['password'];
    $login = $_GET['login'];
    
    setcookie("username", "$username", time()+86400);

    if ($login=='yes') {
        $con = mysql_connect("localhost","root","");
        mysql_select_db("obsosuser");
        
        $get = mysqql_query("SELECT count(id) FROM obsosuser WHERE username='$username' and password='$password'");
        
        if ($result!=1){
            echo "Invalid Login!";
            
        } else
            echo "Login Successful! Welcome back ".$_COOKIE['username']." Sir/Maddam." ;
            $_SESSION ['username'] = $username;
    }

?>

Thanks

[gizmola]

yeah well the function is named mysql_query() not mysqql_query.

[jamesyrawr]

Thanks

 

knew i had missed something

although

i'm getting another error message

Warning: mysql_result() expects parameter 1 to be resource, boolean given in C:\wamp\www\Isis\login.php on line 16

 

<?php


    $username = $_POST['username'];
    $password = $_POST['password'];
    $login = $_GET['login'];
    
    setcookie("username", "$username", time()+86400);

    if ($login=='yes') {
        $con = mysql_connect("localhost","root","");
        mysql_select_db("obsosuser");
        
        $get = mysql_query("SELECT count(id) FROM obsosuser WHERE username='$username' and password='$password'");
        
        $result = mysql_result($get, 0);
        if ($result!=1){
            echo "Invalid Login!";
            
        } else
            echo "Login Successful! Welcome back ".$_COOKIE['username']." Sir/Maddam." ;
            $_SESSION ['username'] = $username;
    }

?>

 

 

 

[pengu]

Change.

$result = mysql_result($get, 0);

 

To.

$result = mysql_result($get, $con);

[jamesyrawr]

Thanks Pengu, but i tried your change and i still got the same result:

Warning: mysql_result() expects parameter 1 to be resource, boolean given in C:\wamp\www\Isis\login.php on line 16

 

[PFMaBiSmAd]

The defintion of mysql_result() -

string mysql_result ( resource $result , int $row [, mixed $field = 0 ] )

 

Assuming that the code you posted is the code producing the error, it means that your query failed due to an error and returned a FALSE value.

 

For debugging purposes, echo mysql_error(); on the next line after the line with your mysql_query() statement, it will tell you why the query failed.

 

 

[jamesyrawr]

Was database issues  :-\

its all sorted now

but i changed

$result = mysql_result($get, $con);

back too

$result = mysql_result($get, 0);

and it seems to be working again

Thanks