Spider site and make a goodle search engine usable sitemap<title>
<h1>Spider site for sitemap:</h1>
<h2>Make and edit a goodle search engine usable sitemap</h2>
connect to data base res [Resource id #7]
<br>
Start proc db edits A [select count(*) from st_pages where site_id = (select id from st_sites where url = '') and whn >= (select whn from st_sites where url = '') and (hide is null or hide = 0)]
<br> maxPage 0 <form name=f1 action=edits.php method=post>
<br>The table headings have hints in tooltip (title)<br><table style='vertical-align::middle' border=1 cellpading=1>
<tr>
<th title='Hide from list' style='vertical-align::middle' width=3%>H<br>i<br>d<br>e<br></th>
<th title='Include in sitemap'>I<br>n<br>c</th>
<th>URL</th>
<th title='YYYY-MM-DD or YYYY-MM-DDThh:mm:ss.sTZD'>Last<br> mod</th>
<th title='0.0 to 1.0 default .5 '>Priority</th> <th title='How frequently the page is likely to change (always hourly daily weekly monthly yearly never)'>Change<Br>Freq</th>
</tr>
db edt B [select id, url, priority, lastmod, change_Freq, hide, inc from st_pages where site_id = (select id from st_sites where url = '') and whn >= (select whn from st_sites where url = '') and (hide is null or hide = 0) order by url limit -3, 3 ]
<br> error dbUp1 1
<br>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-3, 3' at line 1
