View Full Version : List information alphabetically, etc?


dolce shanti
06-13-2004, 08:29 PM
Hello all! I have a question. I am creating a subpage called "My Library," In which, as you would guess, I will be listing the books that I have on my bookshelf here at home. It also will include my review of the book, the copyright date, and a rating. (1-5 flowers!) I want visitors to be able to view information by title, copyright date, and rating. Is there an easier way to do this, other than manually adding a book to the each list every time I want to add a new one? It seems like there would be a code to make this project easier.

Thank you for all your help!

Shirl
06-13-2004, 08:30 PM
Yeah I know there is some way to do it, I've heard of it before, but unfortunately I am not the best person to ask:)

dolce shanti
06-13-2004, 08:36 PM
Do you know one would use HTML, php, or something else? It seems to me that one would use php...however, I don't have much php knowledge and would appreciate a much easier way! :)

pb&j
06-14-2004, 05:09 AM
PHP would be a good start.
PHP combined with a MySQL database would be best.
or if you want to get a bit technical and go with XML coding, that could work too.

either which way, it may take a bit of time to learn.

dolce shanti
06-14-2004, 07:03 PM
Ok...I have begun a mySQL database...you can see it at http://www.bradburn-family.com/hi.php (lousy file name...I was in a hurry!)

That's a start. What I want is for a user to click on "Title," which is the first, and have it automatically alphabetize it for me. Is there any way to do that? Afterwards, I will also try to do the same with the copyright dates, and make the ascending numbers.

Thank you!

pb&j
06-14-2004, 08:29 PM
if you have the data in a database, you can sort the information like so...

SELECT * FROM tablename ORDER BY fieldname;

during a link click, pass a variable information to represent which field name to be used during the SELECT process.

dolce shanti
06-15-2004, 12:47 PM
Thank you so much for all your help! You can see the almost finished product here....I still have to add a few books though :)

http://www.bradburn-family.com/library/hi.php

pb&j
06-15-2004, 02:24 PM
good work.