for rewritten urls using this rewrite code
RewriteEngine on
#RewriteRule ^~(.*)$ /profile.php?profile=$1 [L]
RewriteRule ^([a-zA-Z0-9]*).html detail.php?siteid=$1use this code
<?php
// HTML SITE MAP FOR REWRITTEN URLS
// SETTINGS TO BE EDITED
$url = "http://www.domain.com/classifieds/" ; // url to directory must have trailing slash
$title = "page title" ; // page title
$keywords = "keywords" ; // keywords
$metadesc = "description" ; // description of your site
$hostname_sitemap = "localhost"; // mysql location
$database_sitemap = "xxxxxxxxxxxxxxxxx"; // mysql database
$username_sitemap = "xxxxxxxxxxx"; // mysql user
$password_sitemap = "xxxxxxxxxx"; // mysql password
//hmmmmm dunno what to say
$sitemap = mysql_pconnect($hostname_sitemap, $username_sitemap, $password_sitemap) or trigger_error(mysql_error(),E_USER_ERROR);
// okay know let's hook up with our base and slide our query in
mysql_select_db($database_sitemap, $sitemap);
$query_Recordset1 = "SELECT * FROM ad";
$Recordset1 = mysql_query($query_Recordset1, $sitemap) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title><? echo $title ?></title>
<meta name="keywords" content="<? echo $keywords ?>">
<meta name="description" content="<? echo $metadec ?>">
</head>
<body>
<!-- start sitemap -->
<?php do { ?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<!-- start url list -->
<td width="42%"><a href="<? echo $url ?><?php echo $row_Recordset1['siteid']; ?>.html" target="_blank"><?php echo $row_Recordset1['sitetitle']; ?> </td>
<!-- to add other database fields as links use this code <a href="<? echo $url ?><?php echo $row_Recordset1['siteid']; ?>" target="_blank"></a> to just print text use ?php echo $row_Recordset1['e_8']; ?> replacing siteid or 8 with the needed database field -->
<td width="58%" rowspan="3" valign="top"><div align="center"></div></td>
</tr>
<tr>
<!-- start description-- to show the description simply remove the comment tages from in front -->
<!-- <td class="desc"><?php echo $row_Recordset1['sitedescription']; ?></td>
<!-- end description -->
</tr>
<tr>
<td> </td>
</tr>
</table>
<!-- end item -->
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
<p></p>
</body>
</html>for normal urls use this code
<?php
// HTML SITE MAP FOR NORMAL URLS
// SETTINGS TO BE EDITED
$url = "http://www.domain.com/classifieds/" ; // url to directory must have trailing slash
$page = "detail.php?siteid="; //no need to edit
$title = "page title" ; // page title
$keywords = "keywords" ; // keywords
$metadesc = "description" ; // description of your site
$hostname_sitemap = "localhost"; // mysql location
$database_sitemap = "xxxxxxxxxxxxxxxxx"; // mysql database
$username_sitemap = "xxxxxxxxxxx"; // mysql user
$password_sitemap = "xxxxxxxxxx"; // mysql password
//hmmmmm dunno what to say
$sitemap = mysql_pconnect($hostname_sitemap, $username_sitemap, $password_sitemap) or trigger_error(mysql_error(),E_USER_ERROR);
// okay know let's hook up with our base and slide our query in
mysql_select_db($database_sitemap, $sitemap);
$query_Recordset1 = "SELECT * FROM ad";
$Recordset1 = mysql_query($query_Recordset1, $sitemap) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title><? echo $title ?></title>
<meta name="keywords" content="<? echo $keywords ?>">
<meta name="description" content="<? echo $metadec ?>">
</head>
<body>
<!-- start sitemap -->
<?php do { ?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<!-- start url list -->
<td width="42%"><a href="<? echo $url.$page ?><?php echo $row_Recordset1['siteid']; ?>" target="_blank"><?php echo $row_Recordset1['sitetitle']; ?> </td>
<!-- to add other database fields as links use this code <a href="<? echo $url.$page ?><?php echo $row_Recordset1['siteid']; ?>.html" target="_blank"></a> to just print text use ?php echo $row_Recordset1['e_8']; ?> replacing siteid or 8 with the needed database field -->
<td width="58%" rowspan="3" valign="top"><div align="center"></div></td>
</tr>
<tr>
<!-- start description-- to show the description simply remove the comment tages from in front -->
<!-- <td class="desc"><?php echo $row_Recordset1['sitedescription']; ?></td>
<!-- end description -->
</tr>
<tr>
<td> </td>
</tr>
</table>
<!-- end item -->
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
<p></p>
</body>