Hey guys
how I can show the ccv table without results? And when i click the search button show the data?
Thanks for all
how I can show the ccv table without results? And when i click the search button show the data?
Thanks for all
Hi PopKorn,
You set the WHERE setting to show the empty list if there is no search set. Essentially you want to check for your search value and, if that isn't set make the WHERE clause return no records by setting it to say WHERE 1 = 2
Bob
You set the WHERE setting to show the empty list if there is no search set. Essentially you want to check for your search value and, if that isn't set make the WHERE clause return no records by setting it to say WHERE 1 = 2
Bob
Hi bob.
Thanks for this fast reply
I have this in WHERE SQL
Can you show me how i do this?Today I can not get anything to work
Thanks
Thanks for this fast reply
I have this in WHERE SQL
<?php
$title = JRequest::getString('title', '', 'post');
$pepito= JRequest::getString('otro', '', 'post');
$nom= JRequest::getString('nom', '', 'post');
$fecha= JRequest::getString('fecha', '', 'post');
$esta= JRequest::getString('esta', '', 'post');
if ( $pepito ) {
echo " `cf_objeto` LIKE '%$title%' and `cf_tienda` LIKE '%$pepito%' and `cf_fecha` LIKE '%$fecha%' and `cf_nombre` LIKE '%$nom%' and `input_checkbox_group_11` LIKE '%$esta%' ";
}
?>
Can you show me how i do this?Today I can not get anything to work
Thanks
Hi Popkorn,
. . .
if ( $pepito ) {
echo " `cf_objeto` LIKE '%$title%' and `cf_tienda` LIKE '%$pepito%' and `cf_fecha` LIKE '%$fecha%' and `cf_nombre` LIKE '%$nom%' and `input_checkbox_group_11` LIKE '%$esta%' ";
} else {
echo ' 1 = 2 ';
}
This topic is locked and no more replies can be posted.