[88mph]

right, used this and it worked

PHP Code:

<?php
        $value_array = array(    'item_type',
                                'title', 
                                'brand', 
                                'model', 
                                'serial_no',
                                'replacement_cost',
                                'quantity',
                                'kit_content',
                                'main_location',
                                'current_location',
                                'notes');
        
    $result = get_all_inventory();
      
    while( $inventory = mysql_fetch_array($result)) {
        $output = "<tr>";
            
            foreach($value_array as $cell){
                     $output .="<td>{$inventory[$cell]}</td>";
               };
            
            $output .= "</tr>";
            echo $output;
        }
        
        ?>