+ -
当前位置:首页 → 问答吧 → php数据获取问题,急!

php数据获取问题,急!

时间:2010-01-11

来源:互联网


$friends = array();
$query = $_SGLOBAL['db']->query("SELECT f.fusername, s.name, s.namestatus,f.fuid,sf.mobile FROM ".tname('friend')." f,".tname('space')." s,".tname('spacefield')." sf  WHERE f.uid=$_SGLOBAL[supe_uid] AND f.status='1' AND s.uid=f.fuid AND sf.uid=f.fuid ORDER BY f.num DESC, f.dateline DESC");
while ($value = $_SGLOBAL['db']->fetch_array($query)) {
  $friends[] = $value;
  //查询是否有学校
                  $query1=$_SGLOBAL['db']->query("SELECT title FROM ".tname('spaceinfo')." WHERE uid =$value[fuid] AND type='edu' ");
          //  print $query1;
            $value1 = $_SGLOBAL['db']->fetch_array($query1);
            if(!empty($value1)) {
             $friends['school'] =$value1;
            }
}
print_r($friends);
打印结果:
Array (
         [0] => Array (
                          [fusername] => liuxiong
                          [name] => 刘熊
                          [namestatus] => 1
                          [fuid] => 5
                          [mobile] => 13007145070
                        )
         [school] => Array ( [title] => 湖北大学 )
 )
为什么我查询学校的数据无法存储到$friends数组里面?
我想得到这样的数据,如下
Array (
         [0] => Array (
                          [fusername] => liuxiong
                          [name] => 刘熊
                          [namestatus] => 1
                          [fuid] => 5
                          [mobile] => 13007145070
                          [school] =>湖北大学
                        )
 )
我该怎么实现?代码哪里有问题

作者: xx24578   发布时间: 2010-01-11

复制代码
  1. while ($value = $_SGLOBAL['db']->fetch_array($query)) {
  2. $friends[] = $value;
  3. //查询是否有学校
  4. $query1=$_SGLOBAL['db']->query("SELECT title FROM ".tname('spaceinfo')." WHERE uid =$value[fuid] AND type='edu' ");
  5. // print $query1;
  6. $value1 = $_SGLOBAL['db']->fetch_array($query1);
  7. if(!empty($value1)) {
  8. $friends['school'] =$value1;
  9. } //while语句确定是要到这里吗,循环里面有点乱,之所以没有输出是因为$value1一直是空,所以根本没有取到值

作者: tafengnanhai   发布时间: 2010-01-11

热门下载

更多