php - 一起显示同年事件(PHP/MYSQL)

Question

我有一个数据库，其中包含特定年份的一些事件，例如同一年的 3 或 4 个事件。我的表是这样的:

year | event
-----------------
2004 | Event 1
2004 | Event 2
2005 | Event 3
2005 | Event 4

我想像这样显示它们:

2004
- Event 1
- Event 2

2005
- Event 1
- Event 2  

有什么想法吗？非常感谢!

这是我实际的普通查询:

$result = mysqli_query($con,"SELECT * FROM expos WHERE activo = 1 ORDER BY anio");
echo "<ul id=\"expos\">";
while($row = mysqli_fetch_array($result)){
    echo "<li>";
    echo $row['anio']."<br />";
    echo $row['titulo'];
    echo "</li>";
}
echo "</ul>";
mysqli_close($con);

Answer 1

您的查询一切正常!

我认为如果你可以建立一个新的营地，增加这一天。查询最容易。

你只需要订购它，但如果你没有时间，你可以做这个:

while($row = mysqli_fetch_array($result)){
    if($back==$row["anio"] || $back==""){
      $var_array[] = $row["evento"];
    }
    if($back!=$row["anio"]){
      foreach($var_array as &$item){
        $number=explode(" ",$item);
        $number_event[] =$number;
        //this is for getting just the number.
      }
      //bubble sort    both are for ordering the array event!.
      //shell sort

      //here just display with foreach and echo 

      $back = $row["anio"];

    }
}

再见!