Помогите с ошибкой

[hoske 117]

Error Number: 1064

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 'AS work_price FROM works_sales AS s LEFT JOIN works AS w ON (s.work = ' at line 1

SELECT s.*, w.* AS work_price FROM works_sales AS s LEFT JOIN works AS w ON (s.work = w.id) WHERE s.user = 1 ORDER BY s.date DESC

Filename: /var/www/hoske/data/www/site.ru/models/work.php

Line Number: 188

вот ошибка вот 188  строчка  work.php и все что входит в запрос

public function get_purchased($id)

    {

        

        $sql = "SELECT s.*, w.* AS work_price FROM works_sales AS s

                LEFT JOIN works AS w ON (s.work = w.id)

                WHERE s.user = " . $id . "

                ORDER BY s.date DESC";

        

        $query = $this->db->query($sql);

        $works = $query->result();

        $result = array();

        foreach($works as $work)

            if(!empty($work->name))

                $result[] = $work;

    

        return $result;

    }

 

 

не отображает купленные товары

Изменено 21 апреля, 2015 пользователем hoske

[2terege 67]

Error Number: 1064

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 'AS work_price FROM works_sales AS s LEFT JOIN works AS w ON (s.work = ' at line 1

SELECT s.*, w.* AS work_price FROM works_sales AS s LEFT JOIN works AS w ON (s.work = w.id) WHERE s.user = 1 ORDER BY s.date DESC

Filename: /var/www/hoske/data/www/site.ru/models/work.php

Line Number: 188

вот ошибка вот 188  строчка  work.php и все что входит в запрос

public function get_purchased($id)

    {

        

        $sql = "SELECT s.*, w.* AS work_price FROM works_sales AS s

                LEFT JOIN works AS w ON (s.work = w.id)

                WHERE s.user = " . $id . "

                ORDER BY s.date DESC";

        

        $query = $this->db->query($sql);

        $works = $query->result();

        $result = array();

        foreach($works as $work)

            if(!empty($work->name))

                $result[] = $work;

    

        return $result;

    }

 

 

не отображает купленные товары

 

 

 

SELECT s.*, w.* AS work_price FROM works_sales AS s LEFT JOIN works AS w ON (s.work = w.id) WHERE s.user = " . $id . "ORDER BY s.date DESC

ты сам запрос в бд задай вручную если ответит знач править