Book Catalog Help

[Anon]

Hello to all:

As a relative novice to PHP I would like to know if anyone can help me.

I would like to create a small catalog of my personal book collection (lets say about 10 -20 books). I have created a text book and intend to allow the user to do a keyword search. A successful search will echo author, title, publisher, etc..

I was thinking of doing an IF/Else script with Boolean terms to catch all keywords.

This may be the wrong way. Is there a database function that I could use and perhaps create a simple, searchable database?

Thanks for any help!!

Vincent.

[Anon]

IF you're using MySQL database, you can use LIKE to find keywords:

e.g.

SELECT author, title, publisher, etc FROM catalog WHERE title LIKE "%PHP%"

And that will return any books that have "PHP" in the title. The '%' signs are called wildcards, and this particular wildcard matches anything.

Diego