query($query); $output = ""; while($row = $adb->fetch_array($result)) { $selected = ''; if($value != '' && $row[$tableColumn] == $value) { $selected = 'selected'; } $output .= "".$row[$tableColumn].""; } $output .= ""; return $output; } function getTicketList() { global $adb; $query = "select troubletickets.id,groupname,contact_id,priority,troubletickets.status,parent_id,parent_type,category,troubletickets.title,troubletickets.description,update_log,version_id,troubletickets.date_created,troubletickets.date_modified,troubletickets.assigned_user_id,contacts.first_name,contacts.last_name,users.user_name from troubletickets left join contacts on troubletickets.contact_id=contacts.id left join users on troubletickets.assigned_user_id=users.id where troubletickets.deleted=0"; $result = $adb->query($query); return $result; } function getFaqList() { global $adb; $query = "select faq.id,question,answer,category,author_id,users.id,users.user_name from faq left join users on faq.author_id=users.id where faq.deleted ='0'"; $result = $adb->query($query); return $result; } ?>