Re: [PHP] Finding the records that are NOT linked

2001-04-18 Thread Joe Stump
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) a

Re: [PHP] Finding the records that are NOT linked

2001-04-18 Thread Steve Werby
"Simon Kimber" <[EMAIL PROTECTED]> wrote: > 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

[PHP] Finding the records that are NOT linked

2001-04-18 Thread Simon Kimber
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,dates