PDA

View Full Version : SQL Statement Problem


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

johnnyb
09-01-2004, 06:46 AM
Never mind - I found the problem and it wasn't even in that statement.