从数据库中取出数据，存放到数组中，然后对数据进行分类显示

<table width="280" id="zhangdan_wenzi" >
  <?php
  //food_typ id 将id存到数组中
  $sqlfood = "SELECT food_type.id FROM  food_type ";
  $resultfood=mysql_query($sqlfood);
  $arrayinfo=array();
  global $arrayinfo;
  while($food=mysql_fetch_array($resultfood)){
	      //将点菜数量的数据写入到数据库中返回的数组中    
    	array_push($arrayinfo,$food[id]);
		
  }
  //print $arrayinfo[20];
 
  $num = mysql_num_rows($resultfood); 
  
      for($i=0;$i<$num;$i++){
		  //food_type  名字
		 
	  $sqlfood1 = "SELECT food_type.name FROM  food_type where id="$arrayinfo[$i]"";
      $resultfood1=mysql_query($sqlfood1);
      $food1=mysql_fetch_array($resultfood1);
	  //food
	  $food_typeid=$arrayinfo[$i];
	  $sqlfood2 = "SELECT * FROM  food  where food_type= "$food_typeid" order by pybm asc  ";
      $resultfood2=mysql_query($sqlfood2);
  ?>
  <tr >
    <td>
      <a href="#" onclick="showObj(<?php echo $i ?>)"><?php echo $food1[name];?></a>
      <div id="odiv" style="display:none">
   <ul>
   <?php
   while($food2=mysql_fetch_array($resultfood2)){
   ?>
   <li><a href=""><?php echo $food2[foodname]; ?></a></li>
   <?php  
   }
   ?>
   </ul>
   </div>
    </td>
  </tr>
  <?php
  }
  ?>
</table>

关键代码：

$sqlfood = "SELECT food_type.id FROM  food_type ";
  $resultfood=mysql_query($sqlfood);
  $arrayinfo=array();
  global $arrayinfo;
  while($food=mysql_fetch_array($resultfood)){
	      //将点菜数量的数据写入到数据库中返回的数组中    
    	array_push($arrayinfo,$food[id]);
		
  }

利用array_push()函数，将数据存放到$arrayinfo数组中，下面就可以利用for将它的每个值输出