*solved* Echo list of currencies plus the number of these from a table.

[brown2005]

i have two tables

[b]currency[/b]

currency_id
currency_currency

[b]adverts[/b]

adverts_id
adverts_currency


i want to print all currency's (that have 1 or more in adverts) from currency and then how many adverts have this currency in adverts...

[craygo]

you will have to make it relational in order to reference one to the other.

add a field in the adverts table to reference the currency table

adverts

adverts_id
curr_id
adverts_currency

now you can query one based on the other

[code]$sql = "SELECT * FROM currency LEFT JOIN adverts ON currency_id = curr_id";[/code]

Ray

[Barand]

SELECT c.currency_currency, COUNT(a.advert_id)
FROM currency c
INNER JOIN adverts a ON c.currency_id = a.advert_currency
GROUP BY c.currency_currency

[brown2005]

thanks barand, spot on. exactly wat i needed