Some questions ...

[Francky683]

Sup yall,
I've got some questions that i searched on the net but didn't find anything ...

First i wanted to know how i could take the latest member registered and display it ... (my time format is 'd-m-Y h:i A') ...

Secondly, in my registration form i'm asking if the members are in a clan ... i've made a page where i display all the clans in my DB but is it possible to only have 1 time each clan ??? not have like 2 times the clan "]CiP[`" in my list ...

Third, is it possible to make my page auto-refresh itself like every 30 secs ???

Thanks a lot,

~Francky683~

[LordShryku]

1) Select from DB, Order By timestamp DESC, LIMIT 1.

2) SELECT DISTINCT clan FROM table

3) <meta http-equiv="Refresh" content="30 url=pagename.php">