Is there an easier way?

[grudz]

Hi,

I was wondering if anybody had any ideas how to structure this. I have a list of records that can be sorted by name, however, i want to put # - A -B - C - D - E.... etc... (all the letters of the alphabet) so that if the user clicks on "C" it shows everything the starts with "C", now my idea (but i dont think its the best way) was to have a $_GET for all the letters, like i said, does anybody have an easier way?

Thank you in advance

[piz]

If I understood you correctly, I would do it this way, too.

[newmand2]

Your way sounds simpler than mine, if it was in a database could your query be

SELECT * FROM table WHERE beginningletter = $_GET[letter]

[Celtboy]

<?php
$table = "bob";
$fieldname = "hello";
$sql = "SELECT * FROM $table WHERE $fieldname LIKE '" . $_GET["letter"] ."%'";
?>

sample link:

..<a href="script.php?letter=B>B</a>--<a href="script.php?letter=C">C</a>--<a href="script.php?letter=D>D</a>--...

i think that will work.

[Celtboy]

oh...where/how are the records stored?

[mordred]

If writing the links by hand seems cumbersome, you might consider generating them by a script:

$letters = range('A', 'Z');
for ($i = 0; $i < count($letters); $i++) {
    print ' <a href="page.php?letter=' . $letters[$i] . '">' . $letters[$i] . '</a> -';
} 

[grudz]

what if i want to add a "#" for other things....will it complicated things?

[mordred]

Not really. You just have to sort-of inverse the select statement:

SELECT fields FROM records WHERE field NOT RLIKE "^[a-z]";

[grudz]

how about saying, LIKE 'numbers'

is there something i can write so that it understands that it means numbers? instead of writting NOT LIKE.......cuz im getting problems on getting it to work

[grudz]

don't worry, i figured out a way, and i solved my inital problem, thanx for the help