Is anyone else able to see my search results?

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • lawrence k

    Is anyone else able to see my search results?

    Here is the thing. When you go to this page:



    I've put in some HR tags in the HTML to separate the 3 different
    queries. After those 3 queries you'll see results at the bottom. For
    me, those results look like this:

    api (4), darren (1), xml (12), battlepanda (1), war+on+drugs (6),
    stupid (1), moron (1), nightmare (1), hell (1), mijkuynbvfsds (1),
    police (1), Pitchfork+Media (1),

    There are two problems here. Do you get this when you go to this page?
    I'm concerned that I'm only getting back the things that I have
    personally searched for, and not the things that others have searched
    for. Let me know, please, if this works for you.

    The goal of this script is to be able to say to the person who is
    searching "People who searched for this item, also searched for these
    other things."

    It is suppose to be a little like on Amazon.com, where when you buy one
    thing, it says "Customers who bought this item also bought these other
    items:".


    I'm sorry I didn't give the table structures earlier. The visitor id of
    searchHistory is the id of visitors. machineId is a unique value
    generated and set by a cookie.

    #
    # Table structure for table `searchHistory`
    #

    CREATE TABLE `searchHistory` (
    `id` int(11) NOT NULL auto_increment,
    `query` text NOT NULL,
    `visitorId` int(11) NOT NULL default '0',
    `domain` varchar(255) NOT NULL default '',
    PRIMARY KEY (`id`)
    ) TYPE=MyISAM AUTO_INCREMENT= 88 ;




    #
    # Table structure for table `visitors`
    #

    CREATE TABLE `visitors` (
    `id` int(11) NOT NULL auto_increment,
    `date` int(11) NOT NULL default '0',
    `ipAddress` varchar(15) NOT NULL default '',
    `hostname` varchar(255) NOT NULL default '',
    `machineId` varchar(255) NOT NULL default '',
    `referrals` varchar(255) NOT NULL default '',
    PRIMARY KEY (`id`)
    ) TYPE=MyISAM AUTO_INCREMENT= 8236 ;

  • Justin Koivisto

    #2
    Re: Is anyone else able to see my search results?

    lawrence k wrote:[color=blue]
    > Here is the thing. When you go to this page:
    >
    > http://www.accumulist.com/index.php?...lFields%5D=api
    >
    > I've put in some HR tags in the HTML to separate the 3 different
    > queries. After those 3 queries you'll see results at the bottom. For
    > me, those results look like this:
    >
    > api (4), darren (1), xml (12), battlepanda (1), war+on+drugs (6),
    > stupid (1), moron (1), nightmare (1), hell (1), mijkuynbvfsds (1),
    > police (1), Pitchfork+Media (1),
    >
    > There are two problems here. Do you get this when you go to this page?
    > I'm concerned that I'm only getting back the things that I have
    > personally searched for, and not the things that others have searched
    > for. Let me know, please, if this works for you.[/color]

    I clicked the link, and here is what I see at the bottom of those queries:

    api (12), darren (1), xml (21), battlepanda (1), 1 (1), a (1), sd (1),
    (1), ballFields (1), war+on+drugs (6), stupid (1), moron (1), nightmare
    (1), hell (1), mijkuynbvfsds (1), police (1), Pitchfork+Media (1),


    NOTE: I only visited that one page, and have never been to the site before.

    --
    Justin Koivisto, ZCE - justin@koivi.co m

    Comment

    Working...