select the last register

[Guest Seph]

Good Monring people!I'm in a infinty looping, and to resolv this i must select only the last register of my database, ho can i do this?Thanks

[pulpfiction]

SQL = "SELECT * FROM TBL_NAMESet RS = Server.CreateObject("ADODB.Recordset")RS.Open SQL, MyConn RS.MOVELAST 'This will take you to the last record of the recordset I guess this is what you are looking for.. HTH

[Yahweh]

SQL = "SELECT * FROM TBL_NAMESet RS = Server.CreateObject("ADODB.Recordset")RS.Open SQL, MyConn RS.MOVELAST         'This will take you to the last record of the recordset I guess this is what you are looking for.. HTH

<{POST_SNAPBACK}>

That's a bad way to select the last registered user, because it causes MySQL to cache all of the records in the database, when it only makes use of a single record.A better SQL statement is:

Select * From Your_TABLE ORDER BY ID Desc Limit 1

Basically, this just reverses the order the table and selects one record, its much faster, doesn't require MySQL to cache all the data in the table, and doesn't require an "RS.Movelast" line.

[pulpfiction]

What Seph wants is to select the last register, but when you order the last register may be different from the actual one. correct me if i am wrong.

[Yahweh]

What Seph wants is to select the last register, but when you order the last register may be different from the actual one. correct me if i am wrong.

<{POST_SNAPBACK}>

It could only do that if he orders his list by something other than the unique ID of his users (such as ordering them by name).But if Seph is anything like me, he most likely has a uniqueID assigned to each record that increases by 1 for each record. Then the newest user is the one with the largest ID, and ordering by "ID DESC Limit 1" automatically selects the single record with the largest ID.