The following piece of code submits the info into the database but its not incrementinthe id:
Code: Select all
<?php
$Q03 = "SET IDENTITY_INSERT cust_call_log ON INSERT INTO $dbcall2(id_num,company_name,Username,date,time,call_type,description) VALUES('','$company_name','$Username','$date','$time','$call_type','$description')SET IDENTITY_INSERT cust_call_log OFF ";
$R03 = odbc_exec($db,$Q03) or die("Bad Q03:".mysql_error());
$Q03 = "SET IDENTITY_INSERT logged_cust_calls ON INSERT INTO $dbcust_log(id_num,company_name,date)VALUES('','$company_name','$date')SET IDENTITY_INSERT OFF logged_cust_calls";
$R03 = odbc_exec($db,$Q03) or die("Bad Q03:".mysql_error());
?>Thanx for any advice!!