Re: Finding the records that are NOT linked
| From: | Joe Stump | Date: | Wed, 18 Apr 2001 21:37:27 +0000 |
| Subject: | Re: Finding the records that are NOT linked | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-49276@lists.php.net to get a copy of this message | ||
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: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
/* Joe Stump
* Sr. PHP Developer
* http://www.Care2.com http://www.joestump.net http://gtk.php-coder.net
*/