Hi there,
Thanks for the reply, but no luck I'm afraid. I tried a
variety of different "" or ' ' permutations but a variety of errors
appeared.
The Search actually works fine, strangely enough, but I
cannot acess the Recordset dropdown. When I click the + sign, it
has the MM_ERROR: MySQL Error#: 1054 Unknown column 'SearchString'
in 'field list' error.
Another strange occurance is that many changes to the SQL
Code does not stick. I have to go back in a sometimes half the code
is missing.
I also think it has something to do with the first MATCH
request.
When I do get access to the Binding data by removing part
ofthe SQL code, a field reference of
MATCH (presentationID,presentationTitle,
PresentationName,ProductlineName,
LevelName,RoleName,presentationDescrip) AGAINST (SearchString IN
BOOLEAN MODE)
shows in the drop down menu.
Very Strange.
Oh I need to add that I added a homemade condition to the
$SearchStringSQL variable.
At the top of the Results page I added:
<?php $SearchString=$_GET['SearchString'];?>
<?php $SearchStringSQL = "+".str_replace(" " , " +",
$_GET['SearchString']); ?>
This allows several words to be typed into the Search Box,
and only records containing ALL of those words will be displayed.
This allows the users to filter deeper as one or two words could
still produce dozens of records.
Again, it works fine on the Server running mySQL 4, which is
now the backup of the Server running mySQL5 so I don't think this
has a bearing on the issue.
I'm stumped...............
... View more