Save the software codes I gave to the sitemap.asp file and adapt the database tables according to you. You can easily create your sitemap automatically.
<!--#include file="connection.asp" --> <?xml version="1.0" encoding="UTF-8"?> <urlset xmlns="https://www.sitemaps.org/schemas/sitemap/0.9" xmlns:xsi="https://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="https://www.sitemaps.org/schemas/sitemap/0.9 https://www.sitemaps.org/schemas/sitemap/0.9/sitemap.xsd"> <url> <loc>https://www.yoursite.com/</loc> <priority>1.00</priority> </url> <% Set rs = Server.CreateObject("Adodb.Recordset") Sorgu = "select * from news order by id asc" rs.Open Sorgu, db2, 1, 3 while not rs.eof %> <url> <loc>https://www.youtsite.com/page.asp?id=<%=rs("id")%></loc> <priority>0.80</priority> </url> <%rs.movenext wend%> </urlset>