Discussion :

[Ania5]

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

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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

[azstar]

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

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 :

Sélectionner tout - Visualiser dans une fenêtre à part

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 :

Sélectionner tout - Visualiser dans une fenêtre à part

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)