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/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]