Database Query Problem

[eluser]jedd[/eluser]
On that note, depending on the history of $name before it lands in this function, you might want to do one of two alternatives:

Code:

$this->db->query('SELECT PROJECT_ID FROM PROJECT WHERE TITLE = '. $this->db->escape($name) .' LIMIT 1');

or

Code:

$sql = 'SELECT PROJECT_ID FROM PROJECT WHERE TITLE = ? LIMIT 1';
$this->db->query($sql, array($name));

These are both explained in the Database class section of the user guide.