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:

<?php
//check get data

if ( !isset($_GET['s'])) { 
$s =  "1"; // zb 
} else  
$s = $_GET['s'];

//zur DB connecten
$db = mysql_connect("localhost", "root", "");
//db auswählen
mysql_select_db("test", $db);


// MySQL-Abfrage starten
$sql = "SELECT `category` FROM `category` WHERE `id` = '" . addslashes($s) . "'"; 
$result = mysql_query($sql);
$data = mysql_fetch_array($result);
echo $data['category'];

// MySQL-Abfrage starten
$sql = "SELECT * FROM nfo WHERE category='" . addslashes($s) . "'"; 
$result = mysql_query($sql);

while($data = mysql_fetch_array($result)) {
        echo "        <tr>";
        echo '<td style="text-align:center;">', $data['datum'], '</td>';
        echo "                            <td>".$data['nfo_name']."</td>";
        echo '<td style="text-align:center;">', $data['group'], '</td>';
        echo '<td style="text-align:center;">', $data['nfo'], '</td>';
        echo '<td style="text-align:center;">', $data['link'], '</td>';
		echo "        <tr>";
}

// MySQL-Abfrage starten
$sql = "SELECT * FROM nfo WHERE category=".$_GET['id']." AND name LIKE '%".$_GET['search']."%'";
$result = mysql_query($sql);

?>