Location: PHPKode > projects > Mozart > Mozart-0.0.4/todoBYproj.inc
<?
// this module pulls information concerning TO DO items by a given project_id
//
$TodoXProjSQL = "SELECT system_id, information, xtodo_id FROM users, todo, todoxproj WHERE xproj_id = '$id' AND xtodo_id = todo_id AND user_id = todo.owner AND complete = ' '";
$TodoXProj    = mysql_query($TodoXProjSQL);
if ($todoxproj = mysql_fetch_array($TodoXProj)) {
   print("<br><b>Active To Do Items Associated With Project:</b><br>");
   printf("<a href=\"updtodo.php?id=%s\">%s</a> <i>assigned to</i> %s<br>", $todoxproj["xtodo_id"], $todoxproj["information"], $todoxproj["system_id"]);
   while ($todoxproj = mysql_fetch_array($TodoXProj)) {
     printf("<a href=\"updtodo.php?id=%s\">%s</a> <i>assigned to</i> %s<br>", $todoxproj["xtodo_id"], $todoxproj["information"], $todoxproj["system_id"]);
   }
}
else
  print("<br><b>No Active To Do Items Located</b><br>");
?>
Return current item: Mozart