Re: MYSQL: Last record [Q and A] - XOOPS Web Application System

XOOPS

Forum

Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk

MYSQL: Last record

2003/11/14 15:35
EyeKeeper
Quite a regular
Posts: 209
Since: 2002/6/11

Hi folks,

how can I retrieve the last record of a table...
I tried to get it through max_id(var) and since it didn?t work I tried DESC LIMIT 1... but it didn?t work either...
thanks

Re: MYSQL: Last record

2003/11/14 16:35
ackbarr
Posts: 1449
Since: 2002/10/2

If it is a numerical id how about using:


SELECT MAX(ID_Field) as LastRecord FROM My_Table

Re: MYSQL: Last record

2003/11/14 17:36
EyeKeeper
Quite a regular
Posts: 209
Since: 2002/6/11

thanks ackbarr...
I?ve re-written the sql instruction to suite my needs...
in fact I wanted to get the whole row...
but I got it going...

Login

Username

Password

Remember me

Search

Advanced Search

Donat-O-Meter

Stats
Goal:	$100.00
Due Date:	May 31
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}

{{ record.commit.author.name }} {{ record.commit.author.date | formatDate }}

MYSQL: Last record

Re: MYSQL: Last record

Re: MYSQL: Last record

Login

Search

Recent Posts

Re: Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

Re: NewBB v 5.1.0 b 6

Re: NewBB v 5.1.0 b 6

NewBB v 5.1.0 b 6

Re: XOOPS 2.5.11 search user is not working

Re: oledrion

Re: oledrion

Re: oledrion

Re: oledrion

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}