Search Memory

pa pasqualedi 10 Mar, 2010
Hi Bob,
i need this:

I've a search in my chronoconnectivity head.
I write the information i want search and press "Trova"(search).
the serach result list is ok.
Search Memory image 1

But after i press "Trova" all field in my "search" are empty.
Search Memory image 2

Why?

This is my code in Where SQL:
<?php
$search_array = array
('dig','dim','dia','provenienza','cognome','nome','cellulare','telefonofisso','citta','provincia','tipocontratto','tipoazienda','documentazione','ritardi','pignoramenti','protesti','fattibilità','datascegli','daa','agente','dsa','dsmag','dsmam','dsmaa','esito'); 

$where = array();
foreach ( $search_array as $search ) {
$value = JRequest::getVar($search, '' , 'post');
if ( $value ) {
$where[] = " $search LIKE '$value%' ";
}
}
if ( !empty($where) ) {
echo " WHERE ".implode(' AND ', $where);
}?> 

<?php
echo " ORDER BY cf_id DESC ";
?> 

Gr GreyHead 10 Mar, 2010
Hi pasqualedi,

Are you adding the values of those fields (and the others) in the Header box code?

Bob
Gr GreyHead 11 Mar, 2010
Hi pasqualedi,

Hmmm . . . Please post the Header box code here.

Bob
This topic is locked and no more replies can be posted.