Subversion Repositories computer_asset_manager_v1

Rev

Rev 101 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 101 Rev 102
Line 19... Line 19...
19
      //$deleteField = queryHTMLLink( 'modules/file/delete.php?file_id=', 'file.file_id', "'Delete'" );
19
      //$deleteField = queryHTMLLink( 'modules/file/delete.php?file_id=', 'file.file_id', "'Delete'" );
20
      //$editField = queryHTMLLink( 'modules/file/upload_file.html?file_id=', 'file.file_id', "'Edit'" );
20
      //$editField = queryHTMLLink( 'modules/file/upload_file.html?file_id=', 'file.file_id', "'Edit'" );
21
      //concat( '<a href=\"', file.file_id, '\"', 'target=\"_blank\">', file.name, '</a>')      
21
      //concat( '<a href=\"', file.file_id, '\"', 'target=\"_blank\">', file.name, '</a>')      
22
      $query = "select 
22
      $query = "select 
23
                   attrib.name 'Name', 
23
                   attrib.name 'Name', 
24
                   attrib_device.value 'Description', 
24
                   attrib_device.value 'Description'
25
                   attrib_device.added_date 'Added'
-
 
26
                from attrib_device
25
                from attrib_device
27
                     left outer join attrib using (attrib_id)
26
                     left outer join attrib using (attrib_id)
28
                     $join
27
                     $join
29
                where
28
                where
30
                   $where
29
                   $where