Welcome Guest, Not a member yet? Register   Sign In
Problem in model
#1

[eluser]Unknown[/eluser]
In my model i use this code:

Code:
function data($playerID, $clubID)
    {
        $sql = "SELECT * FROM players, users WHERE playerID = ? AND playerClub = ? LIMIT 0,1";
        $query = $this->db->query($sql, $playerID, $clubID);

        if ($query->num_rows > 0)
            return $query->result();
    }

And i call it in my controller with the 2 variables. I test it by echo it in the model. I got an 1064 sql error:

Quote:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1


Thanks.




Theme © iAndrew 2016 - Forum software by © MyBB