Finding the records that are NOT linked

From: 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/

« previous php.general (#49253) next »