Hi,
When I use this MYSQL request:
function get_adverts_info($title)
{
$query = $this->db->query('
SELECT * FROM categories_a
LEFT JOIN adverts ON (categories_a.id = adverts.id_categories_a)
WHERE adverts.url LIKE '.$title.'
');
return $query->row_array();
}CI gives me the follow message:
Error Number: 1054
Unknown column ‘ur’ in ‘where clause’
SELECT * FROM categories_a LEFT JOIN adverts ON (categories_a.id = adverts.id_categories_a) WHERE adverts.url LIKE ur
Filename: Z:\home\localhost\www\budprice\system\database\DB_driver.php
Line Number: 330
What’s wrong? As I understand the problem is with quotes ‘ur’. How to write correctly ?
Thanks!