1 pièce(s) jointe(s)
petit probleme dans une requete
bonjour,
voici j ai un je dois rechercher des valeurs dans ma base de données , je les ai bien prise mais pas dans le bonne ordre et en multiple voici mon code et ce que cela me donne
Code:
$stid = oci_parse($conn, "SELECT FUNCTION_NAME_EN, BODY_NAME_EN FROM BODY, FUNCTION WHERE FUNCTION_ID IN (select ROLE_FUNCTION_ID_FK from role where role_member_id_fk=".$var.") AND BODY_ID IN( select ROLE_BODY_ID_FK from role where role_member_id_fk=".$var." ) order by function_id");
Vice-Chair Human Rights
Vice-Chair Afghanistan
Vice-Chair Bosnia and Herzegovina, Kosovo
Vice-Chair Kristdemokraterna
Vice-Chair Foreign Affairs
Vice-Chair Transport and Tourism
Member Human Rights
Member Kristdemokraterna
Member Transport and Tourism
Member Afghanistan
Member Foreign Affairs
Member Bosnia and Herzegovina, Kosovo
Substitute Foreign Affairs
Substitute Transport and Tourism
Substitute Bosnia and Herzegovina, Kosovo
Substitute Kristdemokraterna
Substitute Afghanistan
Substitute Human Rights
et voici ce que je dois obtenir
Pièce jointe 189446
Merci pour votre aide