SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Thread: match..against

  1. #1
    SitePoint Guru
    Join Date
    Feb 2004
    Location
    Oregon
    Posts
    686
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    match..against

    lets say I have a variable like so

    $var = "http://google.yahoo.";

    and if I used

    $Q = "select stats_referrer, stats_page_visited, MATCH (stats_referrer) AGAINST ('$sear') AS score from $_STATS_stats where MATCH (stats_referrer) AGAINST ('$sear') ";

    how can I use " in the against so it will get exaclty what is typed? even though I didn't type it.

    as it stands now, it will return yahoo and google rows. not the one I wanted.

    so I have to change the " into &quote;
    success is not by chance, it is by choice.

  2. #2
    SitePoint Guru
    Join Date
    Feb 2004
    Location
    Oregon
    Posts
    686
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    this returned the samething as it does now

    AGAINST ('\"$sear\"')

    any other ideas? wonder if I have to change the period to the ascii format, is there one? yup, &#46
    success is not by chance, it is by choice.

  3. #3
    SitePoint Guru
    Join Date
    Feb 2004
    Location
    Oregon
    Posts
    686
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    but it still doesn't work.
    success is not by chance, it is by choice.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •