Hi! I am trying to insert the data froma a form into 3 tables. Although I get no errors only the first insert works. Could you please help me and tell me what am I doing wrong?

$query_add = "insert into autoturisme values('', '$producator', '$model', '$categorie', '$nume_poza', '$motor', '$consum', '$locuri', '$capacitate', '$tip', '$transmisie', '1', '1', '$km', '$data_revizie', '$comentarii')";

mysql_query($query_add) or die("Problema Add auto: ".mysql_error());

    //insert into table facilitati
    if(isset($_POST['aer_conditionat']) && $_POST['aer_conditionat'] == '1') 
            { $ac=1;}
        else {$ac=0;}
    if(isset($_POST['inchidere_centralizata']) && $_POST['inchidere_centralizata'] == '1') 
            { $ic=1;}
        else {$ic=0;}
    if(isset($_POST['geamuri_electrice']) && $_POST['geamuri_electrice'] == '1') 
            { $ge=1;}
        else {$ge=0;}
    if(isset($_POST['alarma']) && $_POST['alarma'] == '1') 
            { $a=1;}
        else {$a=0;}
    if(isset($_POST['servo_directie']) && $_POST['servo_directie'] == '1') 
            { $sd=1;}
        else {$sd=0;}
    if(isset($_POST['cd_player']) && $_POST['cd_player'] == '1') 
            { $cd=1;}
        else {$cd=0;}
    if(isset($_POST['airbag']) && $_POST['airbag'] == '1') 
            { $air=1;}
        else {$air=0;}
    if(isset($_POST['priza']) && $_POST['priza'] == '1') 
            { $p=1;}
        else {$p=0;}
    if(isset($_POST['abs']) && $_POST['abs'] == '1') 
            { $abs=1;}
        else {$abs=0;}

    $id=mysql_insert_id();
    $query_add_facilitati="insert into facilitati values('$id', '$ac', '$ic', '$ge', '$a', '$sd', '$cd', '$air', '$p', '$abs')";

    mysql_querry($querry_add_facilitati) or die("Problema Add in tabela facilitati ".mysql_error()); 

    //insert into  tabel tarife
        $t_1_3      = $_POST['1_3_zile'];
        $t_4_7      = $_POST['4_7_zile'];
        $t_8_14     = $_POST['8_14_zile'];
        $t_15_21    = $_POST['15_21_zile'];
        $t_p_21     = $_POST['peste_21_zile'];
        $query_add_tarife = "insert into tarife values('$id','$t_1_3','$t_4_7','$t_8_14','$t_15_21','$t_p_21')";
        mysql_query($query_add_tarife) or die("Eroare inserare in tabela tarife:".mysql_error());

You echo query on screen copy it and try to run in mysql directly may be on mysql command prompt or phpmyadmin. Check whether your query works directly to backend or not. keep echo statment before calling mysql_query() function.

echo $query_add_tarife."<br>";

echo $query_add_facilitati."<br>";
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.