Very new to PHP & MYSQL. I'm trying to upload a CSV invoice file and what I would like to do is utilize the Customer ID (auto Incremented upon insert) record from the customer table as a variable to load into the customer history table for future reporting purposes. Below is what I have so far; however, the CustId record in the customer history table is 1 for ever record.
+++++++++++++++++++++++++++++
$tot = 0;
$handle = fopen($_FILES["uploaded"]["tmp_name"], "r");
while (($data = fgetcsv($handle, 100000, ",")) !== FALSE) {
for ($c=0; $c < 1; $c++) {
//only run if the first column is equal to HDR
if($data[0] ='HDR'){
$sql = ("INSERT IGNORE INTO customer(
CustAccntRef,
CustEmail,
CustName,
LocAdd2,
LocCity,
LocState,
LocZip
)VALUES(
'".mysql_real_escape_string($data[36])."',
'".mysql_real_escape_string($data[39])."',
'".mysql_real_escape_string($data[5])."',
'".mysql_real_escape_string($data[19])."',
'".mysql_real_escape_string($data[20])."',
'".mysql_real_escape_string($data[21])."',
'".mysql_real_escape_string($data[22])."'
)")or die(mysql_error());
$result = mysql_query($sql);
$insertID = $result;
mysql_query("INSERT IGNORE INTO custhistory(
CustAccntRef,
InvoiceNum,
InvoiceDate,
InvoiceTotal,
CustId
)VALUES(
'".mysql_real_escape_string($data[36])."',
'".mysql_real_escape_string($data[4])."',
'".mysql_real_escape_string($data[3]=date('Y-m-d',strtotime($data[2])))."',
'".mysql_real_escape_string($data[16])."',
$insertID
)")or die(mysql_error());
}
$tot++;}
}
fclose($handle);
