edit - I'm assuming you have added the new field .
Save this as "whatever.asp" and include it at the end of inc_header.asp.
<%
strSql = "SELECT M_PROFILE_UPDATE FROM " & strMembersTablePrefix & "MEMBERS " & _
"WHERE MEMBER_ID = " & MemberID
set rs = my_Conn.Execute(strSql)
if rs.EOF or rs.BOF then
'ID doesn't exist??
else
blnUpdateStatus = rs("M_PROFILE_UPDATE")
end if
rs.close
set rs = nothing
if cLng(blnUpdateStatus) < 1 then
'Do Nothing
else
Response.Write "WRITE YOUR MESSAGE HERE" & vbNewLine & _
"<meta http-equiv=""Refresh"" content=""15; URL=pop_profile.asp?mode=Edit"">" & vbNewLine
WriteFooter
Response.End
end if
%>
You'll have to add m_profile_update to the update statement in pop_profile.asp, after the required fields checks.
Remove it when you think everyones updated.
<