Occasionally Missing Row Information

[jbolduan]

Hello,

 

I've inherited a web form that has been exhibiting some strange behavior in that it occasionally drops the row information that is updated after a limited insert is done to create the record.  I'm not sure why someone would do the row creation like this but before I go and start changing things around I was hoping someone might have some insight as to why this might fail.  The code is below and should be straight forward.  Thanks!

 

if (empty($err)) //This is used to check that required fields have been entered.
{
mysql_query("insert into membri set data='".time()."',
	username='".$username."',
	password='".md5($password)."',
	apply='".base64_encode(serialize($apply))."',
	vaccines='".base64_encode(serialize($vaccines))."',
	active='0'"); //This query works always and inserts the proper data
$id = mysql_insert_id();
$query = 'update membri set ';
foreach ($data as $key=>$value)
{
if ($key != 'username' && $key != 'password' && $key != 'apply' && $key != 'vaccines' && $key != 'activ')
{
	$query .= $key.'=\''.$value.'\', ';
}
}
$query = preg_replace('/(, )$/', ' ', $query);
$query = .= 'where id='.$id;
mysql_query($query);