This is a discussion on Is anyone else able to see my search results? within the PHP Language forums, part of the PHP Programming Forums category; Here is the thing. When you go to this page: http://www.accumulist.com/index.php?...lFields%5D=api I'...
|
|||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
|||
|
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 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. |
|
|||
|
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 |
|
|||
|
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- |