Requête MySQL Select

Bonjour,
Je veux récupérer un champ à partir d'une table plusieurs fois avec des conditions différents voile ma requête :

Code:

---

1 2 3 4

SELECT design_param as designParam1,design_param as designParam2,design_param as designParam3,design_param as designParam4,design_param as designParam5,design_param as designParam6,design_param as designParam7,design_param as designParam8,design_param as designParam9,design_param as designParam10 FROM options,parametrage WHERE parametrage.id_param = options.id_param AND designParam7='Format' AND designParam6='Choix'

---

Mais ça marche pas.
Merci de bien vouloir m'aider

Code:

---

1 2 3 4 5

SELECT design_param as designParam1,design_param as designParam2,design_param as designParam3,design_param as designParam4,design_param as designParam5,design_param as designParam6,design_param as designParam7,design_param as designParam8,design_param as designParam9,design_param as designParam10 FROM options,parametrage WHERE parametrage.id_param = options.id_param AND designParam7='Format' AND designParam6='Choix'

---

ça marche pas = pas de résultat ou des résultats inattendues.

et pour faire

Code:

---

1 2	design_param as designParam1,design_param as designParam2,design_param as designParam3,design_param as designParam4,design_param as designParam5,design_param as designParam6,design_param as designParam7,design_param as designParam8,design_param as designParam9,design_param as designParam10

---

que faire

Code:

---

1 2 3 4 5

SELECT design_param FROM options,parametrage WHERE parametrage.id_param = options.id_param AND design_param in ('Format','Choix')

---

tant que design_param est le même que designParam i(1<= i<=10)