Subversion Repositories computer_asset_manager_v1

Rev

Rev 38 | Rev 87 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 38 Rev 52
Line 1... Line 1...
1 
<?php
 1 
<?php
- 
 
 2 
   include_once( './database.php' );
2 
 
 3
3 
   define(SQL_GET_PACKAGES,
 4 
   define(SQL_GET_PACKAGES,
4 
          'select client.name,device.name,software.package_name,software_version.version
 5 
          'select client.name,device.name,software.package_name,software_version.version
5 
           from client join site on client.client_id = site.client_id
 6 
           from client join site on client.client_id = site.client_id
6 
                join device on device.site_id = site.site_id
 7 
                join device on device.site_id = site.site_id
7 
                join installed_packages on device.device_id = installed_packages.device_id
 8 
                join installed_packages on device.device_id = installed_packages.device_id