Try using a query like
select * from table_name where name like '$letter%';
Julia
Quoting Jamie Saunders ([EMAIL PROTECTED]):
> Hi,
>
> I have a MySQL database set-up containing a few hundred records. I'm trying
> to make a script that reads the 'name' field of the records and displays
> only the records of which the name field begins with a specific letter:
>
> if ($letter = A) {
> display all records of which field 'name' beings with A
> } else if ($letter = B) {
> ...
>
> I'm just starting out on this, so please excuse my ignorance :)
>
> Jamie Saunders
> [EMAIL PROTECTED]
>
>
>
> --
> 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]
--
[ Julia Anne Case ] [ Ships are safe inside the harbor, ]
[Programmer at large] [ but is that what ships are really for. ]
[ Admining Linux ] [ To thine own self be true. ]
[ Windows/WindowsNT ] [ Fair is where you take your cows to be judged. ]
PGP signature
