Member Avatar for namit

I have a databse in mysql and am looking to select the last 5 values in the database and there contence. How would i do this.

Will be using php to do this.

Thanks

There is an incramenting variable called Id and could use that if possible.

  • 3 Contributors
  • 2 Replies
  • 104 Views
  • 4 Weeks Discussion Span
  • Latest Post Latest Post by paradox814
Member Avatar for Phaelax

I think this will work. I'm not positive if TOP is in MySQL.

SELECT TOP 5 *
FROM table
ORDER BY id DESC

(assuming 'id' is the primary key in the table)

Member Avatar for paradox814

you might also want to put LIMIT 5 on there at the very end to just retrieve the last 5 results

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.