What should I do to sort 3 items ?

[desprits]

What should I do to sort 3 items in a dataBase?
For exemple :
Zoro 5 Fev 18:20
Zoro 5 Fev 17:25
Amanda 5 Fev 21:40
Jack 6 Fev 19.30
Amanda 7 Fev 03:22

Me I would like to have the result :
Amanda 5 Fev 21:40
Amanda 7 Fev 03:22
Jack 6 Fev 19:30
Zoro 5 Fev 17:25
Zoro 5 Fev 18:20

 

[koala15]

Use "Order By" in the SQL statement.

"Life is full of learning, and then there is wisdom"

 

[desprits]

How should I do that, I don't know realy well SQL statement ..?

 

[koala15]

Hi,

- With respect to SQL there are tons of web sites that give SQL tutorials, but and SQL statement goes like this:

SELECT item1, item2 .....
FROM tablename
WHERE item1 = ?????
ORDER BY item1, item2

- but, how are you extracting the data from the DB?

"Life is full of learning, and then there is wisdom"

 

[mmilan]

Have a look at

http://www.w3schools.com

for a good tutorial.

mmilan.