Help...Big Problem!

[buzzt]

When I submit a query using IE, any whitespaces in the search string are ignored (replaced by %20). Netscape does not automatically do this. How can I force Netscape to add the %20 instead of whitespaces when it queries the database?

 

[sleipnir214]

You can't.

You should perform all data cleanup on the server side in PHP. ______________________________________________________________________
TANSTAAFL!

 

[buzzt]

Figured it out.

For anyone with a similar problem, try the str_replace function to replace all the whitespaces sent in the query. So if the value sent in the query was "Two Words"

Example:

http://www.somedomain.com?column=Two

Words

The function would look like this:

$x = "Two Words";
$y = str_replace(" ", "%20", $x);

Instead of submitting the value of $x in the query, you wouls send $y.

So the PHP looks like this:

http://www.somedomain.com?column=$y

And in the address bar, looks like this:

http://www.somedomain.com?column=Two Words

Keep in mind the value of $x was pulled from the database, where it already contained whitespaces.