Inserting data into 2 tables

tashka

I have to insert data into 2 different tables (nova_vozila and oprema), but when I submit form it only inserts data into first table (nova_vozila), what am I doing wrong????
This is the script:
<?php

if ($submit) {
$db = mysql_connect();
mysql_select_db();

$sql = "INSERT INTO nova_vozila(model,tip,letnik,karoserija,......etc)

VALUES('$model','$tip','$letnik','$karoserija',.....etc) ";

 $sql2="INSERT INTO oprema (op1,op2,op3,op4,op5......op59) VALUES('$op1','$op2','$op3','$op4','$op5'......op44')";

//values from op45 - op59 don't exist yet.
$result = mysql_query($sql);
$result2 = mysql_query($sql2);
}
?>

bernouli

$sql2="INSERT INTO oprema (op1,op2,op3,op4,op5......op59) VALUES('$op1','$op2','$op3','$op4','$op5'......op44')";
//values from op45 - op59 don't exist yet.

$sql2="INSERT INTO oprema (op1,op2,op3,op4,op5......op59) VALUES('$op1','$op2','$op3','$op4','$op5',....$op44,'','','','',''...until 59)";

cschotch

With the form that you have what exactly (field wise) is it submitting to which data....lots of questions please put the form up so I can get a full Idea.....Your code looks alright to me so far it might be just how you got your form written and how it nteracts to your php script.......

tashka

It inserts the data into the first table that is nova_vozila, but nothing into the table named oprema. I have checkboxes for the second table - there are 44 checkboxes, but in the table I have 59 fields (if I'll have to add more options later)is this the problem?

the form is here:
http://www.vavpycom.net/slike/chbox_vnos1.php

tashka

I have repaired the insert into so that the number of values match the number of fields in the table, but it still doesn't work, could it be a problem with checkboxes? All the values that I want to insert into this second table (oprema, op1,op1,...) are given with checkboxes. Could it be the problem with the version of the php or MySql.
Please help, I'm in despair...

bernouli

add this lineto se, whih error did u get

iff(!result2) die(mysql_error());

Ryan_Sanders

Originally posted by tashka
I have to insert data into 2 different tables (nova_vozila and oprema), but when I submit form it only inserts data into first table (nova_vozila), what am I doing wrong????
This is the script:
<?php

if ($submit) {
$db = mysql_connect();
mysql_select_db();
$sql = "INSERT INTO nova_vozila(model,tip,letnik,karoserija,......etc)
VALUES('$model','$tip','$letnik','$karoserija',.....etc) ";
 $sql2="INSERT INTO oprema (op1,op2,op3,op4,op5......op59) VALUES('$op1','$op2','$op3','$op4','$op5'......op44')";
//values from op45 - op59 don't exist yet.
$result = mysql_query($sql);
$result2 = mysql_query($sql2);
}
?> [/B]

For Inserting Stuff, Try this:

$sql = mysql_query("INSERT INTO oprema (op1,op2,op3, etc) VALUES ('$op1', '$op2', '$op3', '$etc')");

That might help, I dunno.. That is just the way I usually do it.

tashka

Originally posted by bernouli
add this lineto se, whih error did u get
iff(!result2) die(mysql_error());
[/B]

I did this and nothing - no error, nothing.

bernouli

if so, try to look your table with phpMyAdmin or so, i guesst you have got something inserted into your table, but it consists just nothing

tashka

Originally posted by bernouli
if so, try to look your table with phpMyAdmin or so, i guesst you have got something inserted into your table, but it consists just nothing

When I check the table "oprema" it is empty, I can't browse it. Is there another way to insert data into two different tables at the same time? I'm slowly running out of patience....🙂