Newest REGISTERED member in forumhome.

[MacMorag]

Nearly there -

The first solution doesn't work. It just leaves a blank space where the newuser name should appear in the "board stats".

The second solution does work. Well almost. There was an error in the select statement you gave - specifically "(3,4,8) DESC LIMIT 1". So I filled in the blanks, but obviously not correctly.

I used "(3,4,8) ORDER BY userid DESC LIMIT 1, 1" - and results are a bit out, but going in the right direction.

What happens:

UserA is the existing member name displayed in the board stats.

I create UserB. Before I verify the email, UserA is still displayed as the newest member. Great.

I follow the link in the "verify email" - but UserA is still listed as the newest member. Not so good - it should say UserB.

I create another user, UserC. Before I verify, UserA is still listed as newest member. This is good (apart from the fact that it is UserA displayed and not UserB). There has been no change. As wanted.

Once I follow the link in the email, what should happen is that UserC is now displayed as the newest member. But no.

UserB(!) is displayed.

Repeat the process, and UserC is displayed.

So it is working. It's just displaying the newest member(-1).

As I said, this is probably due to me completing the SELECT statement wrongly. But it looks OK - I'm retrieving just one row, which contains the highest userid.

Any ideas what's wrong here?

Thanks again