backend/issue_list.php

   1 <?php
   2
   3 $sql = 'SELECT * FROM `'.$db_prefix.'issues` ORDER BY `date` DESC';
   4 $result = mysql_query($sql);
   5 $i=1;
   6 while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
   7     $sql = 'SELECT `name` FROM `aec_milestones` WHERE `dep` REGEXP CONVERT(_utf8 \'(\\d,)*'.$row[0].'(\\d,)*\' USING latin1) COLLATE latin1_swedish_ci';
   8     $res=mysql_query($sql);
   9     $name=mysql_fetch_array($res);
  10     $issues[$i] = $row;
  11     $issues[$i][12]=$name[0];
  12     $i++;
  13 }
  14
  15 /*
  16 $issues = array(
  17                 array(0,'546879','test','kernel','bug',0,0,'assigned','sadad',0,'sdsadasdasdsadasfdsfdsf')
  18                );
  19 */
  20 ?>