<?php 

function Ressource($ID_CITE){

                $this->ID_CITE = $ID_CITE;



                $SQL = mysql_query("SELECT * FROM Cite_Ressource,Ressource_Reference

                WHERE (Cite_Ressource.ID_RESSOURCE = Ressource_Reference.ID_RESSOURCE) AND ID_CITE = '".$this->ID_CITE."'")

                or die('Erreur SQL !'.$SQL.'<br>'.mysql_error());



                $COUNT = mysql_num_rows($SQL);



                for($i=0;$i<$COUNT;$i++){

                $this->ID_RESSOURCE = mysql_result($SQL,$i,"ID_RESSOURCE");

                $this->STOCK = mysql_result($SQL,$i,"STOCK");

                $this->NOM_RESSOURCE = mysql_result($SQL,0,"NOM_RESSOURCE");

                $this->EFFET_REFERENCE = mysql_result($SQL,0,"EFFET");

                $this->STOCK_MAX_REFERENCE = mysql_result($SQL,0,"STOCK_MAX");

                                        }



                            }