what's wrong with this?

[itworks]

Can anyone tell me what's wrong with this query?

I'm making a search form that posts the result to another script that calls a script with the db connection and query.

this is the query in the db connection script:

        function detalhesPesquisa($modelo) {
            $sql = "SELECT * FROM produtos WHERE modelo='%".$modelo."%'";
            $rs=$this->bd->executarSQL($sql);

i did it with modelo=\"$modelo\" and it worked, but just if you typed all the right words.

thanks in advance.

[diego25]

Use LIKE instead of =...

modelo LIKE '%$modelo%'

Diego