Hi,
I am attempting to do a full text search but have run into a problem as the field I am searching has been altered through the use of the javascript escape function and therefore has replaced all spaces with %20. This obviously means that the string is seen as one long word. I am quite new at PHP and mySQL so I am probably going the wrong way about things. If there is a more logical way to enter text containing special characters into the DB and then retrieve it using MATCH could you please let me know.

Thanks.

Hello ScreamingWeasel,

I think your script may be urlencoding a user-input data field that has already been urlencoded (i.e submitting a form with the GET method). What I mean by this is this:

If a user has submitted a form (and your form has submitted the data to your script via the GET method), the string data will be urlencoded...

So if the form field named "username" is submitted with a value like "John Smith" - in the address bar, it would look like "process.php?username=John%20Smith". But, when you are dealing with the data in PHP, the variable $_GET['username'] is still "John Smith"!

I suspect somewhere between these tasks, something in the script is 'urlencoding' the data again (before you inserted it into the database table)... if not please post some sample code off your form and script.

__________________
J de Silva
Learning Journal | GIDForums™ | GIDNetwork™ | GIDWebhosts™ | GIDSearch™

Thanks for the reply,

I have just managed to sort out the problem myself and you will be pleased to know you were on the right path. :-P