Howdy! Welcome to our community of more than 130.000 members devoted to web hosting. This is a great place to get special offers from web hosts and post your own requests or ads. To start posting sign up here. Cheers! /Peo, FreeWebSpace.net

managed wordpress hosting

mysql help

Thread starter harrylmh
Start date Aug 23, 2002

H

harrylmh

New Member

Aug 23, 2002

#1

Hi,

could someone tell me what's the statement to get only the 5 latest records by date?

Thanks

G

Ganon of Evil

New Member

Aug 23, 2002

#2

"SELECT * FROM yourtable ORDER BY time DESC LIMIT 5"

The time variable must be a unix timestamp (which is a number).

H

harrylmh

New Member

Aug 24, 2002

#3

thank you

You must log in or register to reply here.

Share:

Facebook X (Twitter) Reddit Pinterest Tumblr WhatsApp Email Link

Top