Is anyone else able to see my search results?

[lawrence k]

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.

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 ;

[Erwin Moller]

I see your posting 4 times in comp.lang.php.....

Regards,
Erwin Moller

[lawrence k]

Erwin Moller wrote:

I see your posting 4 times in comp.lang.php.....

Regards,
Erwin Moller

Sorry. I used Google Groups to post. Every time I posted it gave me a
500 in response, and said there had been a Server Error. I kept posting
till it said the post had gone through.

[Erwin Moller]

lawrence k wrote:

Erwin Moller wrote:

I see your posting 4 times in comp.lang.php.....

Regards,
Erwin Moller

Sorry. I used Google Groups to post. Every time I posted it gave me a
500 in response, and said there had been a Server Error. I kept posting
till it said the post had gone through.

Aha, ok.

Tip: Download a real newsreader. It gives you a lot more comfort than
Google.
You can find many for all platforms.
My favorites:
for W$: forte free agent.
for *nix: Knode

but there are a zillion out there. Give it a shot. :-)

Regards,
Erwin Moller

[David Haynes]

Erwin Moller wrote:

lawrence k wrote:

Erwin Moller wrote:

I see your posting 4 times in comp.lang.php.....

Regards,
Erwin Moller

Sorry. I used Google Groups to post. Every time I posted it gave me a
500 in response, and said there had been a Server Error. I kept posting
till it said the post had gone through.

Aha, ok.

Tip: Download a real newsreader. It gives you a lot more comfort than
Google.
You can find many for all platforms.
My favorites:
for W$: forte free agent.
for *nix: Knode

but there are a zillion out there. Give it a shot. :-)

Regards,
Erwin Moller

Thunderbird works on either platform if you're not trying to download
the binaries.

-david-

[lawrence k]

David Haynes wrote:

Thunderbird works on either platform if you're not trying to download
the binaries.

"either platform" ???

I use 3 platforms every week, without exception.