1: 
2: 
3: 
4: 
5: 
6: 
7: 
8: 
9: 
10: 
11: 
12: 
13: 
14: 
15: 
16: 
17: 
18: 
19: 
20: 
21: 
22: 
23: 
24: 
25: 
26: 
27: 
28: 
29: 
30: 
31: 
32: 
33: 
34: 
35: 
36: 
37: 
38: 
39: 
40: 
41: 
42: 
43: 
44: 
45: 
46: 
47: 
48: 
49: 
50: 
51: 
52: 
53: 
54:

# phpMyAdmin MySQL-Dump
# version 2.3.0
# http://phpwizard.net/phpMyAdmin/
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Generation Time: Jun 27, 2003 at 03:01 AM
# Server version: 3.23.54
# PHP Version: 4.3.0
# Database : `nfo`
# --------------------------------------------------------

#
# Table structure for table `category`
#

CREATE TABLE category (
  id int(255) NOT NULL auto_increment,
  category varchar(255) NOT NULL default '',
  PRIMARY KEY  (id,category)
) TYPE=MyISAM;

#
# Dumping data for table `category`
#

INSERT INTO category VALUES (3, 'DivX');
INSERT INTO category VALUES (4, 'Movies');
INSERT INTO category VALUES (5, 'Games');
# --------------------------------------------------------

#
# Table structure for table `nfo`
#

CREATE TABLE nfo (
  id int(10) NOT NULL auto_increment,
  nfo_name varchar(255) NOT NULL default '',
  `group` varchar(255) NOT NULL default '',
  category int(10) NOT NULL default '0',
  nfo varchar(255) NOT NULL default '',
  link varchar(255) NOT NULL default '',
  datum date NOT NULL default '0000-00-00',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table `nfo`
#

INSERT INTO nfo VALUES (8, '', '', 0, 'acp-coadm.png', '', '2003-05-01');
INSERT INTO nfo VALUES (6, 'Confessions of a Dangerous Mind (2002)', 'ACP', 4, 'acp-coadm.png', '', '2003-04-30');
INSERT INTO nfo VALUES (7, 'test', 'test', 5, 'ims-ha.png', '', '2003-04-30');
INSERT INTO nfo VALUES (9, 'test', '', 0, '', '', '2003-06-11');

1: 
2: 
3: 
4: 
5: 
6: 
7: 
8: 
9: 
10: 
11: 
12: 
13: 
14: 
15: 
16:

1: 
2: 
3: 
4: 
5: 
6: 
7: 
8: 
9: 
10: 
11:

SELECT 
    `Datum`, 
    `Titel`, 
    `groupe`,
    `nfo`, 
    `link`,
... 
FROM 
    `NFOs` 
WHERE 
    `Kategorie` = '$_GET['s']'