Greenguy's Board - View Single Post

oast · 2006-10-15, 08:45 AM

Matt, I just found a 'problem' with your code.

Let's say domain 'ThisWebsite.com' was listed. If, later, someone wanted to list 'EBSite.com' it would catch it as already listed... at least in my present MySQL query of "SELECT * FROM table WHERE url LIKE '%$url%'" or even "SELECT * FROM table WHERE url RLIKE '^http://([.a-z0-9]+)?$url'"

I think I'm going to have to re-write the database, and add a 'domain' field for the extracted domain; and do an exact match on that.
Oh well, at least there only 4,569 domains listed.

2006-10-15, 08:45 AM	#1
oast With $10,000, we'd be millionaires! We could buy all kinds of useful things like ... love! Join Date: May 2004 Location: UK Posts: 316	Matt, I just found a 'problem' with your code. Let's say domain 'ThisWebsite.com' was listed. If, later, someone wanted to list 'EBSite.com' it would catch it as already listed... at least in my present MySQL query of "SELECT * FROM table WHERE url LIKE '%$url%'" or even "SELECT * FROM table WHERE url RLIKE '^http://([.a-z0-9]+)?$url'" I think I'm going to have to re-write the database, and add a 'domain' field for the extracted domain; and do an exact match on that. Oh well, at least there only 4,569 domains listed. __________________ Playboy Webmasters - The name says it all! $35 per signup or 60% revshare.