Really simple only two lines of code that need help

[karatekid36]

Why are these two line producing an error.  All of the variables are fine it is the actual structure of this code.

 

		

foreach($attend as $key => $value2){
	mysql_query("INSERT INTO attendance ('eid', 'mid','attend_status') VALUES ('$eventid','$key','$value2') or die(mysql_error()");
}

[trq]

A few reasons. You have both php syntax and mysql syntax errors. Try...

 

<?php

foreach($attend as $key => $value2){
  mysql_query("INSERT INTO attendance (eid, `mid`, attend_status) VALUES ('$eventid','$key','$value2')") or die(mysql_error());
}

?>

[teng84]

foreach($attend as $key => $value2){

mysql_query("INSERT INTO attendance ('eid', 'mid','attend_status') VALUES ('".$eventid."','".$key."','".$value2."')") or die((mysql_error());

}