PHP MYSQL search

[Tim_L]

What would I have to do so that a user can type in a keyword into a field and it would bring up a list of product results on another page?

I've got the field in a form and the form is posting to prodlisting.php. That's all I've got so far???

Thanks...

[mystrymaster]

$query = "SELECT fieldname FROM databaseName WHERE formFieldName LIKE '$formVariable%'";

Notice the % sign

That is the wildcard where it will match deer with deer park etc

If you really want to fancy you can start doing pattern matching and stuff but that's another story

[Tim_L]

thanks for the reply!

I'm a newbie working in Dreamweaver. Where would I put that expression?

[mystrymaster]

I have no idea about the integration between dreamweaver and PHP but I would do it actually in the code near the top and then simply call the script when you need it.

[Tim_L]

how do you CALL the script? I've got a form with the text field in it - what should the form point to?