[richy96]

OK once again I sorted all this out for myself - it took me about a week

What I did (if anyone cares which I am starting to wonder) was leave the sql alone so vbulletin reads each member details into $userinfo array as normal using the primary key of userId which is basically in the order they registered

This is running (in the memberlist.php file) through a 'while' loop until it reads all members

In the while loop I placed all the conditional statements I need to reject members who do not meet the search requirement (by using continue; statements to exit the loop)

I then removed the template_hook statement which generates the memberlist_resultbits html from the while loop and replaced it with a statement that adds all the members who meet the search parameters to my own array (called $foundMember) which is basically an array I created to contain all of the $userinfo arrays that met my search parameters

I also removed from the while loop the code which converts the internal vbulletin 'last logged in' date into a readable format - so it was still in seconds since 1970 or whatever vbulletin actually uses (not that I care)

After the while loop ran through all the members, I then sorted the $foundMember array into last logged in order

I then checked how many results there where and if > 301 I set the $memberCount variable to 301 (thus limiting results to 301 of those who matched the search, in order of last logged in)

Then I started a for loop outputting the results

for each iteration I inserted the code I cut from the while loop that converts the last logged in date to readable form

Also in the for loop I inserted the template_hook code that I cut from the while loop that writes the html

And guess what it all worked first time once I fixed a few syntax errors as I have only been coding php for about three months so make silly grammatical errors)

So that is what I did - if it is an inefficient way to solve the problem please anyone who knows better let me know

I've only been programming webpages a few months since I got dumped in the deep end by the last guy I payed to work on my site - and decided to have a go myself but to be honest I feel I am doing this all the hard way.

I don't mean to diss anyone but I am starting to wonder - do I ask the wrong questions (or just plain dumb ones) here as I honestly feel no one ever wants to answer them or help me and some of you must have been programming php and VB for a long time more that 3 months. I am sure I could do better (or at least a lot quicker) with some guidance from the more experienced members here to save me a week or two of studying the problem everytime I want to do something, and it would also save me the embarrassment of having to answer my own threads!!