[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.