how can i get mysql results with alphabetical pagination

Question

how can i get mysql results with alphabetical pagination i.e i have 2 fields i.e id and name in mysql table and following html links for pagination

A B C D E F G .......

by clicking on A i want to get results names starting with A

how can i do that with php

Numerous duplicates: http://stackoverflow.com/search?q=php+pagination — Pekka, Oct 21 '10 at 20:57
Possible duplicate of http://stackoverflow.com/questions/2280230/searching-for-advanced-php-mysql-pagination-script — Pekka, Oct 21 '10 at 20:58

score 3 · Accepted Answer · answered Oct 21 '10 at 20:58

3

Use SQL LIKE syntax:

SELECT * FROM tablename WHERE name LIKE 'A%'

answered Oct 21 '10 at 20:58

Jacob Relkin

That query wouldn't return results that start with A, but those that end with A. so: SELECT * FROM tablename WHERE name LIKE 'A%' – james_bond Oct 21 '10 at 21:00
Yes I saw it but I hitted 'Add comment' before seeing it – james_bond Oct 21 '10 at 22:32

score 1 · Answer 2 · answered Oct 21 '10 at 21:00

1

Use a query like

SELECT `id`, `name` FROM `table` WHERE `name` LIKE :index

Then, bind :index to something like sprintf('%s%%', $selectedIndex)

It would also be a good idea to create an index on the name column.

answered Oct 21 '10 at 21:00

Phil

2 Answers2