PHP Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 



Go Back   Dev Articles Community ForumsProgrammingPHP Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old July 9th, 2002, 06:11 PM
adrian adrian is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jul 2002
Posts: 20 adrian User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
php sort by letter

Is there any way with php you can view records in a mysql database table that begin with a given letter. i would like to be able to put an html dropdown box form with all the letters of the alphabet in and when someone selects a given letter then only records which begin with that letter will be displayed.

I need this as i don't want to be displaying 10,000 or so records and making someone scroll down because my list is sorted alphabetically and they want a record beginning with the letter v. Enableing then to just click on the letter v and just having the records beginning with v show up would be much more practical.

Reply With Quote
  #2  
Old July 9th, 2002, 07:23 PM
Lindset Lindset is offline
weirdomoderator
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jun 2002
Location: Alta, Norway
Posts: 370 Lindset User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 16
Send a message via ICQ to Lindset Send a message via AIM to Lindset
This could be done through the mysql query by using the LIKE statement, and wildcards

SELECT col FROM table WHERE col LIKE 'v%'

In MySQL, the % char is the wildcard..
Hope that suits your needs
__________________
Best Regards,
Håvard Lindset

Reply With Quote
  #3  
Old July 9th, 2002, 08:15 PM
adrian adrian is offline
Registered User
Dev Articles Newbie (0 - 499 posts)
 
Join Date: Jul 2002
Posts: 20 adrian User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
thanks loads lindset, i'd tried it with WHERE col LIKE '%v%' which was basically selecting every record with a letter v in it. just removing the front % like your example has sorted it for me.
Thanks again.

Reply With Quote
Reply

Viewing: Dev Articles Community ForumsProgrammingPHP Development > php sort by letter


Developer Shed Advertisers and Affiliates


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump

Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 


Powered by: vBulletin Version 3.0.5
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.

© 2003-2018 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap