mysql遍历输出数据库表字段信息

<?php
mysql_connect("127.0.0.1:3336","root","myoa888");
mysql_select_db("TD_OA");
$ip=$_SERVER['REMOTE_ADDR'];
$sql="SELECT
 
column_name AS `列名`,
 
data_type   AS `数据类型`,
 
character_maximum_length  AS `字符长度`,
 
numeric_precision AS `数字长度`,
 
numeric_scale AS `小数位数`,
 
is_nullable AS `是否允许非空`,
 
column_default  AS  `默认值`,
 
column_comment  AS  `备注`
 
FROM
 
Information_schema.columns
 
WHERE TABLE_SCHEMA='TD_OA' and 
 
table_Name='sys_function' order by ORDINAL_POSITION asc";

$q=mysql_query($sql);

	echo "<table border=1>";
	echo "<tr style='background-color:#ccc'>";
	echo "<td>列名</td>";
	echo "<td>字段描述</td>";
	echo "<td>数据类型</td>";
	echo "<td>字符长度</td>";
	echo "<td>数字长度</td>";
	echo "<td>小数位数</td>";
	echo "<td>是否允许非空</td>";
	echo "<td>默认值</td>";
	echo "</tr>";
$i=2;
while($r=mysql_fetch_array($q)){
	
	if((abs($i)+2)%2==1){
	echo "<tr style='background-color:#eee'>";
	}else{
	echo "<tr>";
	}



	echo "<td>".$r[列名]."</td>";
	echo "<td>".$r[备注]."</td>";
	echo "<td>".$r[数据类型]."</td>";
	echo "<td>".$r[字符长度]."</td>";
	echo "<td>".$r[数字长度]."</td>";
	echo "<td>".$r[小数位数]."</td>";
	echo "<td>".$r[是否允许非空]."</td>";
	echo "<td>".$r[默认值]."</td>";
	echo "</tr>";
	$i++;
	
}
	echo "</table>";

?>