In a recent project, one task involved returning the unique first letter of the data held in a MySQL field in order to provide hyperlink navigation through the web-site as opposed to a drop down menu.
This was accomplished using the MySQL statement below;
SELECT DISTINCT (left( [field], 1 ) )FROM `[table]` ORDER BY [field]
Providing Computer Help and Support to business in and around Hastings, St Leonards, Battle and Bexhill, East Sussex. Also has a few snippets of random things.
Subscribe to:
Post Comments (Atom)
Labels
mysql
php
hastings
hastings musical festival
laptop
website
east Sussex
hastings music festival
Windows XP
blog
computer support
design
directory
dns
failure
findapro
hewlett packard
internet provider
javascript
music
printer
racing tips
samphire
security
virus
vpn
zen cart
.htaccess
1066
A3 Prints
B A C Productions
Ben
G70-111EM
HP
access
accounting
accounts
adsense
advertising
ajax
anti-virus
anyone there
attribute
backlink
betting
bird
brighton
building
cat5
cms
coding
collaboration
components
content
content management
control-alt-delete
database
decisions
defrag
denial of service
disaster
disk drives
dj
dos
ds
ebay
electrofied
email
error 39
extension
feeding
filename
fragmentation
free
fstab
garden
google
hardware
hastings rock
hello
hmf
hoax
lan
life is beautiful
link
linux
mac
mail
memory
migration
missing CD
mod_rewrite
multidimensional
network
nintendo
off-site
password
phpnuke
power
pricing
procedure
programme
protection
proxy
quickbooks
ranking
recovery
registry
repair
revenue
ribbon cable
router
routing
roy penfold
sage
seo
server
shutdown
slow
slugs
smoke
snopes
spam
spamassassin
squid
st leonards
streetview
substitution
supply
surge
symantec
telephone
telephone stats
trading standards
trojan
turbocash
variable
wan
web design
web hosting
web site
web sites
website design
wildlife
wiring
zencart
No comments:
Post a Comment