this should do the trick: SELECT MAX(field) from table
you have to use MAX to get the highest value in field. Michael "Jason Wong" <[EMAIL PROTECTED]> schrieb im Newsbeitrag news:[EMAIL PROTECTED]... > On Friday 05 April 2002 18:27, Hawk wrote: > > Lets say I have a guestbook, and that I only want to show the last entry on > > my first page > > I cant figure out a good way to do it.. > > haven't managed to find a mysql command that can do it either, but maybe > > there are? :) > > The only reliable way to do it is to have a field in your guestbook table > which records the time that the entry was made. Then you can: > > > SELECT * FROM guestbook ORDER BY time_entered LIMIT 1 > > I have set follow-up to [EMAIL PROTECTED] where this belongs. > > > -- > Jason Wong -> Gremlins Associates -> www.gremlins.com.hk > > /* > If there is any realistic deterrent to marriage, it's the fact that you > can't afford divorce. > -- Jack Nicholson > */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
