backend/milestone.php

   1 <?php
   2
   3 $sql = 'SELECT * FROM `'.$db_prefix.'milestones` WHERE `id` = '.$_GET['nr'];
   4 $result = mysql_query($sql);
   5 $mile = mysql_fetch_array($result);
   6
   7 $deps = explode(',', $mile[4]);
   8 $i=1;
   9 foreach ($deps as $dep) {
  10 $sql = 'SELECT * FROM `'.$db_prefix.'issues` WHERE `id` = '.$dep;
  11 $result = mysql_query($sql);
  12 $issues[$i]=mysql_fetch_array($result);
  13 $i++;
  14 }
  15
  16 uksort($issues,"compare_issue_date");
  17 ?>