Finding the records that are NOT linked
| From: | Simon Kimber | Date: | Wed, 18 Apr 2001 20:55:05 +0000 |
| Subject: | Finding the records that are NOT linked | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-49253@lists.php.net to get a copy of this message | ||
Hi all,
I have written a PHP/MySQL "top-sites" program. It has two tables,
link_sites, which contains the details of all the sites signed up
(ID,url,title,description) and link_stats in which a new record is inserted
every time a visitor links in from one of those sites
(ID,siteID,clientIP,datestamp).
Can anyone help me write a SQL query to pull out all the sites in link_sites
that are not mentioned in link_stats.. ie the ones that have never been
clicked..
Cheers
Simon Kimber
Funny.co.uk - The Comedy Portal
http://www.funny.co.uk/