CAN SOMEONE HELP ME …CORRECT THE ERROR IN THE FOLLOWING SCRIPT BELOW:::
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.
PLEASE IN A REALL HURRY!!!
