On your join instead of doing ID=ID do ID!=ID
--Joe
On Wed, Apr 18, 2001 at 09:55:05PM +0100, Simon Kimber wrote:
> 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]
/* Joe Stump
* Sr. PHP Developer
* http://www.Care2.com http://www.joestump.net http://gtk.php-coder.net
*/
--
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]
