Question regarding inserting into db using a loop

[vocoder]

I have the following code...it's not working..it just inserts a bunch of blank entries into the database. What am I doing wrong?

$queryinsert = "INSERT INTO mytable (year, seq, group, dis_type, subset, event_name) VALUES ('$year', '$seq', '$group', '$distype', '$subset', '$event')";
for ($y = 1; $row = mysql_fetch_assoc($queryresult); ++$y) 
	{ 
		$year = substr($row['numyear'], 0, 4);
		$seq = substr($row['numyear'], 4, 8);
		$group = $row['grouping'];
		$distype = $row['Type'];
		$subset = $row['subset'];
		$event = $row['name'];

             $insertresult = mysql_query($queryinsert, $linkID);


}

i know it gets the correct results because if i echo out the results, it's correct...so i'm guessing i need to a find a different way to insert the data in the db?

[kevinsequeira]

<?php
for ($y = 1; $row = mysql_fetch_assoc($queryresult); ++$y){ 
		$year = substr($row_emdat['numyear'], 0, 4);
		$seq = substr($row_emdat['numyear'], 4, 8);
		$group = $row_emdat['grouping'];
		$distype = $row_emdat['Type'];
		$subset = $row_emdat['subset'];
		$event = $row_emdat['name'];
		$queryinsert = "INSERT INTO mytable (year, seq, group, dis_type, subset, event_name) VALUES('".$year."', '".$seq."', '".$group."', '".$distype."', '".$subset."', '".$event."')";
   $insertresult = mysql_query($queryinsert, $linkID);
}
?>

reg
kevin

[vocoder]

thanks for the help.....however, that doesn't work. Doesn't insert any values into the table. also i should note that i messed up my code a bit...i went back and edited it to reflect the changes.