mysql - select data From database in php sort by last enter first select -

i trying fetch data database, , sort last enter , first fetch.

its means suppose enter

third time add :- hari

second time add :- nikh22

first time add :- 234ram

now want fetch data sort last enter first select

hari

nikhil22

234ram

by default selecting data name, please tell me do

for selecting data used

mysql_query ("select * nikhil userid='$pid'");

if have datetime or timestamp column in nikhil table can order column in descending order

select *   nikhil  userid = ?  order datetime desc

here sqlfiddle demo

Detect