ABI 3100

Join an existing project

Home | user page

" ; ?>

List of projects you did not join yet:

No projects\n"; mysql_free_result($ensprojects); } elseif($nbmyprojects==$nbprojects) { echo "

You are already part of all existing projects

\n"; mysql_free_result($ensprojects); } else { echo "\n"; echo "\n"; echo "\n"; $i = 0; while ($i<$nbprojects) { $id_project = mysql_result($ensprojects, $i, "id_project"); $request = "SELECT id_project FROM projects_people WHERE id_project=$id_project AND id_people=$myid;"; $result = mysql_query ($request, $db) or mysql_die("Query SELECT failed."); if(mysql_num_rows($result)==0) // I am not part of this project { $request = "SELECT name FROM projects WHERE id_project=$id_project;"; $result2 = mysql_query ($request, $db) or mysql_die("Query SELECT failed."); $nameproject = mysql_result($result2, 0, "name"); mysql_free_result($result2); echo ""; echo ""; echo ""; echo ""; echo ""; echo "\n"; } else { mysql_free_result($result); } $i++; } echo "
IdName Members
$id_project$nameprojectJoin now"; $request = "SELECT login FROM projects_people, people WHERE projects_people.id_project=$id_project AND projects_people.id_people=people.id_people ORDER BY login;"; $result2 = mysql_query ($request, $db) or mysql_die("Query SELECT failed."); $nbpeople = mysql_num_rows($result2); echo mysql_result($result2, 0, "login") ; $j=1; while ($j < $nbpeople) { echo ", " . mysql_result($result2, $j, "login"); $j++; } mysql_free_result($result2); echo "
\n"; } ?>

Return to home page | user page\n"; ?>

Any problem? Please contact the Webmaster.

[Webmaster: isabelle.duperret@iee.unibe.ch]Webmaster
Version: 2.0, 07.09.2009