Organizing by letters

[Anon]

Hi, I have a MySQL data base of things. I want to organize them into separate pages though. (ie: 0 - 9, a - g, h - n, - o - u, v - z).

Now I have it setup so the user choose what category it goes into (ie: a - g), i'm sure that makes things easier. I would like it to be something like:
maps.php?page=a-g

then it would only show the info that is in the category a - g...

Does any one know of a way to do this?

[Anon]

something like this maybe?

list($from, $to) = split('-', $_GET['page'], 2);

$query = "SELECT * FROM tbl WHERE field > '$from' AND field < '$to'";

Then run the query.

Make sure to do error checking on the input and stuff.

HTH,

Diego

[Anon]

humm, that doesn't work anyone know of anything else?