is there proceed pass arguments query codeigniter *without* controlling activerecord?
this i'd do, nonetheless doesn't seem possible:
(edit: altered unparalleled double quotes)
function get_archives($limit, $offset)
{
$query = $this->db->query("
name archivalie.id,
archivalie.signature,
type_of_source.description type_of_source_description,
media_type.description media_type_description,
origin.description origin_description
archivalie,
type_of_source,
media_type,
origin
where archivalie.type_of_source_id = type_of_source.id
type_of_source.media_type_id = media_type.id
archivalie.origin_id = origin.id
method archivalie.id asc
border $limit, $offset
");
// etc...
}
it gives error:
(edit: new blunder summary controlling double quotes, an homogeneous array upheld url)
error: border #,# syntax upheld hint: removed border homogeneous clauses.
it wholly works pass variables controlling activerecord format:
$this->db->select('archivalie.id, archivalie.signature, etc, etc');
// from, where, etc.
$this->db->limit($limit, $offset);
$query = $this->db->get();
Comments
Post a Comment