I want to show most of list include video card in one screen sorting by system name. but Some computers shows 2 video cards. So it shows duplicated system with 1 video card,and next line 2nd video card. Is there a way to modify sql key to grab and shows 1 system with 2 video cards in one line ?
This is what i did, but it shows twice of current systems.
"sql"=>"SELECT * FROM `system`, `processor`, `hard_drive`, `video` WHERE system_uuid = hard_drive_uuid AND system_uuid = processor_uuid AND system_uuid = video_uuid AND hard_drive_uuid = processor_uuid AND system_timestamp = processor_timestamp AND system_timestamp = hard_drive_timestamp AND processor_device_id = 'CPU0' AND hard_drive_index = 0"
and this for listing "fields"=>array("10"=>array("name"=>"system_uuid", "head"=>__("UUID"), "show"=>"n", ), "155"=>array("name"=>"video_caption", "head"=>__("Video"), "show"=>"y", )
Any help will be appreciated.
|