require ('mysql-config.php');
$conn_id = mysql_connect("$host","$myuser","$mypass") or die("Verbindung zur Datenbank fehlgeschlagen");
mysql_select_db("$db",$conn_id);
$result10 = mysql_query("SELECT * FROM oc_akten WHERE a1dep='D' ");
$result11 = mysql_query("SELECT * FROM oc_akten WHERE a1dep='D' ");
$result12 = mysql_query("SELECT * FROM oc_akten WHERE a1dep='D' ");
$result13 = mysql_query("SELECT * FROM oc_akten WHERE a1dep='D' ");
$result20 = mysql_query("SELECT * FROM oc_akten WHERE a1dep='SD' ");
$result21 = mysql_query("SELECT * FROM oc_akten WHERE a1dep='SD' ");
$result22 = mysql_query("SELECT * FROM oc_akten WHERE a1dep='SD' ");
$result23 = mysql_query("SELECT * FROM oc_akten WHERE a1dep='SD' ");
$result30 = mysql_query("SELECT * FROM oc_akten WHERE a1dep='M' ");
$result31 = mysql_query("SELECT * FROM oc_akten WHERE a1dep='M' ");
$result32 = mysql_query("SELECT * FROM oc_akten WHERE a1dep='M' ");
$result33 = mysql_query("SELECT * FROM oc_akten WHERE a1dep='M' ");
echo"
|
|
|
A1 Personal |
Personalchef |
Status |
Rang |
Name |
Aufgabenbereich/Sektion |
|
"; while($per = mysql_fetch_array($result10)) { echo"$per[status] "; }echo" |
"; while($per = mysql_fetch_array($result11)) { echo" $per[rang] "; }echo" |
"; while($per = mysql_fetch_array($result12)) { echo" $per[vorname] $per[name] "; }echo" |
"; while($per = mysql_fetch_array($result13)) { echo" $per[a1bemerkung] "; }echo" |
|
Personalhauptverwalter |
Status |
Rang |
Name |
Aufgabenbereich/Sektion |
|
"; while($per = mysql_fetch_array($result20)) { echo"$per[status] "; }echo" |
"; while($per = mysql_fetch_array($result21)) { echo" $per[rang] "; }echo" |
"; while($per = mysql_fetch_array($result22)) { echo" $per[vorname] $per[name] "; }echo" |
"; while($per = mysql_fetch_array($result23)) { echo" $per[a1bemerkung] "; }echo" |
|
Status |
Rang |
Name |
Aufgabenbereich/Sektion |
|
"; while($per = mysql_fetch_array($result30)) { echo"$per[status] "; }echo" |
"; while($per = mysql_fetch_array($result31)) { echo" $per[rang] "; }echo" |
"; while($per = mysql_fetch_array($result32)) { echo" $per[vorname] $per[name] "; }echo" |
"; while($per = mysql_fetch_array($result33)) { echo" $per[a1bemerkung] "; }echo" |
|
|
|
";
?>