I am new to PHP and so far have only really used scripts that other people have written. But it is a nice easy way to start learning.
Anyway, I wondered if such a tool/script already exists to do the following. On my website I want to have a search facility that would search a mysql database. I haven't designed the database but lets say for now that it consiss of one table. This table would have the following frields :
Name
Description
Web link
Display text
What I would like to do is allow the user to enter search text. This will be searched against the name field in the table above. The results would display the name, description, and display text. The display text would be a reference to web link which when clicked on would go to that site.
Is there any tool or script that might help me achieve this or would I have to write it from scratch myself ?