Missing array elements

[clcope]

I have an array with 12 elements, but some elements do not have a value. When I process the array, it stops after the first empty element. Any ideas? Here is the code:

	do
		{
		$sql = "INSERT INTO frm_label_dtl (
					label_hdr_id,
					language_id,
					label)
				VALUES (
					" . key($select) . ",
					'$language_id',
					'" . current($select)."')";

// $dbcnx->query($sql);
echo key($select) . " = " . current($select) . "<br>";
}
while(next($select));

TIA,
Crystal

[Anon]

Per the current() function documentation on the php.net site, you should use the each() function if your array contains empty elements. See here:

http://www.php.net/manual/en/function.each.php

[cordex]

Sorry Crystal - that's the code I gave you isn't it?

Okay try this:
foreach($select as $id => $label)
{
$sql = "INSERT INTO frm_label_dtl (label_hdr_id,language_id,label) VALUES ('$id','$language_id','$label')";
// $dbcnx->query($sql);
echo "$id = $label<br>";
}

Again, sorry for the bad code.
-Ben

[clcope]

No problem ben. As soon as I posted, I found the problem. I just wasn't sure of how to fix it. But with the link Dash gave me, I found an example.

Thanks!