you have typo mistake and unwanted )closing bracket.. use this

 $str = md5($pass2);
  mysql_query("DECLARE @AIDIdent int INSERT INTO UserInfoFromPublisher (fdUserID,fdGameID,fdPassword,fdCash) VALUES ('".$username."',NULL,'".$str."',10000) ");
   echo '<p class="errormsg">The account "'.$username.'" has been successfully made!</p>';
                        }