query("SELECT * FROM mitarbeiter ORDER BY id"); while($row = $ma->fetch_assoc()) { // alles löschen $mx=$GLOBALS['mysql']->summe("SELECT * FROM ma_ttyp WHERE maid='".$row['id']."'"); if ($mx!=0) { $GLOBALS['mysql']->update("delete * FROM ma_ttyp WHERE maid='".$row['id']."'"); } if ($row['paket']!=0) { $GLOBALS['mysql']->insert("INSERT INTO ma_ttyp (maid,ttyp) VALUES('".$row['id']."',1)"); } if ($row['gh']!=0) { $GLOBALS['mysql']->insert("INSERT INTO ma_ttyp (maid,ttyp) VALUES('".$row['id']."',3)"); } if ($row['lvz']!=0) { $GLOBALS['mysql']->insert("INSERT INTO ma_ttyp (maid,ttyp) VALUES('".$row['id']."',4)"); } if ($row['pin']!=0) { $GLOBALS['mysql']->insert("INSERT INTO ma_ttyp (maid,ttyp) VALUES('".$row['id']."',5)"); } if ($row['post']!=0) { $GLOBALS['mysql']->insert("INSERT INTO ma_ttyp (maid,ttyp) VALUES('".$row['id']."',6)"); } if ($row['rs']!=0) { $GLOBALS['mysql']->insert("INSERT INTO ma_ttyp (maid,ttyp) VALUES('".$row['id']."',7)"); } if ($row['saso']!=0) { $GLOBALS['mysql']->insert("INSERT INTO ma_ttyp (maid,ttyp) VALUES('".$row['id']."',8)"); } if ($row['mp']!=0) { $GLOBALS['mysql']->insert("INSERT INTO ma_ttyp (maid,ttyp) VALUES('".$row['id']."',10)"); } if ($row['werb']!=0) { $GLOBALS['mysql']->insert("INSERT INTO ma_ttyp (maid,ttyp) VALUES('".$row['id']."',11)"); } if ($row['mb']!=0) { $GLOBALS['mysql']->insert("INSERT INTO ma_ttyp (maid,ttyp) VALUES('".$row['id']."',12)"); } if ($row['tip']!=0) { $GLOBALS['mysql']->insert("INSERT INTO ma_ttyp (maid,ttyp) VALUES('".$row['id']."',13)"); } if ($row['werb']!=0) { $GLOBALS['mysql']->insert("INSERT INTO ma_ttyp (maid,ttyp) VALUES('".$row['id']."',14)"); } if ($row['faz']!=0) { $GLOBALS['mysql']->insert("INSERT INTO ma_ttyp (maid,ttyp) VALUES('".$row['id']."',15)"); } if ($row['pleer']!=0) { $GLOBALS['mysql']->insert("INSERT INTO ma_ttyp (maid,ttyp) VALUES('".$row['id']."',16)"); } if ($row['lvzz']!=0) { $GLOBALS['mysql']->insert("INSERT INTO ma_ttyp (maid,ttyp) VALUES('".$row['id']."',17)"); } if ($row['sasoz']!=0) { $GLOBALS['mysql']->insert("INSERT INTO ma_ttyp (maid,ttyp) VALUES('".$row['id']."',18)"); } if ($row['saso']!=0) { $GLOBALS['mysql']->insert("INSERT INTO ma_ttyp (maid,ttyp) VALUES('".$row['id']."',19)"); } if ($row['sonstige']!=0) { $GLOBALS['mysql']->insert("INSERT INTO ma_ttyp (maid,ttyp) VALUES('".$row['id']."',20)"); } if ($row['sonstige']!=0) { $GLOBALS['mysql']->insert("INSERT INTO ma_ttyp (maid,ttyp) VALUES('".$row['id']."',99)"); } echo 'Mitarbeiter: '.$row['name'].'
'; } echo "

"; print_r($output); echo "

"; //----------------------------------------------------------- ?>