That is database specific.... no standard SQL.
To make it non specific.
you can put it in a for loop. remember to check for eof.
Rick
At 06:01 PM 3/10/01 -0600, you wrote:
>Select * from table limit 5;
>
>http://www.calevans.com
>
>
>-----Original Message-----
>From: Kath [mailto:[EMAIL PROTECTED]]
>Sent: Saturday, March 10, 2001 6:01 PM
>To: [EMAIL PROTECTED]
>Subject: [PHP] PHP/MySQL Question
>
>
>Having some problems with syntax.
>
>If I wanted to SELECT only 5 instances of something from a database and
>order it by datetime, how would I do that?
>
>- Kath
>
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
##########################################################
# Rick St Jean,
# [EMAIL PROTECTED]
# President of Design Shark,
# http://www.designshark.com/
# Quick Contact: http://www.designshark.com/messaging.ihtml
# Tel: 905-684-2952
##########################################################
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
