I was trying to create a most recent users list with a filter.

I am using the following SQL command:

SELECT * FROM jos_users WHERE (registerDate + INTERVAL 60 DAY) > 2006-05-10 ORDER BY registerDate DESC LIMIT 0,5

which means I am looking for the most recent 5 users who have registered in the last 60 days and order them by their registration date.

but I'm getting the following error

Warning: Invalid argument supplied for foreach() in ...\components\com_comprofiler\comprofiler.html.php on line 718
User

when I try the following link (my list id is 4):

index.php?option=com_comprofiler&task=usersList&listid=4

the SQL command works fine in phpmyadmin.

What is happening?
Any help welcome.

Ok as you might now know from the other thread I used the info there and aloms all is ok.

The only question I have is: where can I disable the serach box and list all users link from this content list?

Thnx in advance,
Pax

OK I can understand that. I'd rather not do that though! Not for this because I still want that functionality in the lists.

Let me just tell you what I was trying to. It was to get something similar to the random profiles module, but with the most recent ones.

How can I acheive that? Probably by hacking that module eh?

Thnx Nick.