Project Detail

Description

Hi,

I am looking for a programmer who has
lots of knowlegde of MYSQL databases
and PHP.

I am stuck on this issue trying to fix something like this:

mysql query:
///////////////////////////////////////////
SELECT
table1.city_id,
table2.main_id,
table3.city_name,
COUNT(*) AS count
FROM
table1,
table2,
table3
WHERE
table2.main_id=table1.main_id AND
table2.description_id='1' AND
table2.country='uk' AND
table1.city_id=table3.city_id AND
table3.language='de'
GROUP BY city_id
ORDER BY city_name ASC
///////////////////////////////////////////


What i want you do is help me fixing these few issue's:

-> get the city names of the tables that do cointain information
of the previous selected language
-> count the total row
-> ORDER the result by city name ASC

We are talking about 1 database with 3 tables

the problem is that in the table that holds all the citynames
some cities are not translated in the language we are looking
for. In that case the english version should be selected by
default.

So all you have to do is get us the correct Query.
everything else is already working.

We do want to chat on the MSN.
I think in total it will take max. 1 hour or maybe
0,5 hour.

Regards!