Hi all,
I need help please..........(not just mentally)

Current process is as follows
User copies and pastes CV to text area
PHP inserts into blob
later search for user using 'like' over blob
also upload word format of CV and store location logic structure of file renaming relevant to user id so echo" <href ".$user_id .".doc"...etc finds word document

What need now is
instead of user copy paste just
upload Word CV read into "search" blob
rest stays the same.

I've tried allsorts of combos but got just bumf in the blob
read(),file(),fopen...etc nothing seems to populate the blob OK for later 'like' select.

Please advise.
Thanks for any advise (as long as the last word isn't ...off !!!).
Best regards to all
RichFM

    Blob is a binary field, and is (afaik) not searchable. What you wanna do is to make the user insert a name to a second field in the row, then use that for searching.

    Word doc's are heavily formatted, and should be regarded as binaries. Try to open one in a text-ed that doesn't support .doc, and you'll see...

    knutm

      Thanks for your contribution mogster.......

      FYI on binary search all working OK with copy paste then search blob.

      Yes you get all the format rubbish but also you get all the CV in words so

      select * from table where table_field like '%$search_variable%'

      works fine

      but if you read into the blob (not copy and paste) using PHP it contains '?/D*]x' so the above search process is redundant.

      Again thanks for your reply.

      Best regards
      RichFM

        Write a Reply...