Dear sir,
I mean you have given me a query to display the cb userslist the below is the query.


SELECT
cb_registernumber,
name,
cb_sdob,
cb_semisteryear,
cb_course,
cb_qualification,
cb_gender,
cb_category,
cb_totalfeeksou,
cb_studycentername,
avatar,
C.user_id
FROM
#__comprofiler C INNER JOIN #__users U
ON C.user_id = U.id
WHERE
U.block = 0
AND
U.usertype = 'Registered'

But here it will displays the table of users,
in that if someone clicks on the image,
it should take him to the cb profile of that member.

Thanking you

How link to a user profile looks like?

Regards,
ARI Soft

Dear sir
The below is the sample url link to the cb profiles

localhost/reads/index.php?option=com_comprofiler&Itemid=55

Thanking you

It seems this a common link to CB component, not to a user profile, but you want to use this link, use the following value in "Columns settings -> Format" parameter instead of previous value:

<a href="index.php?option=com_comprofiler&amp;Itemid=55"><img src="images/comprofiler/{$value}" /></a>

Regards,
ARI Soft

Dear sir,
Thank you very much, it is working perfectly,
but it is displaying the big profile images, and instead how to make it to display only thumbnails?

Thanking you

Try the following:

<a href="index.php?option=com_comprofiler&amp;Itemid=55"><img src="images/comprofiler/tn{$value}" /></a>

Regards,
ARI Soft