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