Yeah, the problem is we are trying to do something that is not done by any
of the other search engines. I am working on a "Quick Clean" to clean out
Search spammers on the fly. We have Upstream partners (Like Overture) who
like to "Fill" us with their "Run of Site" ads when even they don't have
paid advertisers. While this is good for the bottom line we find its
annoying as hell to those who use our search.
Its our hope that folks will use our feed for their search because of our
work to keep it clean. There are tons of sites out there producing feeds.
Because I couldn't do it the way I wanted to I found a new way by cleaning
the URL's from each of our partners before we add them to ram for our output
sorting. By cleaning the urls I was able to delete by using:
{
//print $dbad;
//print "<br />";
$dead_beat_ads = "Delete from fsearch_temp where fsearchHost='$dbad'";
$dead_beat_result = $dbi->query($dead_beat_ads);
}
This will give a greater degree of certainty to who we are deleting on the
fly. I have already tested this and we are actually running it live on our
Outdoor network and will implement this on http://www.sharedfeed.com for it
opening day release next week.
By avoiding talking to the hard drive cleaning up content on the fly is a
snap.
Thanks
Donny Lairson
President
29 GunMuse Lane
P.O. box 166
Lakewood NM 88254
http://www.gunmuse.com
469 228 2183
-----Original Message-----
From: Rhino [mailto:[EMAIL PROTECTED]
Sent: Sunday, May 01, 2005 4:44 PM
To: [EMAIL PROTECTED]; Mysql
Subject: Re: Can I use LIKE this way?
I think you want the wildcard characters, % and _, to be within the
variable, not within the variable name. For example, if you are looking for
all advertisers whose name begins with 'A' followed by zero or more unknown
characters, you would set your variable equal to this pattern [I don't know
PHP so if this isn't how a variable declaration would look in PHP, adjust it
so it does]:
myVar = 'A%'
Then, you would execute your query, plugging in the variable in the
appropriate place [again, I don't know PHP so maybe you need a $myVar
instead of :myVar or at least something along those lines]:
select *
from mytable
where advertiser = :myVar
In your question, you seem to want to put the wildcard character(s) in the
variable name like this:
select *
from mytable
where advertiser = % :myVar
While this might conceivably work in some programming languages, it's not
the way it is normally done in any language I know.
Rhino
----- Original Message -----
From: [EMAIL PROTECTED]
To: Mysql
Sent: Sunday, May 01, 2005 4:27 PM
Subject: Can I use LIKE this way?
{
$dead_beat_ads = "Delete from fsearch_temp where
fsearchKeyword='$str' and fsearchTime='$time' and fsearchIp='$fbip' and
fsearchHost LIKE '%$dbad%' ";
$dead_beat_result = $dbi->query($dead_beat_ads);
}
What I am doing is eliminate "Run of site" advertisers from our network
LIKE EBAY.com I would rather give free crawler results than to allow this
spam advertising anymore. So I before I develope our XML output of search
results to our partners I am going to remove them but since their tracking
can change All I want to do is search for them by host Like ebay.com and I
will pull this out in real time thus all the $time requirements. This will
mean that no matter which of our partners ebay buys advertising from they
won't be displayed through our network. Or if someone buys a commission
junciton ad we will pull them out by the host even though the click url may
be a qcksrv ad.
So the question is can that % be butted up against the variable or
should I put a space in there. While reading the LIKE on Mysql .com it
talks about 2nd position with a space but I didn't know if that meant for
the use of %_$dbad_% or if % $dbad % would have it looking for second
position stuff.
Thanks
Donny Lairson
President
29 GunMuse Lane
P.O. box 166
Lakewood NM 88254
http://www.gunmuse.com
469 228 2183
----------------------------------------------------------------------------
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.0 - Release Date: 29/04/2005
