johnnyb
09-01-2004, 06:03 AM
Hi, can anyone tell me what's wrong with this SQL Statement, (or the bit of PHP that constructs it?
$transferQuery = "INSERT INTO ".$theTable." (PERSON_ID,ARTICLE_ID,PERSON_TITLE,FIRST_NAME,MIDDLE_NAME,LAST_NAME,BIRTH_DATE,BIRTH_PLACE,DEATH_DAT E,DEATH_PLACE) VALUES (".$theRow["PERSON_ID"].",LAST_INSERT_ID(),'".$theRow["PERSON_TITLE"]."','".$theRow["FIRST_NAME"]."','".$theRow["MIDDLE_NAME"]."','".$theRow["LAST_NAME"]."',#".$theRow["BIRTH_DATE"]."#,'".$theRow["BIRTH_PLACE"]."',#".$theRow["DEATH_DATE"]."#,'".$theRow["DEATH_PLACE"]."')";
Thanks,
JB
$transferQuery = "INSERT INTO ".$theTable." (PERSON_ID,ARTICLE_ID,PERSON_TITLE,FIRST_NAME,MIDDLE_NAME,LAST_NAME,BIRTH_DATE,BIRTH_PLACE,DEATH_DAT E,DEATH_PLACE) VALUES (".$theRow["PERSON_ID"].",LAST_INSERT_ID(),'".$theRow["PERSON_TITLE"]."','".$theRow["FIRST_NAME"]."','".$theRow["MIDDLE_NAME"]."','".$theRow["LAST_NAME"]."',#".$theRow["BIRTH_DATE"]."#,'".$theRow["BIRTH_PLACE"]."',#".$theRow["DEATH_DATE"]."#,'".$theRow["DEATH_PLACE"]."')";
Thanks,
JB