query("SELECT * FROM tourenliste WHERE typ=13 and kw='".$kw."' and jahr='".$jahr."'"); while($row = $stour->fetch_assoc()) { $m_data = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'"); $test_data = $GLOBALS['rasql']->query_single("SELECT * FROM fahrer WHERE tour='".$row['tour']."'"); //-------------- tournummerid herausfinden $oid = $GLOBALS['mysql']->query_single("SELECT * FROM touren WHERE id='".$row['tour']."'"); $tid = $GLOBALS['rasql']->query_single("SELECT * FROM touren WHERE tour='".$oid['tour']."'"); echo "orginalJB: ".$oid['tour']." MPV: ".$tid['id']."
"; if($test_data['num_rows'] != 0) { $GLOBALS['rasql']->insert("UPDATE fahrer SET name='".$m_data['name']."' WHERE tour='".$tid['id']."'"); $GLOBALS['rasql']->insert("UPDATE fahrer SET nummer='".$m_data['handy']."' WHERE tour='".$tid['id']."'"); echo "name: ".$m_data['name']." - Tourid: ".$tid['id']; $GLOBALS['rasql']->insert("UPDATE tliste SET fahrer='".$m_data['name']."' WHERE tour='".$tid['id']."' and kw='".$kw."' and jahr='".$jahr."'"); $GLOBALS['rasql']->insert("UPDATE tliste SET fahrernummer='".$m_data['handy']."' WHERE tour='".$tid['id']."' and kw='".$kw."' and jahr='".$jahr."'"); } else { $GLOBALS['rasql']->insert("INSERT INTO fahrer (name,nummer,tour) VALUES( '".$m_data['name']."', '".$m_data['handy']."', '".$tid['id']."') "); $GLOBALS['rasql']->insert("UPDATE tliste SET fahrer='".$m_data['name']."' WHERE tour='".$tid['id']."' and kw='".$kw."' and jahr='".$jahr."'"); $GLOBALS['rasql']->insert("UPDATE tliste SET fahrernummer='".$m_data['handy']."' WHERE tour='".$tid['id']."' and kw='".$kw."' and jahr='".$jahr."'"); } } //---------------------------------------------------------------------------------------------------------- //---------------------------------------------------------------------------------------------------------- //---------------------------------------------------------------------------------------------------------- $stour = $GLOBALS['mysql']->query("SELECT * FROM tourenliste WHERE typ=19 and kw='".$kw."' and jahr='".$jahr."'"); while($row = $stour->fetch_assoc()) { $test_data = $GLOBALS['rasql']->query_single("SELECT * FROM fahrer WHERE tour='".$row['tour']."'"); if($test_data['num_rows'] != 0) { $m_data = $GLOBALS['mysql']->query_single("SELECT * FROM mitarbeiter WHERE id='".$row['fahrer']."'"); $GLOBALS['rasql']->insert("UPDATE fahrer SET name='".$m_data['name']."' WHERE tour='".$row['tour']."'"); $GLOBALS['rasql']->insert("UPDATE fahrer SET nummer='".$m_data['handy']."' WHERE tour='".$row['tour']."'"); $GLOBALS['rasql']->insert("UPDATE tliste SET fahrer='".$m_data['name']."' WHERE tour='".$row['tour']."'"); $GLOBALS['rasql']->insert("UPDATE tliste SET fahrernummer='".$m_data['handy']."' WHERE tour='".$row['tour']."'"); echo "name: ".$m_data['name']." - Tourid: ".$row['tour']."
"; } else { $GLOBALS['rasql']->insert("INSERT INTO fahrer (name,nummer,tour) VALUES( '".$m_data['name']."', '".$m_data['handy']."', '".$row['tour']."') "); $GLOBALS['rasql']->insert("UPDATE tliste SET fahrer='".$m_data['name']."' WHERE tour='".$row['tour']."'"); $GLOBALS['rasql']->insert("UPDATE tliste SET fahrernummer='".$m_data['handy']."' WHERE tour='".$row['tour']."'"); } } // } //mysql_close($GLOBALS['mysql']); //mysql_close($GLOBALS['rasql']); echo"fertig_saso nummer copy"; ?>