Problem with loop running inside a loop

[willl]

Hi,

Having a problem with the following;

$last_id = mysql_insert_id();

$type_count = count($types);

for ($i=0; $i < $type_count; $i++) { 

$match = "";

if ($types[$i] == $featured[$i]) {
	$match = "y";
	}

$q_add_types = "INSERT into company_ins (Id, company_id, ins_id, type_featured) VALUES ('', '$last_id', '$types [$i]', '$match')";
	mysql_query($q_add_types) or die(mysql_error());
}

The INSERT query does not run when I insert the inner parenthesis.

Does anybody know why??

Thanks

Will

[bbreslauer]

Does the mysql_error() call output anything?

You've only got one loop here, not two...

[willl]

Hi,

No error output, and yes sorry, 1 loop.

Any ideas.

Will

[Roger_Ramjet]

It is because you are trying to insert an empty string viz: VALUES ('', into your autoincrement id field. You do not need to supply a value or a placeholder for an autoinc field, that is what they are for, to generate their own value automatically; and as you have discovered it messes up when you do supply a value.