<?php

session_start();

//print_r($_POST);

	if(isset($_POST["MNEMONIC"]))

	{



		$conn = mysql_connect("localhost","root","mdp"); 

		$db=mysql_select_db("pharma", $conn);

		$res = "SELECT DISTINCT CATEGORIE FROM inscrits_en WHERE MNEMONIC = '" . $_SESSION[MNEMONIC] . "' AND TYPE_DE_COURS = '" . $_SESSION[TYPE_DE_COURS] . "'";

		//il faut faire echo'<script LANGUAGE="JavaScript">alert("'.$res.'")... AVANT mysql_query afin d'afficher la requête sql, une variable de session pourrait ne pas être reconnue, c'est une façon facile de le voir.

		echo'<script LANGUAGE="JavaScript">alert("coucou");</SCRIPT>';	

		$res = mysql_query($res, $conn); 

		

		

			



		

		

		$nombre = mysql_num_rows($res);

		





		while($row = mysql_fetch_assoc($res))

		{

			

			echo "<option value='".$row["CATEGORIE"]."'>".$row["CATEGORIE"]."</option>";

		}

	}

	else echo'<script LANGUAGE="JavaScript">alert("pas bon");</SCRIPT>';



?>

	function fnctcategories(type)

	{

		var xhr3 = getxhr();

		xhr3.onreadystatechange = function()

		{

			if(xhr3.readyState == 4 && (xhr3.status == 200 || xhr3.status == 0 ) )

			{

				alert('cool');

				leselect3 = xhr3.responseText;

				document.getElementById('select_Nom_types').innerHTML = leselect3;

			}

		}

	

		xhr3.open("POST","Scripts/ajaxCategories.php",true);

		xhr3.setRequestHeader('Content-Type','application/x-www-form-urlencoded');

		xhr3.send("NOM_DU_TYPE="+type);			

	}