[MySQL基础知识] 根据部门显示数据

learnphp

欢迎您访问乐学PHP论坛! 您目前的身份是游客，所以只能阅读部份内容，请注册或者登录，谢谢！
$schoolname1=array();
$school=$_SGLOBAL['db']->result($_SGLOBAL['db']->query("select title from ".tname("spaceinfo")." where uid='$_SGLOBAL[supe_uid]' and edutype='1' and type='edu'"),0);


$select=$_SGLOBAL['db']->query("select * from ".tname("groupname")." where edu='$school'");

while($school=$_SGLOBAL['db']->fetch_array($select)) {
        $school[createtime]=date("Y-m-d",$school[createtime]);
        $schoolname1[]=$school;
        
$count=$_SGLOBAL['db']->result($_SGLOBAL['db']->query("select count(distinct groupmember) from ".tname("groupmember")." where groupname='$school[groupname]' " ...
................

learnphp

1# learnphp
groupmember表
uid mediumint 8
groupname varchar
groupmember var
creater var
shopname var
price int
address var
telephone var
buytime var
buynum var

groupname表
uid mediumint
groupname var
edu var
title var
num int
user var
createtime var
isbuy var