PHP Searching Database

Anon

Im not quiet sure how to word this so ill give you the example of what im trying to do.

A user selects a catagory for their site (dogs) . And it goes in our mySQL db and looks like the table keywords and trys to match 'dogs' with what is there. There is a keyword Dogs and Cats. I want it to return that as the variable.

Can it be done?

Nick

Anon

i am not very clear of what you mean, but if you want to do simple search in your DB, then why not use LIKE in your SQL query?

e.g.
SELECT * FROM dogs WHERE field_name LIKE '$keyword';

Anon

Dear PHP Wizards,

I am looking for the example for the " PHP codes " for reading, writing, editing and deleting the appointment calendar.

1) I should be able to write into the diary selecting the date and particular time of the day.

2) The display should be weekwise, while able to shift from one week to another and know which day has the appointment written on it with indication of whether it is in morning or noon ar afternoon.

3) There should be no clashes of the appointments on the same time.

4)Allow notes to be added to an appointment using file upload.

Please send me the URLs " also " where i can see some example of similar nature.

Thanks

-Martha

Anon

Sorry for the brief undesisive explanation.
In the database I have lots of entrys.
I have each entry numbered with the name of 'fid' for 'field id' 1, 2, 3, 4 etc.

In the database there is also a entry for the fid called category, within there are lots of entrys, dogs, cats, birds and cats.

The problem is each fid has all different catagories.

From our site the user selects dogs. I want it then to goto the specific fid and select from the category the first thing that comes up with the word dog in it and bring it back to me.

I hope that is more descriptive.
Thanks
Nick

Daarius wrote:

i am not very clear of what you mean, but if you want to do simple search in your DB, then why not use LIKE in your SQL query?

e.g.
SELECT * FROM dogs WHERE field_name LIKE '$keyword';