Waypoints & Landeninfo
$output = '
| 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');
?>