Hi paz: I rewrite the code below, but the webbrowser prompt me to save a file called "index_html" which is the code below., here is all my codes below , now u could see what i was wrong. I create a database use Z gadfly database adaptor create databse code : --------------------------------------------------------- CREATE TABLE countpages(pagecount integer,pageurl varchar) --------------------------------------------------------- index_html: ----------------------------------------------------------- <dtml-in "test_for_page_count(pageurl=URL0)"> <dtml-if "pagecount>=1"> <dtml-call "update_page_count(pageurl=URL0)"> <dtml-in "getPageViews(pageurl=URL0)"> <center> This page has been viewed <b><dtml-var pagecount></b> times. </center> </dtml-in> <dtml-else> <dtml-call "initialize_page_count(pageurl=URL0)"> <dtml-in "getPageViews(pageurl=URL0)"> <center> This page has been viewed <b><dtml-var pagecount></b> time. </center> </dtml-in> </dtml-if> </dtml-in> ------------------------------------------------------------- getPageViews: ---------------------------------------------------------- augument : pageurl ---------------------------------------------------------- select * from countpages WHERE pageurl = <dtml-sqlvar pageurl type=nb> -------------------------------------------------------- initialize_page_count : -------------------------------------------------------- augument : pageurl ---------------------------------------------------------- INSERT INTO countpages (pagecount, pageurl) VALUES (1,<dtml-sqlvar pageurl type=nb>) test_for_page_count : -------------------------------------------------------- augument : pageurl ---------------------------------------------------------- SELECT pagecount FROM countpages WHERE pageurl = <dtml-sqlvar pageurl type=nb> update_page_count : -------------------------------------------------------- augument : pageurl ---------------------------------------------------------- UPDATE countpages SET pagecount = pagecount + 1 WHERE pageurl = <dtml-sqlvar pageurl type=nb>