"; echo""; echo"Round cube identity entry"; $query="select * from users"; $result=mysql_query($query); while(list($id,$username,$mail_host,$alias,$created,$last_login,$language,$preferences) = mysql_fetch_array($result)){ //echo" id $id $username"; if($id){ $queryident= "SELECT * FROM identities where `user_id` = $id"; $resultident= mysql_query($queryident); $ididente=mysql_result($resultident, 0,1); //if($identity = mysql_fetch_query($resultident)){ //$ididente = $identity -> identity_id; //echo"$ididente"; if(($ididente)==""){ $insert="INSERT INTO identities(`user_id`, `del`, `standard`, `name`, `email`, `reply-to`) VALUES ('$id', '0', '1', '$username', '$username', '$username')"; mysql_query($insert) or die("Error, inserting identities" . mysql_error() ); echo"Found record";echo"$username";} //}else{echo"$username not found";} } } echo""; echo""; ?>