[PHP-DB] PHP+MySQL PROBLEM: mysql_fetch_fields mess?

[Davor Pleskina]

Hi Everyone,

Is it just me, or something is BADLY wrong with some MySQL functions?
Is there some rule in which order to call mysql functions?
I made following routine:

<!--- code start -->
<?php
    function prikazi_masku($tablica, $key_field, $key_value) {
        global $mycon_id;
        $data = mysql_query("SELECT * FROM $tablica WHERE $key_field='" .
$key_value . "'", $mycon_id);
        if(!$data) {
                echo("MySQL Error: " . mysql_error() . "<br>");
                return 0;
        };
        if(mysql_affected_rows()==0) {
                echo('No data.<br>');
                return 0;
        };

        echo("<table border=1 bgcolor=#e0e0e0 bordercolor=#e0e0e0
cellspacing=1 cellpadding=3>");
        echo("<tr bgcolor=#800080>");

        // First field and its value I show in different color
        $meta = mysql_fetch_field ($data);
        $data_row = mysql_fetch_array ($data);

        // Here I want to get number of fields
        $n = mysql_num_fields($data);
        echo("<td><b><font color=white>$meta->name</td>");
        echo("<td><b><font color=white>$data_row[0]</td></tr>");
        $i = 1;

        // Now I show fields from index 1 to the last field
        while ($i < $n) {
            $meta = mysql_fetch_field($data);
            echo("<tr><td>$meta->name</td><td>$data_row[i]</td></tr>");
            $i++;
        };

        echo("</table>");
        return 1;
    };
?>
<!-- code end -->

Table I tried to show has 7 fields; first row (first field) show OK, but the
rest ARE EMPTY!!!
I tried to change the order of functions or anything, but it seems that
after first acces of mysql_fetch_field something happens to $data_row?!?
Can someone explain this and help me work out with it?

TIA
Davor



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]