I would like to update two tables at the same time.

Currently I update each one separately, like so,

$qryStr = "INSERT INTO table1 etc....";
odbc_exec($dbConn, $qryStr);

$qryStr = "INSERT INTO table2 etc....";
odbc_exec($dbConn, $qryStr);

Now, the problem there is if the first one passes, but the second fails, if the user 
tries to re-submit, the first now fails because of a primary key clash which is right, 
but then never executes the second one.

This is what I THINK I should do,

$qryStr = "(INSERT INTO table1 ( col1, col2 ) VALUES ( '$val1', '$val2' ) ) AND 
(INSERT INTO table2 ( col1, col2 ) VALUES ( '$val1', '$val2' ) )";
odbc_exec($dbConn, $qryStr);

Any ideas are appreciated... I am not experienced with SQL query precedences, or 
operators, etc...  A good reference for that very thing would be nice.
Thanks in advance,

Reply via email to