Waypoints & Landeninfo

 Naam:Grootte:Type:Toegevoegd op:'; $i = 0; $query = "SELECT * FROM downloads WHERE category=1 ORDER BY id DESC"; $result = mysql_query($query) or die('Er is een fout opgetreden tijdens het verkrijgen van de downloads: '.mysql_error()); while ($result_row = mysql_fetch_row($result)) { $i++; //Get the filename, without the file extension (like for example .doc or .pdf) $filename = explode('.', preg_replace('/^\.\.\/doc\/uploads\//', '', $result_row[1])); $extension = array_pop($filename); $filename = implode('.', $filename); $date = explode(' ',$result_row[4]); $date[0] = explode('-', $date[0]); $date[0] = $date[0][2].'-'.$date[0][1].'-'.$date[0][0]; $date = implode(' ', $date); $output .= ''.$i.''; $output .= ''.$result_row[2].''; $output .= ''.$result_row[5].' kb'; $output .= ''.$extension.''; $output .= ''.$date.''; $output .= ''; } $output .= ''; if ($i > 0) { echo $output; } include('../include/end.txt'); ?>