Daten in eigene Tabellen schreiben...

Harlekin · Beitrag von **Harlekin** » Mi 21. Jan 2004, 11:38

Hallo,

weis jemand wie man dateen in eine eigene Tabelle schreiben kann? ich habe probiert es auszulesen, komm aber nicht zurande... Ich habe ein Workaround aber da kann es passieren das 2* ein gleicher datensatz mit der selben idcat vorhaden ist.... hier mein skript.... ich versteh auch nicht wie ich die contenido daten benutzen kann so muss ich immer die db userdaten angeben. Wär super wenn sich das einer von euch profies mal anschaun könnte.

THX Josh

Code: Alles auswählen

$hostname_Axel = "localhost";
$database_Axel = "xxxxx";
$username_Axel = "xxxxx";
$password_Axel = "xxxxx";
$Axel = mysql_pconnect($hostname_Axel, $username_Axel, $password_Axel) or die(mysql_error());

mysql_select_db($database_Axel, $Axel);
$query_tour = "SELECT * FROM daten, dates, preise, touren, veran";
$tour = mysql_query($query_tour, $Axel) or die(mysql_error());
$row_tour = mysql_fetch_assoc($tour);
$totalRows_tour = mysql_num_rows($tour);

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}

$editFormAction = $HTTP_SERVER_VARS['PHP_SELF'];
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
  $editFormAction .= "?" . $HTTP_SERVER_VARS['QUERY_STRING'];
}

