alphabetical filter

[genu]

How to I have it so when I fetch the database, it displays only results starting with a certain letter, and also show the "next" button if th results starting with that letter exceed 30 items?

[hostfreak]

For the letter you could do something like:

[code]
$letter = "A";
$query = "SELECT * FROM table WHERE field LIKE '$letter%'";
[/code]

Per query or do something like:

[code]
$letter = $_GET['letter'];
$query = "SELECT * FROM table WHERE field LIKE '$letter%'";
[/code]

And in your url have: http://www.domain.com/page.php?letter=A Or whatever the letter you want.

On the 30 items per page, you need to look into pagination.