Dictionary type db

[Anon]

Heya,

I'm creating a dictionary "type" section for a site. It will work simply :

Dictionary item - Definition

The table I have made for this is :

ID (autoincrement)
Item
Definition

Adding, deleting, editing data is fine and works without a hitch.

My Problem is how to return the results.

It would be hugely beneficial if I could create a page per letter of the alphabet. Is that even possible ? Any ideas how ?

When I do a simple query listing all the data in the db it comes out alphabetically by ordering by Item, but I don't know how to seperate things up.

Any ideas who be hugely appreciated :-)

Thanks

[Anon]

To create a page for each letter in the alphabet, do a simple SELECT query with a WHERE clause in it.

SELECT * from table WHERE Item like 'a%'

This will return all rows with an Item field that begin with the character a.

Instead of creating a page for each letter in the alphabet, maybe have a select list the user can choose from and build your SELECT query based on what the user chooses.

<select name="letter">
<option value="a">a<option>
<option value="b">b<option>
<option value="c">c<option>
</select>

Then build your query like this ...

SELECT * from table WHERE Item like '$letter%'

[Anon]

David R,

That is EXACTLY what I was after !!

Thankyou so much :-)