take a look at this code
$query_user="select count(id) as total,id,firstname,middlename,lastname,cb_addressline1,cb_addressline2,cb_addressline3,cb_addressline4,cb_postcode,cb_telephone from #__comprofiler where id LIKE'%$find%' or firstname LIKE'%$find%' or lastname LIKE'%$find%' or cb_telephone LIKE'%$find%' or cb_addressline1 LIKE'%$find%' or cb_addressline2 LIKE'%$find%' or cb_addressline3 LIKE'%$find%' or cb_addressline4 LIKE'%$find%'";
$db->setQuery($query_user);
$listdata = $db->loadObjectList();
//print_r($listdata);
if($listdata[0]->total==0)
{
you'll notice that 'count(id) as total ' is being used to count the results . However using count() in this way was makiing my results only return 1 row. Take a look at this post http://stackoverflow.com/questions/4082713/mysql-returns-only-one-row-when-using-count
So I've now replaced the query for
[code]
$query_user="select id,firstname,middlename,lastname,cb_addressline1,cb_addressline2,cb_addressline3,cb_addressline4,cb_postcode,cb_telephone, (select count(*) FROM #__comprofiler WHERE id LIKE'%$find%' or firstname LIKE'%$find%' or lastname LIKE'%$find%' or cb_telephone LIKE'%$find%' or cb_addressline1 LIKE'%$find%' or cb_addressline2 LIKE'%$find%' or cb_addressline3 LIKE'%$find%' or cb_addressline4 LIKE'%$find%') as total from #__comprofiler where id LIKE'%$find%' or firstname LIKE'%$find%' or lastname LIKE'%$find%' or cb_telephone LIKE'%$find%' or cb_addressline1 LIKE'%$find%' or cb_addressline2 LIKE'%$find%' or cb_addressline3 LIKE'%$find%' or cb_addressline4 LIKE'%$find%'";
[/code]
I then got an error with $listdata[0]->total==0
after testing the object $listdata - as I noticed if the search was empty then I changed the line.
f($listdata[0]->total==0 )
to
if($listdata == NULL )
So we don't need to use SELECT count(*) as total - at all . is it enough just to test the search to see if its NULL.
Which is much simplier
$query_user="select count(id) as total,id,firstname,middlename,lastname,cb_addressline1,cb_addressline2,cb_addressline3,cb_addressline4,cb_postcode,cb_telephone from #__comprofiler where id LIKE'%$find%' or firstname LIKE'%$find%' or lastname LIKE'%$find%' or cb_telephone LIKE'%$find%' or cb_addressline1 LIKE'%$find%' or cb_addressline2 LIKE'%$find%' or cb_addressline3 LIKE'%$find%' or cb_addressline4 LIKE'%$find%'";
$db->setQuery($query_user);
$listdata = $db->loadObjectList();
//print_r($listdata);
if($listdata[0]->total==0)
{
you'll notice that 'count(id) as total ' is being used to count the results . However using count() in this way was makiing my results only return 1 row. Take a look at this post http://stackoverflow.com/questions/4082713/mysql-returns-only-one-row-when-using-count
So I've now replaced the query for
[code]
$query_user="select id,firstname,middlename,lastname,cb_addressline1,cb_addressline2,cb_addressline3,cb_addressline4,cb_postcode,cb_telephone, (select count(*) FROM #__comprofiler WHERE id LIKE'%$find%' or firstname LIKE'%$find%' or lastname LIKE'%$find%' or cb_telephone LIKE'%$find%' or cb_addressline1 LIKE'%$find%' or cb_addressline2 LIKE'%$find%' or cb_addressline3 LIKE'%$find%' or cb_addressline4 LIKE'%$find%') as total from #__comprofiler where id LIKE'%$find%' or firstname LIKE'%$find%' or lastname LIKE'%$find%' or cb_telephone LIKE'%$find%' or cb_addressline1 LIKE'%$find%' or cb_addressline2 LIKE'%$find%' or cb_addressline3 LIKE'%$find%' or cb_addressline4 LIKE'%$find%'";
[/code]
I then got an error with $listdata[0]->total==0
after testing the object $listdata - as I noticed if the search was empty then I changed the line.
f($listdata[0]->total==0 )
to
if($listdata == NULL )
So we don't need to use SELECT count(*) as total - at all . is it enough just to test the search to see if its NULL.
Which is much simplier
