[SOLVED] 4 newest members

[daveoffy]

On the index page I want it to display the 4 newest members (find out by member_id in `members`)

 

I just need to know the outline like if(x <=3){ } or whatever the code is but don't need any echos or anything and I can figure it out from there.

[ILMV]

SELECT * FROM members LIMIT 4 ORDER BY date_registered ASC

 

You need to use a query like this, I cannot remember is it is ASC of DESC, but try both

 

ILMV

[daveoffy]

SELECT * FROM members LIMIT 4 ORDER BY date_registered ASC

 

You need to use a query like this, I cannot remember is it is ASC of DESC, but try both

 

ILMV

I am 98% sure it is DESC. Thanks I will try this in like 1 second.

[daveoffy]

I had to do this instead because the other one wouldn't work

 

SELECT * FROM members ORDER BY date_registered DESC LIMIT 4

 

[ILMV]

Fair point!

 

Happy Christmas