// create an array of value lists:
$values = array();
foreach ($res['Identities'] as $x)
{
$values[] = sprintf("($userid,'%','%','%','%','%','%','%')",
mysql_escape_string($x->full_name),
mysql_escape_string($x->email_address),
mysql_escape_string($x->reply_to),
mysql_escape_string($x->signature),
mysql_escape_string($x->use_sig),
mysql_escape_string($x->sig_reply),
mysql_escape_string($x->sig_forward));
}
// now you can do just one insert query with multiple value lists:
$sql = "Insert Into `user_identities` (`userid`, `full_name`, `email_address`, `reply_to`, `signature`, `use_sig`, `sig_reply`, `sig_forward`) VALUES ".implode(', ', $values);
$result = mysql_query($sql) or die(mysql_error() . ": $sql");
