Mysql get, where, order by and limit in one.

[eluser]BnoL[/eluser]
Me too, I'm Vietnamese. A dictionairy might be helpful for us

[eluser]Nateisonfire[/eluser]
Funny, english is my first language and while looking through the user guide I still had trouble trying to figure this one out! It is late and I am a little tired, but I did a lot of Googling and this topic finally popped up.

[eluser]BoggTm[/eluser]
Hellow, I am new, and I have a problem: my datas are displated outside, not in the website

code:
$data = array();
$this->data['CONTENT'] = $this->load->view('Forms/FormCautareNum', $data, TRUE);
$this->parser->parse('layout/base_template',$this->data);

if ($this->input->post('btnAfisNum'))
{
$var=$this->input->post('textfield');
$query = $this->db->query("SELECT * FROM adaugare_firma WHERE Nume LIKE '%$var%'")->result();
foreach($query as $q)
{
echo q->Nume;
echo q->Domeniu;
echo q->Subdomeniu;
echo q->produs;
}

and I want to parse those datas in my view form: FormCautareNum .... Can anyone help?