Passing Variables

[Anon]

Hello again.

this time a question about variables.

I use a form to allow users to search a database. the problem is that some values have spaces (eg: Mary of Wales)

If a user searches Mary Wales, I get nothing.

I use a Oracle database with OCI.

How can I do this?

Here is part of my script:

$valor = ereg_replace("<([^>]|\n)*>", "", $valor);

$valor = strtoupper($valor);

$sql = "SELECT * FROM FARMACIA WHERE $var LIKE UPPER('%%$valor%%') ORDER BY NOME";

Thanx

[Anon]

try inserting % in your empty spaces. so that the search string is Mary%Wale

this will give you the search results as needed.

[vercesi]

Should I do that using ereg or strt_replace?

Can I do it directly from the form, while validating (JavaScript).

Thx