The Resource For PHP Developers

Next message: 1LT John W. Holmes: "Re: [PHP] small ads system"
Previous message: Lowell Allen: "Re: [PHP] Re: session expiration"
In reply to: Simon: "[PHP] list &quot;a&quot;, list &quot;b&quot; ...etc"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Re: [PHP] list "a", list "b" ...etc From: 1LT John W. Holmes (holmes072000 <email protected>)
Date: 02/21/03

> how can i sort names by first letter, like, show only names starting
> with a, then b, c .. etc

Where is the data? In an array? database? file?

If it's a database, then you can just do

SELECT * FROM table WHERE column LIKE 'a%'
or
SELECT * FROM table WHERE LEFT(column,1) = 'a'

---John Holmes...

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php