Newbie Alert: PHP/MySQL search script

[mcjohnson]

Hello friends,

As always, your continued help and support rocks.

Today's newbie PHP question should be simple; I have a MySQL db containing about 8 different rows (manufacturer, product, condition, and so on).

I've constructed a search page that searches based on specific form data posted. Now, I want to add an advanced search, of sorts, as simple as yahoo or google. One simple text area that will return a search from any of the rows in the db...

so if the guy knows he wants an L2550 model part, he types that in and the output returns all rows with that part number.

Is this as easy as I suspect?

Many thanks!

Pat

[dreamcatcher]

Yep, fairly easy. What I would suggest is you check out the MySQL search syntax on the MySQL website. That should give you a good start.

Good luck.

[ergophobe]

Look in the forum library (link in the upper left of the page) for a thread on the basics of extracting data from a MySQL database.