MySql full-text search script

[88guy]

I recently created a database and table, using a tutorial, that allows for full text searching.  One field is called "content" and the other is called "URL".  I want to build a simple search page that will match words against each other and return URLs, in hyperlink form, so that visitors can find products (I run a small store).  I actually managed to write an online script that allows me to copy and paste content, along with the associated URL, into a form and it's shot directly into the database/table.  I'm an idiot with this stuff - that took me about 3 days (although it works famously).

 

The syntax for a command line search is something like:

 

select url from mytable where match(contents, url) against('Dell Optiplex');

 

I'm an old fart and it took me 5 days to get this far.....ARGH!

 

Obviously, I know that the top of the page has to contain directives for connecting to mysql and the database. 

 

If anyone could throw me a bone, here (for the rest of a script), I would be eternally grateful.

 

 

Thanks,

 

Guy Merritt

[fenway]

full-text indexing is annoying to implement, but there are 3-rd party soluions.