错误：选择查询中的资源ID＃52

Question

Why do I getan error of Resource id #52?

I have this query:

$unit = $this->input->get_post('inCode');
$sql = mysql_query('select ID from type where code like "%'.$unit.'%";');

I just want to output the variable $sql in here:

$this->db->set('Unit', $sql);
$this->db->insert('structure');

I just get that error. I have to insert the ID from the table: type. It is an INTEGER and the column: Unit is also an INTEGER.

Answer 1

Though I'm not sure what $this->db->set and $this->db->insert in your project were expect, but I guess you don't need to pass a resource (that was what mysql_query return)

Try using this instead

$sql = 'select ID from type where code like "%'.$unit.'%";';