Posted 22 October 2003 - 12:32 PM
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!
Posted 22 October 2003 - 09:04 PM
$sql = \'ALTER TABLE `tablename` ORDER BY `name` \';
Posted 22 October 2003 - 10:30 PM
Posted 23 October 2003 - 11:14 AM
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
$query = SELECT * WHERE startletter LIKE \'$letteryouwanttodisplay%\'
play around with those ideas and see what you get.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users