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

Reply via email to