Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2000121

[PHP-DB] mysql_query question From: John Biesnecker (amraam <email protected>)
Date: 12/08/00

Hello all.

I have two tables in a database, one of which ("accesslog") contains a
series of host names (i.e., ao.net) and another ("countrycodes") that
contains the ISO descriptions for various domain suffixes (i.e., an entry
".net" with a description "US Networks").

What I'm trying to do is get a count of the hits from various countries
determined by their suffix.

I'm trying to figure out of there is a way to do this via SQL. I've been
trying something like

SELECT hostname, COUNT(hostname) AS num, descrip FROM accesslog,
countrycodes WHERE RIGHT(hostname, 5) LIKE countrycodes.code GROUP BY
hostname ORDER BY num DESC;

but that doesn't work (comes up with an empty set). At this point I'm sort
of stuck.

Thanks for any help you can offer me!

/s/ John 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>