Repeatable fields get messed up each time a post is updated

I think I’ve found a solution for the frontend:

<?php $myid = $post->ID; 
                        $data = $wpdb->get_results("
                        SELECT * FROM $wpdb->postmeta WHERE post_id = $myid
                        AND meta_key NOT LIKE '\_%'
                        AND meta_key  IN('additional_credits')
                        ORDER by meta_id ASC
                    ");

                    if( !empty( $data ) ) {
                    foreach( $data as $result_object ) {
      
				$values = explode( '| ', $result_object->meta_value);
        $role_additional = "{$values[0]}";
        $url_additional = "{$values[2]}";
		if ($role_additional == '')
{ ?>
<?php } else { 
if ($url_additional  == '') // link to url when available
{ echo "{$values[0]}: {$values[1]} <br />"; } else { 
echo "{$values[0]}: <a target=\"blank\" href=\"$url_additional\">{$values[1]}</a><br />"; 
 	} 
  }
}}
?>	

But I still worry about the backend, as my client doesn’t like the idea of “random changing” 😉
Any idea on that would be very appreciated!

I just found out, that each time a post is updated the repeatable fields get saved for new! It means each time the meta_id of it increases! Is this normal? Is it the way it works? It’s at 17632 now and growing…. This actually kind of explains the problem with the reordering: when I create a group of ordered fields, each time I update the post, they get reordered and saved for new.
Is it a “normal” behaviour? 😉
Thanks in advance.

Yeah, that was normal behavior. Because as you’ve said, get meta functions doesn’t provide you the meta ID’s. So when you are going to update those, there is no way to know if you are updating the same items or you are adding a new item. So the little trick was to delete all existing and adding the items again.

Thanks Tareq!
One more question to this: is it also normal, that from time to time a new row of fields appears? I mean, I press “update” and suddenly there is an empty row of repeatable fields. I have to press the “-” to delete it. Have you experienced this?

No, I haven’t faced that issue. May be I need to recheck.

All right then. I’m also using WPML, which doesn’t seem to be 100% compatible with your plug-in. I’ll keep an eye on that.
Thanks.