Forums

Last entry at top

thefrobel 16 Jul, 2015
Anyone have the code and know where to put it to get the fields to show up with the last entry at the top?

Column Lists: (what shows)
adddb1.text1:First Name
adddb1.text2:Last Name
adddb1.text3:Email
adddb1.text4:Player ID

this is my database setup:
1 id int(11) No None AUTO_INCREMENT Primary Primary
2 uniq_id varchar(50) utf8_general_ci No None
3 user_id int(11) No None
4 created datetime No 0000-00-00 00:00:00
5 modified datetime Yes NULL
6 text1 varchar(255) utf8_general_ci No None
7 text2 varchar(255) utf8_general_ci No None
8 text3 varchar(255) utf8_general_ci No None Unique Unique
9 text4 varchar(255) utf8_general_ci No None Unique Unique
10 button5 varchar(255) utf8_general_ci No None

I would like it to always show by ID DESC, without having it be visible.
GreyHead 16 Jul, 2015
Hi thefroebel,

Have you tried the Order box? I'm not sure if that requires the ID to be shown, if it does you can hide the column with CSS.

Bob
thefrobel 16 Jul, 2015
what is the syntax for that box?

adddb1.id (how do make it desc?)
GreyHead 17 Jul, 2015
Hi thefroebel,

I'd turn the debugger on and try adddb1.id DESC to see if that works.

Bob
thefrobel 17 Jul, 2015
I had it in the wrong section. adddb1.id DESC works in the Ordering section.
This topic is locked and no more replies can be posted.