Re: Selecting first letter from MySQL entry

Thanks everybody. I didn't know how I should have my SQL syntax. Everything is good now. THANKS!! -- Tyler Longren [Web Development] Premier Visual Services http://www.pvs2000.com On Wed, 9 Aug 2000, stephan.schoell@ch.abb.com wrote: > Date: Wed, 9 Aug 2000 16:51:24 +0200 > To: tyler.longren@midiowa.net > From: stephan.schoell@ch.abb.com > Subject: Re: [PHP] Selecting first letter from MySQL entry > > > > "select * from tbl_names where first like '$letter%';" > > HTH > > --STEFF > > > |-------------> > |(Embedded | > |image moved | > |to file: | > |pic25275.pcx)| > | | > |-------------> > > >------------------------------------------------------------------------| > |Tyler Longren <tyler.longren@midiowa.net> > | > |09.08.2000 16:40 > | > > >------------------------------------------------------------------------| > > > > Please respond to tyler.longren@midiowa.net > > To: PHP-General <php-general@lists.php.net> > cc: (bcc: Stephan Schoell/CHHOS/ABB) > Subject: [PHP] Selecting first letter from MySQL entry > > Security Level:? Internal > > > > Hello everyone, > > I need to be able to select the first letter in a MySQL field. the field > name is first (for first name). There are peoples names listed there. I > have links set up to look like this: > index.php?letter=A > index.php?letter=B > index.php?letter=C > and so on > So when a user clicks on index.php?letter=C it would need to display all > of > the first names that begin with C. > > How do I accomplish this? > > Regards, > -- > Tyler Longren > [Web Development] > Premier Visual Services > http://www.pvs2000.com > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > > > > >