如何让php将数据库存的字段显示出来？

Question

<form action="index.php?" method="post" name="form1" id="form1" onSubmit="form1.postit.value='Please wait';form1.postit.disabled=true;return true;">
  <table width="780" border="0" align="center" cellpadding="4" cellspacing="1" class="table">
    <tr>
      <td colspan="4" class="head">leave a message</td>
    </tr>
    <tr>
      <td width="61" class="x_line">E-mail:</td>
      <td class="x_line" width="335"><input name="name" type="text" class="text" id="name" value="" maxlength="30" /></td>
      <td width="120" class="x_line"><input name="name2" type="text" class="text" id="name2" value="" maxlength="30" /></td>
      <td width="225" class="x_line">&nbsp;</td>
    </tr>
    <tr>
      <td class="x_line">Message:</td>
      <td colspan="3" class="x_line"><textarea name="post" cols="80" rows="10" id="post"></textarea></td>
    </tr>
    <tr>
      <td colspan="4"><div align="center">
        <input name="postit" type="submit" class="button" id="postit" value="post" onClick="return checkit()"/>
         &nbsp;&nbsp;
         <input name="reset" type="reset" class="button" id="reset" value="reset" />
        <input name="postnow" type="hidden" id="postnow" value="post message" />
      </div></td>
    </tr>
  </table>
  <br />
  <table width="780" border="0" align="center" cellpadding="4" cellspacing="1" class="table">
    <tr>
      <td align="center" class="smalltxt_more">Powered by YouDi &copy;<a href="http://www.snsnsky.com/bbs" target="_blank"></a> All Right   Reserved      </td>
    </tr>
  </table>
</form>
</body>
</html>
<!--Powered by snsnsky v1.01 2005-2006 All Right Reserved-->

Answer 1

1\你用php的函数mysql_list_fields来得到表名信息，具体用法参考手册
2\你执行SHOW COLUMNS FROM [DATABASES.]TableName

Answer 2

$cfg_host = "192.168.1.1"; //主机名
$cfg_username = "root"; //用户名
$cfg_password = ""; //用户密码
$cfg_database = ""; //数据库名$Connect=mysql_connect($cfg_host,$cfg_username,$cfg_password);
$T=mysql_list_fields($cfg_database,$TableName,$Connect); 
$Fields=mysql_num_fields($T); 
for($i=0;$i<$Fields;$i++)
{
$f=mysql_field_name($T,$i); 
$t=mysql_field_type($T,$i);
$l=mysql_field_len($T,$i);
$flag=mysql_field_flags($T,$i);
        }php中文手册讲得很详细