以数据库字段分组显示数据的sql语句(详细介绍)

这篇文章主要为大家详细介绍了以数据库字段分组显示数据的sql语句(详细介绍)，具有一定的参考价值，可以用来参考一下。

对此感兴趣的朋友，看看idc笔记做的技术笔记！

代码如下:

<?php
$dsn = "mysql:host=localhost;dbname=group";
$db = new PDO($dsn, 'root', '');
$db->exec('set names utf8');

$sql = "select conf_id from `group` group by conf_id";//$pre = $db->prepare($sql);//$result_arr = array();$pre = $db->query($sql);$result_arr = $pre->fetchAll(PDO::FETCH_ASSOC);

//print_r ($result_arr);foreach ($result_arr as $v){echo $v[conf_id]."<br>";$vv = $v[conf_id];$re = array();$sql1 = "select * from `group` where conf_id = '$v[conf_id]' order by time";$sql2 = "select * from `group` where conf_id = '$v[conf_id]' order by time DESC";$rs1 = $db->query($sql1);$rs2 = $db->query($sql2);$re1[$vv] = $rs1->fetchAll(PDO::FETCH_ASSOC);$re2[$vv] = $rs2->fetchAll(PDO::FETCH_ASSOC);print_r($re1[$vv][0]);print_r($re2[$vv][0]);}

注：关于以数据库字段分组显示数据的sql语句(详细介绍)的内容就先介绍到这里，更多相关文章的可以留意