Jump to content


Photo

Mysql Help!


  • Please log in to reply
4 replies to this topic

#1 StJames

StJames
  • Members
  • Pip
  • Newbie
  • 2 posts

Posted 22 October 2003 - 12:32 PM

Ok i have a database which consists of

name
num

i want it to sort the name by alphabetical order, but only show the a\'s on one page.. then you can click to go to the b\'s. or the z\'s and so forth. Do you put that in your mysql query? Or what? Please HELP!

James
James, [br](Velocity Designs)

#2 effigy

effigy
  • Staff Alumni
  • Advanced Member
  • 3,600 posts
  • LocationIL

Posted 22 October 2003 - 04:24 PM

look into the pagination tutorials and use the numbers to base your search. for example:

if page 1: search for name like \'a%\'
if page 2: search for name like \'b%\'
Regexp | Unicode Article | Letter Database
/\A(e)?((1)?ff(?:(?:ig)?y)?|f(?:ig)?)\z/

#3 sir nitr0z

sir nitr0z
  • Members
  • Pip
  • Newbie
  • 5 posts
  • LocationDevon, UK

Posted 22 October 2003 - 09:04 PM

to order your rows alphatabetically you will ned to use


$sql = \'ALTER TABLE `tablename` ORDER BY `name` \';

#4 StJames

StJames
  • Members
  • Pip
  • Newbie
  • 2 posts

Posted 22 October 2003 - 10:30 PM

hrmm, could you give me an example(code) on how to print all of that?
James, [br](Velocity Designs)

#5 sir nitr0z

sir nitr0z
  • Members
  • Pip
  • Newbie
  • 5 posts
  • LocationDevon, UK

Posted 23 October 2003 - 11:14 AM

unfortunately i cant, however it should be quite simple.
first you would need to examine the string for each name and determine the first character.

if that sounds like alot of work then just make a new column in the database and put the first letter of each name in it. then u can use the query

[php:1:1a7169a4f9]<?php
$query = SELECT * WHERE startletter LIKE \'$letteryouwanttodisplay%\'
?>[/php:1:1a7169a4f9]

play around with those ideas and see what you get.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users