[RESOLVED] Multidimensional Array into a mySQL table.

[RayAdams23]

I am so new at PHP & mySQL I am sure the error is obvious, thanks for any help.

I keep getting a parsing error on this line:

$add_sql = "INSERT INTO jwlr_id (jwlr_num, jwlr_name, jwlr_andate, jwlr_class) VALUES('$jeweler_data[$j_data_inc]["j_num"]','$jeweler_data[$j_data_inc]["j_name"]','$jeweler_data[$j_data_inc]["j_annivdate"]','$jeweler_data[$j_data_inc]["j_class"]')";

Here is the rest of the function:

function get_JewelerID($data, $jeweler_data, $j_data_inc) {
global $mysqli, $check_res;

$jeweler_data[$j_data_inc]["j_num"] = $data[1];
$jeweler_data[$j_data_inc]["j_name"] = $data[3];
$jeweler_data[$j_data_inc]["j_annivdate"] = $data[4];
$jeweler_data[$j_data_inc]["j_class"] = $data[2];

$add_sql = "INSERT INTO jwlr_id (jwlr_num, jwlr_name, jwlr_andate, jwlr_class) VALUES('$jeweler_data[$j_data_inc]["j_num"]','$jeweler_data[$j_data_inc]["j_name"]','$jeweler_data[$j_data_inc]["j_annivdate"]','$jeweler_data[$j_data_inc]["j_class"]')";

$add_res = mysqli_query($mysqli, $add_sql) or die(mysqli_error($mysqli));
echo "<p>Record Loaded</p>";;
return($jeweler_data);
}

[djjjozsi]

you complicated the variable names:

<?php
$add_sql = sprintf("INSERT INTO jwlr_id (jwlr_num, jwlr_name, jwlr_andate, jwlr_class)
 VALUES(%d, '%s', '%s', '%s')"  , 
$data[1] , $data[3] , $data[4] , $data[2] );

?>

becouse of the unescaped " double qoutes this causes a T_STRING error:

$newstring="   '$jeweler_data[$j_data_inc]["j_annivdate"]'  ";

how to embed variable into a string?

$a="  This is data: {$a["x"]["y"]["$z"]}";

[RayAdams23]

Thanks - I knew it was a novice mistake.