How to select tables that aren't empty and don't contain a certain string?

[schwim]

Hi there everyone,

I have a table full of logged visits on a web page. Included in the data are the http referers.

I would like to print the latest 20 hits, but I don't want to print the hits with empty referers and I don't want to print the hits with referers from the domain that the script resides on.

Currently, I print the last ten without conditions:

$query = "SELECT id,hits,remote_addr,date,date_lastseen,request_method,request_uri,server_protocol,http_referer,http_user_agent" .

" FROM ".$zapprefix."tracker ORDER BY date_lastseen DESC limit 0, 10";

How do I alter this to exclude blank and referers from domain.com?

I'm pretty sure that I would use %domain.com%, but I don't know how to implement it.

thanks,
json

[Sxooter]

where referrers NOT NULL and referrers = 'yourdomain'

or something like that. maybe referrers not like '%yourdomain%' would be needed.