dl("php_mssql.dll");
require('forsaletop.html');
$id=mssql_connect("autoagent1","mls","87ghe+92jf9823nmf0902!n?f72g67");
mssql_select_db("mls",$id);
$list=mssql_query("select * from listings where listtype='2' order by categoryid",$id);
$numrows=mssql_num_rows($list);
$i=0;
while ($i<$numrows):
$categoryid=mssql_result($list,$i,"categoryid");
$listingid=mssql_result($list,$i,"listingid");
$userid=mssql_result($list,$i,"userid");
$cat=mssql_query("select * from categories where categoryid='$categoryid'",$id);
$category=mssql_result($cat,0,"category");
mssql_free_result($cat);
$users=mssql_query("select * from mlsusers where userid='$userid'",$id);
$company=mssql_result($users,0,"company");
$name=mssql_result($users,0,"name");
$email=mssql_result($users,0,"email");
$phone=mssql_result($users,0,"phone");
$fax=mssql_result($users,0,"fax");
$url=mssql_result($users,0,"url");
mssql_free_result($users);
$filename=$listingid.".txt";
// get contents of a file into a string
$filename = "submittal/listings/$filename";
if (file_exists($filename)):
$fd = fopen( $filename, "r" );
$contents = fread( $fd, filesize( $filename ) );
fclose($fd);
$listing=stripslashes($contents);
endif;
echo "
";
if ($categoryidold!=$categoryid):
echo "