Mysql Help!

[StJames]

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

[effigy]

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%\'

[sir nitr0z]

to order your rows alphatabetically you will ned to use

 

 

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

[StJames]

hrmm, could you give me an example(code) on how to print all of that?

[sir nitr0z]

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.