RE: [PHP] php and mysql

I'm not sure what you mean by cut the records at 1/4, if you mean only bringing back 1/4 of the rows you could use the LIMIT clause in your sql statement and give it a number of rows you want brought back. To sort alphabetically just use the order by command in SQL So your query would look like this SELECT * from Table order by column_name Limit 100 This will bring back 100 rows that are order by the column you specify. Kelly -----Original Message----- From: Tyler Durdin [mailto:linuxgeek23@hotmail.com] Sent: February 20, 2003 10:45 AM To: php-general@lists.php.net Subject: [PHP] php and mysql When using a php script to pull recorda from a db how can I cut the records at 1/4 of the total and arrange them alaphabetically according to a certain field? Thanks in advance. _________________________________________________________________ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php