OZONE Asylum
Forums
Server-Side Scripting - Oh my!
Sort by last name (PHP - MySQL)
This page's ID:
28658
Search
QuickChanges
Forums
FAQ
Archives
Register
Edit Post
Who can edit a post?
The poster and administrators may edit a post. The poster can only edit it for a short while after the initial post.
Your User Name:
Your Password:
Login Options:
Remember Me On This Computer
Your Text:
Insert Slimies »
Insert UBB Code »
Close
Last Tag
|
All Tags
UBB Help
something along these lines - "SELECT * FROM contact WHERE location = 'Greensboro' and lastname like A% ORDER BY lastname ASC"; Use variables to avoid using 26 additional cases ;) Before each query, check if a location is set, check if a letter is set. For both the locations and the letters, use a variable. Use your case statements to set up your queries based on whether you have 1) the location set but not the letter, 2) the letter set but not the location, and 3) both the letter and the location set.
Loading...
Options:
Enable Slimies
Enable Linkwords
« Backwards
—
Onwards »
Maximum Security
OZONE
DHTML/Javascript
Server-Side Scripting - Oh my!
CSS - DOM - XHTML - XML - XSL - XSLT
Stupid Basic HTML
Visual Therapy
Photoshop
Photoshop Pong, Anyone?
***WARNING*** BIG SIG APPROACHING
Photography
3D Modelling & Rendering
Multimedia/Animation
Print Graphics
Holding Pens
Philosophy and other Silliness
Outpatient Counseling
Site reviews!
Mad Scientists' Laboratory
Getting to know the Grail