most popular places
| From: | Merlin | Date: | Fri, 25 Feb 2005 15:08:54 +0000 |
| Subject: | most popular places | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-38669@lists.php.net to get a copy of this message | ||
Hi there,
I am trying to do a tricky task with PHP and MySQl 4.0.x
There are 3 content tables where each of them contains a city_id
and there is a 4th table which holds the city_id and the acording city_name
Now I would like to find out the most used city names.
For example:
members pictures reports
3 4 3
2 9 8
9 8 8
So the most used city_ids are
8
3
9
To find this out would be a chelenging task, but to merge them with the city name is even more difficult
I am working on this quite a while now and cant find a way. Maybe someone of you guys could give me a smart push.
Thank you for any help,
Merlin