1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
|
<?php
require("model/functions.php");
$link = access();
function mfprincipal() {
$req = "select ac.id, ac.themebis(jpb), con.name, ac.results, ac.problemorpositivepoint, am.therecommandations, am.actions, dep.name, dec.willbeexploited, dec.priority, pers.responsible, pers.numworkers, statut.libelle, d.submitdate, d.solvedate, d.starteddate, d.verifdate,d.lastanalysisdate, d.rejectdate, d.targetdate, d.closuredate, am.resultsoftheaction, com.comments
from action ac, ameliorations am, contact con, comments com, dates d, decision dec, departement dep, personne pers,statut
inner join d on ac.id = d.id#
inner join am on ac.id = am.id#
inner join dep on ac.id = dep.id#
inner join dec on ac.id = dec.id#
inner join con on ac.id = con.id#
inner join com on ac.id = com.id#
inner join pers on ac.id = pers.id#
inner join statut on ac.id = statut.id#
order by asc ac.id";
$res = mysql_query ($req, $link);
return ($res);
};
?> |