SQL question

Anon

Hi,

I have the following MySQL tables:

categories:
- id
- parent

categorie_name:
- cat_id (link to categories.id)
- name
- language

What I would like to do is select all categories with a certain parent and a certain language(NED, FRA or GER, etc...) BUT if the language is not available use the default ENG language.

This is what i used sofar but did not work.

SELECT * FROM categories a, categorie_name b WHERE a.parent = $pid AND a.id > 0 AND a.id=b.cat_id AND b.language IN('ENG','$view_taal') GROUP BY b.cat_id ORDER BY b.name

How can i have the categorie name who has the $view_taal as language, but if not available give me the ENG name (because that language is a required field)

Kind regards,
Gerry

bastien

i would check to see if the $view_taal is set before deciding whether to search for "ENG"

if (!isset($view_taal){
$view_taal = "ENG"
}

SELECT * FROM categories a, categorie_name b WHERE a.parent = $pid AND a.id > 0 AND a.id=b.cat_id AND b.language IN('$view_taal') GROUP BY b.cat_id ORDER BY b.name

hth

Bastien

Anon

Bastien,

I'm looking for something more complex then that.

if (!isset($view_taal){
$view_taal = "ENG"
}
That would give me the whole categorie tree in 1 language (ENG)

BUT what i would like to do is if (for example) row5 is available in FRA give me the FRA categorie name and all the other rows where there is no FRA name available use the ENG version.

Preferably in 1 query.

So the query should check if the name is available in the $view_taal and return that name and if not available use the ENG version.

Any idea's?

Kind regards,
Gerry.