if ((isset($HTTP_POST_VARS["MM_insert"])) && ($HTTP_POST_VARS["MM_insert"] == "tour")) {
  $insertSQL = sprintf("INSERT INTO daten (buch, dau, EZT, GRT, Verpfleg, laenge, leist, bh_ap, erm, fahr, sonst) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($HTTP_POST_VARS['buch'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['dau'], "text"),
					   GetSQLValueString(isset($HTTP_POST_VARS['EZT']) ? "true" : "", "defined","1","0"),
                       GetSQLValueString(isset($HTTP_POST_VARS['GRT']) ? "true" : "", "defined","1","0"),
                       GetSQLValueString($HTTP_POST_VARS['Verpfleg'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['laenge'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['leist'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['bh_ap'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['erm'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['fahr'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['sonst'], "text"));

  mysql_select_db($database_Axel, $Axel);
  $Result1 = mysql_query($insertSQL, $Axel) or die(mysql_error());
}

$daten = mysql_insert_id($Axel);

if ((isset($HTTP_POST_VARS["MM_insert"])) && ($HTTP_POST_VARS["MM_insert"] == "tour")) {
  $insertSQL = sprintf("INSERT INTO dates (ID, sp1, sp2, sp3, sp4, sp5, sp6, sp7, sp8, sp9, sp10, z1, z2, z3, z4, z5, z6, z7, z8, z9, z10, vs1, vs2, vs3, vs4, vs5, vs6, vs7, vs8, vs9, vs10, bs1, bs2, bs3, bs4, bs5, bs6, bs7, bs8, bs9, bs10, vz1, vz2, vz3, vz4, vz5, vz6, vz7, vz8, vz9, vz10, bz1, bz2, bz3, bz4, bz5, bz6, bz7, bz8, bz9, bz10, dv_s1z1, dv_s1z2, dv_s1z3, dv_s1z4, dv_s1z5, dv_s1z6, dv_s1z7, dv_s1z8, dv_s1z9, dv_s1z10, db_s1z1, db_s1z2, db_s1z3, db_s1z4, db_s1z5, db_s1z6, db_s1z7, db_s1z8, db_s1z9, db_s1z10, dv_s2z1, dv_s2z2, dv_s2z3, dv_s2z4, dv_s2z5, dv_s2z6, dv_s2z7, dv_s2z8, dv_s2z9, dv_s2z10, db_s2z1, db_s2z2, db_s2z3, db_s2z4, db_s2z5, db_s2z6, db_s2z7, db_s2z8, db_s2z9, db_s2z10, dv_s3z1, dv_s3z2, dv_s3z3, dv_s3z4, dv_s3z5, dv_s3z6, dv_s3z7, dv_s3z8, dv_s3z9, dv_s3z10, db_s3z1, db_s3z2, db_s3z3, db_s3z4, db_s3z5, db_s3z6, db_s3z7, db_s3z8, db_s3z9, db_s3z10, dv_s4z1, dv_s4z2, dv_s4z3, dv_s4z4, dv_s4z5, dv_s4z6, dv_s4z7, dv_s4z8, dv_s4z9, dv_s4z10, db_s4z1, db_s4z2, db_s4z3, db_s4z4, db_s4z5, db_s4z6, db_s4z7, db_s4z8, db_s4z9, db_s4z10, dv_s5z1, dv_s5z2, dv_s5z3, dv_s5z4, dv_s5z5, dv_s5z6, dv_s5z7, dv_s5z8, dv_s5z9, dv_s5z10, db_s5z1, db_s5z2, db_s5z3, db_s5z4, db_s5z5, db_s5z6, db_s5z7, db_s5z8, db_s5z9, db_s5z10, dv_s6z1, dv_s6z2, dv_s6z3, dv_s6z4, dv_s6z5, dv_s6z6, dv_s6z7, dv_s6z8, dv_s6z9, dv_s6z10, db_s6z1, db_s6z2, db_s6z3, db_s6z4, db_s6z5, db_s6z6, db_s6z7, db_s6z8, db_s6z9, db_s6z10, dv_s7z1, dv_s7z2, dv_s7z3, dv_s7z4, dv_s7z5, dv_s7z6, dv_s7z7, dv_s7z8, dv_s7z9, dv_s7z10, db_s7z1, db_s7z2, db_s7z3, db_s7z4, db_s7z5, db_s7z6, db_s7z7, db_s7z8, db_s7z9, db_s7z10, dv_s8z1, dv_s8z2, dv_s8z3, dv_s8z4, dv_s8z5, dv_s8z6, dv_s8z7, dv_s8z8, dv_s8z9, dv_s8z10, db_s8z1, db_s8z2, db_s8z3, db_s8z4, db_s8z5, db_s8z6, db_s8z7, db_s8z8, db_s8z9, db_s8z10, dv_s9z1, dv_s9z2, dv_s9z3, dv_s9z4, dv_s9z5, dv_s9z6, dv_s9z7, dv_s9z8, dv_s9z9, dv_s9z10, db_s9z1, db_s9z2, db_s9z3, db_s9z4, db_s9z5, db_s9z6, db_s9z7, db_s9z8, db_s9z9, db_s9z10, dv_s10z1, dv_s10z2, dv_s10z3, dv_s10z4, dv_s10z5, dv_s10z6, dv_s10z7, dv_s10z8, dv_s10z9, dv_s10z10, db_s10z1, db_s10z2, db_s10z3, db_s10z4, db_s10z5, db_s10z6, db_s10z7, db_s10z8, db_s10z9, db_s10z10) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($HTTP_POST_VARS['ID'], "int"),
                       GetSQLValueString($HTTP_POST_VARS['sp1'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['sp2'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['sp3'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['sp4'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['sp5'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['sp6'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['sp7'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['sp8'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['sp9'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['sp10'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['z1'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['z2'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['z3'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['z4'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['z5'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['z6'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['z7'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['z8'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['z9'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['z10'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['vs1'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['vs2'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['vs3'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['vs4'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['vs5'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['vs6'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['vs7'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['vs8'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['vs9'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['vs10'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['bs1'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['bs2'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['bs3'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['bs4'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['bs5'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['bs6'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['bs7'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['bs8'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['bs9'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['bs10'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['vz1'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['vz2'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['vz3'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['vz4'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['vz5'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['vz6'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['vz7'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['vz8'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['vz9'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['vz10'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['bz1'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['bz2'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['bz3'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['bz4'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['bz5'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['bz6'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['bz7'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['bz8'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['bz9'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['bz10'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s1z1'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s1z2'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s1z3'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s1z4'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s1z5'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s1z6'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s1z7'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s1z8'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s1z9'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s1z10'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s1z1'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s1z2'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s1z3'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s1z4'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s1z5'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s1z6'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s1z7'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s1z8'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s1z9'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s1z10'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s2z1'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s2z2'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s2z3'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s2z4'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s2z5'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s2z6'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s2z7'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s2z8'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s2z9'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s2z10'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s2z1'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s2z2'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s2z3'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s2z4'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s2z5'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s2z6'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s2z7'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s2z8'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s2z9'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s2z10'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s3z1'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s3z2'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s3z3'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s3z4'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s3z5'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s3z6'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s3z7'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s3z8'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s3z9'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s3z10'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s3z1'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s3z2'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s3z3'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s3z4'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s3z5'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s3z6'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s3z7'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s3z8'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s3z9'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s3z10'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s4z1'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s4z2'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s4z3'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s4z4'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s4z5'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s4z6'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s4z7'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s4z8'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s4z9'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s4z10'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s4z1'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s4z2'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s4z3'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s4z4'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s4z5'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s4z6'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s4z7'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s4z8'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s4z9'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s4z10'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s5z1'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s5z2'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s5z3'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s5z4'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s5z5'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s5z6'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s5z7'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s5z8'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s5z9'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s5z10'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s5z1'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s5z2'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s5z3'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s5z4'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s5z5'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s5z6'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s5z7'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s5z8'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s5z9'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s5z10'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s6z1'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s6z2'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s6z3'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s6z4'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s6z5'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s6z6'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s6z7'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s6z8'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s6z9'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s6z10'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s6z1'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s6z2'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s6z3'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s6z4'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s6z5'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s6z6'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s6z7'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s6z8'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s6z9'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s6z10'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s7z1'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s7z2'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s7z3'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s7z4'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s7z5'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s7z6'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s7z7'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s7z8'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s7z9'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s7z10'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s7z1'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s7z2'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s7z3'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s7z4'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s7z5'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s7z6'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s7z7'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s7z8'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s7z9'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s7z10'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s8z1'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s8z2'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s8z3'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s8z4'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s8z5'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s8z6'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s8z7'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s8z8'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s8z9'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s8z10'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s8z1'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s8z2'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s8z3'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s8z4'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s8z5'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s8z6'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s8z7'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s8z8'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s8z9'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s8z10'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s9z1'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s9z2'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s9z3'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s9z4'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s9z5'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s9z6'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s9z7'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s9z8'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s9z9'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s9z10'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s9z1'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s9z2'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s9z3'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s9z4'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s9z5'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s9z6'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s9z7'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s9z8'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s9z9'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s9z10'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s10z1'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s10z2'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s10z3'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s10z4'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s10z5'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s10z6'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s10z7'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s10z8'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s10z9'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['dv_s10z10'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s10z1'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s10z2'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s10z3'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s10z4'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s10z5'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s10z6'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s10z7'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s10z8'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s10z9'], "date"),
                       GetSQLValueString($HTTP_POST_VARS['db_s10z10'], "date"));

  mysql_select_db($database_Axel, $Axel);
  $Result2 = mysql_query($insertSQL, $Axel) or die(mysql_error());
}

$dates = mysql_insert_id($Axel);

if ((isset($HTTP_POST_VARS["MM_insert"])) && ($HTTP_POST_VARS["MM_insert"] == "tour")) {
  $insertSQL = sprintf("INSERT INTO preise (pbe1, pbe2, pbe3, pbe4, pbe5, pbe6, pbe7, pbe8, pbe9, pbe10, pbe11, pbe12, pbe1a, pbe1b, pbe2a, pbe2b, pbe3a, pbe3b, pbe4a, pbe4b, pbe5a, pbe5b, pbe6a, pbe6b, pbe7a, pbe7b, pbe8a, pbe8b, pbe9a, pbe9b, pbe10a, pbe10b, pbe11a, pbe11b, pbe12a, pbe12b, pz1, pz2, pz3, pz4, pz5, pz6, p1az1, p1az2, p1az3, p1az4, p1az5, p1az6, p1bz1, p1bz2, p1bz3, p1bz4, p1bz5, p1bz6, p2az1, p2az2, p2az3, p2az4, p2az5, p2az6, p2bz1, p2bz2, p2bz3, p2bz4, p2bz5, p2bz6, p3az1, p3az2, p3az3, p3az4, p3az5, p3az6, p3bz1, p3bz2, p3bz3, p3bz4, p3bz5, p3bz6, p4az1, p4az2, p4az3, p4az4, p4az5, p4az6, p4bz1, p4bz2, p4bz3, p4bz4, p4bz5, p4bz6, p5az1, p5az2, p5az3, p5az4, p5az5, p5az6, p5bz1, p5bz2, p5bz3, p5bz4, p5bz5, p5bz6, p6az1, p6az2, p6az3, p6az4, p6az5, p6az6, p6bz1, p6bz2, p6bz3, p6bz4, p6bz5, p6bz6, p7az1, p7az2, p7az3, p7az4, p7az5, p7az6, p7bz1, p7bz2, p7bz3, p7bz4, p7bz5, p7bz6, p8az1, p8az2, p8az3, p8az4, p8az5, p8az6, p8bz1, p8bz2, p8bz3, p8bz4, p8bz5, p8bz6, p9az1, p9az2, p9az3, p9az4, p9az5, p9az6, p9bz1, p9bz2, p9bz3, p9bz4, p9bz5, p9bz6, p10az1, p10az2, p10az3, p10az4, p10az5, p10az6, p10bz1, p10bz2, p10bz3, p10bz4, p10bz5, p10bz6, p11az1, p11az2, p11az3, p11az4, p11az5, p11az6, p11bz1, p11bz2, p11bz3, p11bz4, p11bz5, p11bz6, p12az1, p12az2, p12az3, p12az4, p12az5, p12az6, p12bz1, p12bz2, p12bz3, p12bz4, p12bz5, p12bz6) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($HTTP_POST_VARS['pbe1'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pbe2'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pbe3'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pbe4'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pbe5'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pbe6'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pbe7'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pbe8'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pbe9'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pbe10'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pbe11'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pbe12'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pbe1a'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pbe1b'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pbe2a'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pbe2b'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pbe3a'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pbe3b'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pbe4a'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pbe4b'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pbe5a'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pbe5b'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pbe6a'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pbe6b'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pbe7a'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pbe7b'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pbe8a'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pbe8b'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pbe9a'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pbe9b'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pbe10a'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pbe10b'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pbe11a'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pbe11b'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pbe12a'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pbe12b'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pz1'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pz2'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pz3'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pz4'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pz5'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['pz6'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p1az1'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p1az2'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p1az3'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p1az4'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p1az5'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p1az6'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p1bz1'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p1bz2'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p1bz3'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p1bz4'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p1bz5'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p1bz6'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p2az1'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p2az2'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p2az3'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p2az4'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p2az5'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p2az6'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p2bz1'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p2bz2'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p2bz3'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p2bz4'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p2bz5'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p2bz6'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p3az1'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p3az2'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p3az3'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p3az4'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p3az5'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p3az6'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p3bz1'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p3bz2'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p3bz3'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p3bz4'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p3bz5'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p3bz6'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p4az1'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p4az2'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p4az3'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p4az4'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p4az5'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p4az6'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p4bz1'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p4bz2'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p4bz3'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p4bz4'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p4bz5'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p4bz6'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p5az1'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p5az2'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p5az3'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p5az4'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p5az5'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p5az6'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p5bz1'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p5bz2'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p5bz3'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p5bz4'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p5bz5'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p5bz6'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p6az1'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p6az2'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p6az3'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p6az4'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p6az5'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p6az6'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p6bz1'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p6bz2'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p6bz3'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p6bz4'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p6bz5'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p6bz6'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p7az1'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p7az2'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p7az3'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p7az4'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p7az5'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p7az6'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p7bz1'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p7bz2'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p7bz3'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p7bz4'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p7bz5'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p7bz6'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p8az1'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p8az2'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p8az3'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p8az4'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p8az5'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p8az6'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p8bz1'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p8bz2'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p8bz3'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p8bz4'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p8bz5'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p8bz6'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p9az1'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p9az2'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p9az3'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p9az4'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p9az5'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p9az6'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p9bz1'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p9bz2'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p9bz3'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p9bz4'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p9bz5'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p9bz6'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p10az1'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p10az2'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p10az3'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p10az4'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p10az5'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p10az6'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p10bz1'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p10bz2'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p10bz3'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p10bz4'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p10bz5'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p10bz6'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p11az1'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p11az2'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p11az3'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p11az4'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p11az5'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p11az6'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p11bz1'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p11bz2'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p11bz3'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p11bz4'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p11bz5'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p11bz6'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p12az1'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p12az2'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p12az3'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p12az4'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p12az5'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p12az6'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p12bz1'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p12bz2'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p12bz3'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p12bz4'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p12bz5'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['p12bz6'], "text"));

  mysql_select_db($database_Axel, $Axel);
  $Result3 = mysql_query($insertSQL, $Axel) or die(mysql_error());
}

$preise = mysql_insert_id($Axel);


if ((isset($HTTP_POST_VARS["MM_insert"])) && ($HTTP_POST_VARS["MM_insert"] == "tour")) {
$insertSQL = sprintf("INSERT INTO veran (Name, Text) VALUES (%s, %s)",
                       GetSQLValueString($HTTP_POST_VARS['vername'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['vertext'], "text"));
 
  mysql_select_db($database_Axel, $Axel);
  $Result4 = mysql_query($insertSQL, $Axel) or die(mysql_error());
}

$veran = mysql_insert_id($Axel);

if ((isset($HTTP_POST_VARS["MM_insert"])) && ($HTTP_POST_VARS["MM_insert"] == "tour")) {
$insertSQL = "INSERT INTO touren (Name, idcatlang_ID, daten_ID, dates_ID, preise_ID, ver_ID) VALUES ('$tname', '$idcatlang_ID', '$daten', '$dates', '$preise', '$veran')";
                  
mysql_select_db($database_Axel, $Axel);
$Result5 = mysql_query($insertSQL, $Axel) or die(mysql_error());

}

$tourid = mysql_insert_id($Axel);

if ((isset($HTTP_POST_VARS["MM_insert"])) && ($HTTP_POST_VARS["MM_insert"] == "tour")) {
$insertSQL1 = "UPDATE daten SET tour_ID = '$tourid' WHERE ID='$daten'";
$insertSQL2 = "UPDATE dates SET tour_ID = '$tourid' WHERE ID='$dates'"; 
$insertSQL3 = "UPDATE preise SET tour_ID = '$tourid' WHERE ID='$preise'";
$insertSQL4 = "UPDATE veran SET tour_ID = '$tourid' WHERE ID='$veran'";

mysql_select_db($database_Axel, $Axel);
$Result6 = mysql_query($insertSQL1, $Axel) or die(mysql_error());
$Result7 = mysql_query($insertSQL2, $Axel) or die(mysql_error());
$Result8 = mysql_query($insertSQL3, $Axel) or die(mysql_error());
$Result9 = mysql_query($insertSQL4, $Axel) or die(mysql_error());
}
?>
.... 
hier steht das  HTML Formular um die Daten einzugeben (wäre zu lang zum posten) 
.....

  <tr align="left" valign="top"> 
    <td>&nbsp;</td>
    <td> <input type="hidden" name="idcatlang_ID" value="<? echo "$idcat" ?>"> 
      <input type="hidden" name="daten_ID" value="<? echo "$daten" ?>"> <input type="hidden" name="dates_ID" value="<? echo "$dates" ?>"> 
      <input type="hidden" name="preise_ID" value="<? echo "$preise" ?>"> <input type="hidden" name="ver_ID" value="<? echo "$veran" ?>"> 
      <input type="hidden" name="MM_insert" value="tour"> <input name="submit" type="submit" value="Datensatz einfügen"> 
    </td>
  </tr>
</table> 
<? mysql_free_result($tour);

wahrerDichter · Beitrag von **wahrerDichter** » Mi 21. Jan 2004, 11:43

Du kannst ganz normal mit PHP auf die Datenbank zugreifen. Da Contenido automatisch eine Verbindung zur Datenbank herstellt ist die ganze Zeit eine Verbindung aktiv, wenn du eine Seite aufrufst.

Ein ganz normaler mysql_query funktioniert tadellos...und bezieht sich immer auf die Datenbank, in der du Contenido installiert hast.

So gebe ich z.B. in meinem Sprachmodul alle verfügbaren Sprachen eines Artikels aus, indem ich in der Contenido-DB den Artikel raussuche und schaue mit welchen Sprachen er verfügbar ist.

Sieht dann z.B. aus wie unten...und funktioniert.

einfaches Sprach-Modul als Beispiel

$anfrage = mysql_query ("SELECT idlang FROM con_cat_lang WHERE idcat='$idcat' ORDER BY idlang ASC");
while ($row = mysql_fetch_array($anfrage))
{
$anfrage1 = mysql_query ("SELECT name FROM con_lang WHERE idlang='$row[idlang]'");
$row1 = mysql_fetch_array($anfrage1);
$name = $row1[name];

if ($name == deutsch)
{
print "<a href=\"front_content.php?idcat=$idcat&changelang=$row[idlang]\"><img src=\"upload/images/language/deutsch.jpg\" border=\"0\"></a> ";
}
elseif ($name == englisch)
{
print "<a href=\"front_content.php?idcat=$idcat&changelang=$row[idlang]\"><img src=\"upload/images/language/english.jpg\" border=\"0\"></a> ";
}
elseif ($name == französisch)
{
print "<a href=\"front_content.php?idcat=$idcat&changelang=$row[idlang]\"><img src=\"upload/images/language/francais.jpg\" border=\"0\"></a> ";
}
}
?>

Harlekin · Beitrag von **Harlekin** » Mi 21. Jan 2004, 11:56

Vielen dank,
somit wär das ein Problem gelöst, weist du auch wie das mit den eigenen Tabellen funktioniert damit sie in contenido integriert werden? ich habe sie in dem cfg_... file bereits eingetragen....

Grüße Josh

wahrerDichter · Beitrag von **wahrerDichter** » Mi 21. Jan 2004, 11:58

Was meinst du mit "in Contenido integriert werden" ?
Wenn du in der Datenbank Tabellen anlegst, dann kannst du doch darauf zugreifen...egal ob sie irgendwo im Contenido eingetragen sind. Denn die bestehende Verbindung bezieht sich auf die Datenbank in der Contenido installiert ist...nicht aber auf spezielle Tabellen.

Kann natürlich auch sein dass ich das jetzt falsch verstanden habe.

Gruß
Dominik

Harlekin · Beitrag von **Harlekin** » Mi 21. Jan 2004, 12:27

nun ja, es ist so das wenn ich über das Contenido-Backend die daten eingebe und 2x bestätige werden mir 2 datsätze angelegt und dadurch immer der letzte nur angezeigt... da der datensatz anhand der idcat aufgerufen wird kann dies zu komplikationen führen...