asdfasdf
By: a guest | Feb 9th, 2010 | Syntax:
PHP | Size: 0.53 KB | Hits: 63 | Expires: Never
$query = $this->db->query(" SELECT aviso.id, aviso.detalle, aviso.titulo, aviso.tipo_aviso, aviso.nivel
FROM aviso
LEFT JOIN contacto ON contacto.localidad_id = $localidad
WHERE contacto.id = aviso.contacto_id
AND aviso.nivel > 0 $tipo
ORDER by aviso.id DESC
LIMIT 0, $n ;"
);