php 問題

php

gavinnokia 2011-09-15 18:15:15 ‧ 3577 瀏覽

分享至

一直出現
mysql_field_name() [function.mysql-field-name]: Field 4 is invalid for MySQL result index 4

$export = mysql_query($Recordseta);
$fields = mysql_num_rows($export); // thanks to Eric
echo $fields;
for ($i = 0; $i &lt; $fields; $i++) {
$col_title .= '&lt;td>'.mysql_field_name($export, $i).'&lt;/td>';
}
$col_title = '&lt;tr>'.$col_title.'&lt;/tr>'; &lt;&lt;&lt; 一直說這行有問題.

while($row = mysql_fetch_row($export)) {
        $line = '';
        foreach($row as $value) {
                if ((!isset($value)) OR ($value == "")) {
                        $value = "\t";
                } else {
                        $value = str_replace('"', '', $value);
                        $value = '&lt;td>' . $value . '&lt;/td>' . "\t";
                }
                $line .= $value;
        }
        $data .= trim("&lt;tr>".$line."&lt;/tr>")."\n";
}

$data = str_replace("\r","",$data);

請問如何修正.
ps:遇到有流水號的就沒有問題.但是沒有流水號的就出現下列錯誤.
mysql_field_name() [function.mysql-field-name]: Field n is invalid for MySQL result index n