Hi, Can you insert data into 2 table using single my sql query?
I tried this:
[CODE]
$insertSQL = sprintf(“INSERT INTO tbl_1, tbl_2 (tbl_1_id, tbl_1_name, tbl_1_etc, tbl_2_id, tbl_2_forgeinkey, tbl_2_name, tbl_2_etc) VALUES (%s, %s, %s, %s, %s, %s, %s)”,
GetSQLValueString($_POST[‘tbl_1_id’], “int”),
GetSQLValueString($_POST[‘tbl_1_name’], “text”),
GetSQLValueString($_POST[‘tbl_1_etc’], “text”),
GetSQLValueString($_POST[‘tbl_2_id’], “int”),
GetSQLValueString($_POST[‘tbl_2_forgeinkey’], “int”),
GetSQLValueString($_POST[‘tbl_2_name’], “text”),
GetSQLValueString($_POST[‘tbl_2_etc’], “text”));
And this
[CODE]
$insertSQL = sprintf(“INSERT INTO tbl_1 (tbl_1_id, tbl_1_name, tbl_1_etc), tbl_2 (tbl_2_id, tbl_2_forgeinkey, tbl_2_name, tbl_2_etc) VALUES (%s, %s, %s, %s, %s, %s, %s)”,
GetSQLValueString($_POST[‘tbl_1_id’], “int”),
GetSQLValueString($_POST[‘tbl_1_name’], “text”),
GetSQLValueString($_POST[‘tbl_1_etc’], “text”),
GetSQLValueString($_POST[‘tbl_2_id’], “int”),
GetSQLValueString($_POST[‘tbl_2_forgeinkey’], “int”),
GetSQLValueString($_POST[‘tbl_2_name’], “text”),
GetSQLValueString($_POST[‘tbl_2_etc’], “text”));
but i got a SQL syntax error. thx for any help