At 01:48 AM 1/8/02 +1300, Barry Rumsey wrote:

>I would like to set up one of those " A B C D E F " page listings. How do 
>i query the database to grab the first letter from each entrey.

Barry try something such as

select info from mytab
where name like "$ltr%";

Marty


Website Creation Made SIMPL(tm)
http://face2interface.com/Home/Demo.shtml
WebSafe Color Picker -- http://face2interface.com/WebSafe


-- 
PHP Database 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]

Reply via email to