array('data' => 'Ariketa', 'field' => 'n.title', 'sort' => 'asc'), 'Fitxategia' => array('data' => 'Fitxategia', 'field' => 'filename', 'sort' => 'asc'), 'Akatsa' => array('data' => 'Akatsa', 'field' => 'pn.title', 'sort' => 'asc'), 'Tamaina', ); $order = isset($_GET['order']) ? $headers[$_GET['order']]['field'] : 'n.title'; $sort = isset($_GET['sort']) ? $_GET['sort'] : 'asc'; $order_by = " ORDER BY $order $sort"; $result = db_query('SELECT n.title, filename, filesize, filepath, n.nid, pn.nid pn_nid, pn.title pn_title FROM `upload` u LEFT JOIN files f ON u.fid = f.fid LEFT JOIN node n ON u.vid = n.vid LEFT JOIN node_relations nr ON n.nid = nr.nid AND nr.type = "509" LEFT JOIN node pn ON nr.pnid = pn.nid WHERE n.type = "ariketa" AND f.filemime = "audio/mpeg" '.$order_by); while($row = db_fetch_object($result)){ $title = l($row->title, "node/$row->nid"); $file = l($row->filename, $row->filepath); $akats = l($row->pn_title, "node/$row->pn_nid"); $rows[] = array($title, $file, $akats, number_format($row->filesize/(1024*8), 2) .' KB.'); } print theme('table', $headers, $rows); ?>