get field names from mysql_fetch_object

[delpino]

Hi..

can i get all the field names from $row? and put all the field names in an array for example.

mysql_connect ($host, $user, $password);
$result = mysql_db_query ("database", "select * from table");
$row = mysql_fetch_object ($result);

ps: i have php3.0.5 on my server, so it should work in that environment

[delpino]

or even better if a table has the following field names ID,user,password, etc i want them to put automatically in $ID,$user,$password, etc in one go. i think i have seen a solution/command for PHP4. is there any for PHP3.0.5 ?

[Anon]

http://www.php.net/manual/en/function.mysql-field-name.php