Justtechjobs.com Find a programming school near you






Online Campus Both


php-general | 2001062

Re: [PHP] reading records alphebetically From: Julia A. Case (julie <email protected>)
Date: 06/30/01

Try using a query like

select * from table_name where name like '$letter%';

Julia

Quoting Jamie Saunders (jamie.s <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
> jamie.s <email protected>
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe <email protected>
> For additional commands, e-mail: php-general-help <email protected>
> To contact the list administrators, e-mail: php-list-admin <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. ]
  • application/pgp-signature attachment: stored