NEED HELP... selecting the last record from a table

[ares666]

Hello all,

This is my problem:
I have a table with all kinds of fields, a table from a post-nuke Content Management System.(post_sories)

I cant seem to find the syntax for an MySQL instruction, that of selecting the last record inserted into this table.

There are some auto incrementing fields, and I don't know how to write the SELECT statement in order for it to retrieve only the last piece of information from the table.

Could anybody help me please?

Thank you in advance.

 

[swampBoogie]

select * from postNukeTable
order by autoIncementColumn desc
limit 1

 

[ares666]

Thank you very much...

IT WORKED!!!

u got my vote.

 

[tshot]

ares666 here vote means star for swampBoogie where is it ? to mark just check at the bottom of swampBoogie's reply to yr query




----------------
ur feedback is a very welcome desire