note 68431 added to function.mysql-field-name

i figured this little diddy, if you are trying to get all the field names from your table, but don't feel like doing all that typing. here is this little snippit. you just have to know what your field names are to call them $query = "SELECT * FROM your_table"; $results = mysql_query($query); $numberfields = mysql_num_fields($results); $row = mysql_fetch_object($results); for ($i=0; $i<$numberfields ; $i++ ) { $var = mysql_field_name($results, $i); $$var = $row->$var; } echo $fieldname; cheers. James ---- Server IP: 66.163.161.117 Probable Submitter: 74.62.28.28 ---- X-Spam-Status: No, hits=3.1 required=5.0 tests=DATE_MISSING,FROM_NO_LOWER autolearn=no version=2.64 ---- Manual Page -- http://www.php.net/manual/en/function.mysql-field-name.php Edit -- http://master.php.net/note/edit/68431 Del: integrated -- http://master.php.net/note/delete/68431/integrated Del: useless -- http://master.php.net/note/delete/68431/useless Del: bad code -- http://master.php.net/note/delete/68431/bad+code Del: spam -- http://master.php.net/note/delete/68431/spam Del: non-english -- http://master.php.net/note/delete/68431/non-english Del: in docs -- http://master.php.net/note/delete/68431/in+docs Del: other reasons-- http://master.php.net/note/delete/68431 Reject -- http://master.php.net/note/reject/68431 Search -- http://master.php.net/manage/user-notes.php