events timetable

[Joshie]

how do I like make it in order by time so it shows
12
1
2
3

instead of
12
4
13
17

 

[Janzeer]

If the events are fetched from database use the 'ORDER BY' function.

 

[JayC]

If the events are fetched from database use the 'ORDER BY' function.

You will want to do either:

SELECT * FROM events ORDER BY timestamp ASC
Which makes the outcome this:
2
5
7
OR
SELECT * FROM events ORDER BY timestamp DESC
Which makes the outcome this:
7
5
2

Make sure you add "LIMIT 10" or however many you want at the end of the statement:
SELECT * FROM events ORDER BY timestamp DESC LIMIT 10
and if you would like to keep track of all your events that are active/past events then have a column in the events table like "active" and do this:
active int 11 0 NOT NULL default 1

SELECT * FROM events WHERE `active` = '1' ORDER BY timestamp DESC LIMIT 1

 

[Joshie]

I want them in order by latest time to shortest time
12
1
2
3
4
5

 

[JayC]

I want them in order by latest time to shortest time
12
1
2
3
4
5

Then read my post and do the statement you need, I already gave you both answers. Come on dude.