Jump to content

Archived

This topic is now archived and is closed to further replies.

StJames

Mysql Help!

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

to order your rows alphatabetically you will ned to use

 

 

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.