Here's the entire member directory page converted using asp2php.exe
<head>
<title>WCAA Member Directory - Professionals in Drapes, Blinds, Shades, and Window Coverings</title>
<META NAME="GOOGLEBOT" CONTENT="NOSNIPPET">
<META NAME="ROBOTS" CONTENT="NOINDEX, NOFOLLOW">
<META NAME="ROBOTS" CONTENT="NOARCHIVE">
<script language="JavaScript">
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
// --></script>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="JavaScript">
<!-- hide this script from non-javascript-enabled browsers
if (document.images) {
}
function di(id,name){
if (document.images) {document.images[id].src=eval(name+".src"); }
}
// function that displays status bar message
function dm(msgStr) {
document.returnValue = false;
if (document.images) {
window.status = msgStr;
document.returnValue = true;
}
}
var showMsg = navigator.userAgent != "Mozilla/4.0 (compatible; MSIE 4.0; Mac_PowerPC)";
function dmim(msgStr) {
document.returnValue = false;
if (showMsg) {
window.status = msgStr;
document.returnValue = true;
}
}
// stop hiding -->
</script>
<?
//<--- Code added 11-10-00 By Brian
$sPercent=char(37);
$sQuote=char(34);
//assign Form Variables to local variable
$sSearch=${"SearchField"};
$sValue=${"SearchTxt"};
$sSort=${"Sort"};
$sPerPage=${"PerPage"};
//Setup base SQL Query
$sSQL="SELECT * FROM member WHERE 1 = 1";
//Fill Where clause of search
if (strlen($sValue))
{
switch (strtolower($sSearch))
{
case "company":
$sCrit=" AND company LIKE '%".$sValue."%'";
break;
case "contact":
$sCrit=" AND contact LIKE '%".$sValue."%'";
break;
case "state":
$sCrit=" AND state LIKE '%".$sValue."%'";
break;
case "zip":
$sCrit=" AND zip LIKE '%".$sValue."%'";
break;
case "keyword":
$sCrit=" AND keyword LIKE '%".$sValue."%'";
break;
}
}
//Determine how items are sorted
$sCrit=$sCrit." ORDER BY company ".$sSort;
//<--- End of code addition
//Set RS properties and connect to database
// $Recordset1 is of type "ADODB.Recordset"
$With.$ActiveConnection="dsn=wcaadata;";
$Source=$sSQL.$sCrit;
$CursorType=0;
$CursorLocation=2;
$LockType=3;
$Open; //Retrieve Values
;
}
;
$Recordset1_numRows=0;
?><?
//Set Number of Rows per page
if (strlen($sPerPage)==0)
{
$sPerPage="20";
}
$Repeat1__numRows=intval($sPerPage);
$Repeat1index=0;
$Recordset1_numRows=$Recordset1_numRows+$Repeat1numRows;
?> <?
// *** Recordset Stats, Move To Record, and Go To Record: declare stats variables
$Recordset1_total=mysql_num_rows($Recordset1_query); // set the record count
;
// set the number of rows displayed on this page
if (($Recordset1_numRows<0))
{
$Recordset1_numRows=$Recordset1_total;
}
else
if (($Recordset1_numRows==0))
{
$Recordset1_numRows=1;
}
// set the first and last displayed record
$Recordset1_first=1;
$Recordset1_last=$Recordset1_first+$Recordset1_numRows-1;
// if we have the correct record count, check the other stats
if (($Recordset1_total!=+1))
{
if (($Recordset1_first>$Recordset1_total))
{
$Recordset1_first=$Recordset1_total;
}
if (($Recordset1_last>$Recordset1_total))
{
$Recordset1_last=$Recordset1_total;
}
if (($Recordset1_numRows>$Recordset1_total))
{
$Recordset1_numRows=$Recordset1_total;
}
}
?> <?
// *** Recordset Stats: if we don't know the record count, manually count them
if (($Recordset1_total==+1))
{
// count the total records by iterating through the recordset
$Recordset1_total=0;
while((!($Recordset1==0)))
{
$Recordset1_total=$Recordset1_total+1;
$Recordset1=mysql_fetch_array($Recordset1_query);
}
// reset the cursor to the beginning
if ((>0))
{
}
else
{
}
// set the number of rows displayed on this page
if (($Recordset1_numRows<0 || $Recordset1_numRows>$Recordset1_total))
{
$Recordset1_numRows=$Recordset1_total;
}
// set the first and last displayed record
$Recordset1_first=1;
$Recordset1_last=$Recordset1_first+$Recordset1_numRows-1;
if (($Recordset1_first>$Recordset1_total))
{
$Recordset1_first=$Recordset1_total;
}
if (($Recordset1_last>$Recordset1_total))
{
$Recordset1_last=$Recordset1_total;
}
}
?> <?
// *** Move To Record and Go To Record: declare variables
$MM_rsCount=$Recordset1_total;
$MM_size=$Recordset1_numRows;
$MM_uniqueCol="";
$MM_paramName="";
$MM_offset=0;
$MM_atTotal=false;
$MM_paramIsDefined=false;
if (($MM_paramName!=""))
{
$MM_paramIsDefined=($HTTP_GET_VARS[$MM_paramName]<>"");
}
?> <?
// *** Move To Record: handle 'index' or 'offset' parameter
if ((!$MM_paramIsDefined && $MM_rsCount!=0))
{
// use index parameter if defined, otherwise use offset parameter
$r=$HTTP_GET_VARS["index"];
if ($r=="")
{
$r=$HTTP_GET_VARS["offset"];
}
if (strlen($r))
{
$MM_offset=intval($r);
}
// if we have a record count, check if we are past the end of the recordset
if (($MM_rsCount!=+1))
{
if (($MM_offset>=$MM_rsCount || $MM_offset==+1))
{
// past end or move last
}
if ((($MM_rsCount$Mod$MM_size)>0))
{
// last page not a full repeat region
}
$MM_offset=$MM_rsCount-($MM_rsCount%$MM_size);
}
else
{
$MM_offset=$MM_rsCount-$MM_size;
}
}
$End$If;
// move the cursor to the selected record
$i=0;
while(((!$MM_rs$EOF) && ($i<$MM_offset || $MM_offset==+1)))
{
$MM_rs.$MoveNext;
$i=$i+1;
}
if (($MM_rs$EOF))
{
$MM_offset=$i; // set MM_offset to the last possible record
;
}
$End$If;
?> <?
// *** Move To Record: if we dont know the record count, check the display range
if (($MM_rsCount==+1))
{
// walk to the end of the display range for this page
$i=$MM_offset;
while((!$MM_rs$EOF && ($MM_size<0 || $i<$MM_offset+$MM_size)))
{
$MM_rs.$MoveNext;
$i=$i+1;
}
// if we walked off the end of the recordset, set MM_rsCount and MM_size
if (($MM_rs$EOF))
{
$MM_rsCount=$i;
if (($MM_size<0 || $MM_size>$MM_rsCount))
{
$MM_size=$MM_rsCount;
}
}
// if we walked off the end, set the offset based on page size
if (($MM_rs$EOF && !$MM_paramIsDefined))
{
if (($MM_offset>$MM_rsCount+$MM_size || $MM_offset==+1))
{
if ((($MM_rsCount$Mod$MM_size)>0))
{
$MM_offset=$MM_rsCount-($MM_rsCount%$MM_size);
}
else
{
$MM_offset=$MM_rsCount-$MM_size;
}
}
}
// reset the cursor to the beginning
if (($MM_rs$CursorType>0))
{
$MM_rs.$MoveFirst;
}
else
{
$MM_rs.$Requery;
}
// move the cursor to the selected record
$i=0;
while((!$MM_rs$EOF && $i<$MM_offset))
{
$MM_rs.$MoveNext;
$i=$i+1;
}
}
?> <?
// *** Move To Record: update recordset stats
// set the first and last displayed record
$Recordset1_first=$MM_offset+1;
$Recordset1_last=$MM_offset+$MM_size;
if (($MM_rsCount!=+1))
{
if (($Recordset1_first>$MM_rsCount))
{
$Recordset1_first=$MM_rsCount;
}
if (($Recordset1_last>$MM_rsCount))
{
$Recordset1_last=$MM_rsCount;
}
}
// set the boolean used by hide region to check if we are on the last record
$MM_atTotal=($MM_rsCount<>-1&$MM_offset+$MM_size>=$MM_rsCount);
?> <?
// *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters
// create the list of parameters which should not be maintained
$MM_removeList="&index=";
if (($MM_paramName!=""))
{
$MM_removeList=$MM_removeList."&".$MM_paramName."=";
}
$MM_keepURL=""; $MM_keepForm=""; $MM_keepBoth=""; $MM_keepNone="";
// add the URL parameters to the MM_keepURL string
foreach ($HTTP_GET_VARS as $Item)
{
} echo "&".$Item."=";
if (((strpos(1,$MM_removeList,$NextItem,1) ? strpos(1,$MM_removeList,$NextItem,1)+1 : 0)==0))
{
$MM_keepURL=$MM_keepURL.$NextItem.rawurlencode($HTTP_GET_VARS[$Item]);
}
$Next;
// add the Form variables to the MM_keepForm string
foreach ($HTTP_POST_VARS as $Item)
{
} echo "&".$Item."=";
if (((strpos(1,$MM_removeList,$NextItem,1) ? strpos(1,$MM_removeList,$NextItem,1)+1 : 0)==0))
{
$MM_keepForm=$MM_keepForm.$NextItem.rawurlencode($HTTP_POST_VARS[$Item]);
}
$Next;
// create the Form + URL string and remove the intial '&' from each of the strings
$MM_keepBoth=$MM_keepURL.$MM_keepForm;
if (($MM_keepBoth!=""))
{
$MM_keepBoth=substr($MM_keepBoth,strlen($MM_keepBoth)-(strlen($MM_keepBoth)-1));
}
if (($MM_keepURL!=""))
{
$MM_keepURL=substr($MM_keepURL,strlen($MM_keepURL)-(strlen($MM_keepURL)-1));
}
if (($MM_keepForm!=""))
{
$MM_keepForm=substr($MM_keepForm,strlen($MM_keepForm)-(strlen($MM_keepForm)-1));
}
// a utility function used for adding additional parameters to these strings
function MM_joinChar($firstItem)
{
global extract($GLOBALS);
if (($firstItem!=""))
{
return "&";
}
else
{
return "";
}
}
?> <?
// *** Move To Record: set the strings for the first, last, next, and previous links
$MM_keepMove=$MM_keepBoth;
$MM_moveParam="index";
// if the page has a repeated region, remove 'offset' from the maintained parameters
if (($MM_size>0))
{
$MM_moveParam="offset";
if (($MM_keepMove!=""))
{
$params=$Split[$MM_keepMove,"&"];
$MM_keepMove="";
for ($i=0; $i<=count($params); $i=$i+1)
{
$nextItem=substr($params[$i],0,(strpos($params[$i],"=") ? strpos($params[$i],"=")+1 : 0)-1);
if ((strcmp($nextItem,$MM_moveParam,1)!=0))
{
$MM_keepMove=$MM_keepMove."&".$params[$i];
}
}
if (($MM_keepMove!=""))
{
$MM_keepMove=substr($MM_keepMove,strlen($MM_keepMove)-(strlen($MM_keepMove)-1));
}
}
}
// set the strings for the move to links
if (($MM_keepMove!=""))
{
$MM_keepMove=$MM_keepMove."&";
}
$urlStr=${"URL"}."?".$MM_keepMove.$MM_moveParam."=";
$MM_moveFirst=$urlStr."0";
$MM_moveLast=$urlStr."-1";
$MM_moveNext=$urlStr.$MM_offset+$MM_size;
$prev=$MM_offset-$MM_size;
if (($prev<0))
{
$prev=0;
}
$MM_movePrev=$urlStr.$prev;
?>
</head>
<body bgcolor="#003399" topmargin="0" leftmargin="0" bgproperties="fixed" text="#000099" link="#0000FF" alink="#000099" vlink="#0000FF">
<div align="center">
<table border="0" cellpadding="0" cellspacing="0">
<tr><!-- spacing row, 0 height. -->
<td><IMG height=1 src="db-parts/databasetemp_00.gif" width=86 border=0></td>
<td><IMG height=1 src="db-parts/databasetemp_00.gif" width=52 border=0></td>
<td><IMG height=1 src="db-parts/databasetemp_00.gif" width=38 border=0></td>
<td><IMG height=1 src="db-parts/databasetemp_00.gif" width=78 border=0></td>
<td><IMG height=1 src="db-parts/databasetemp_00.gif" width=108 border=0></td>
<td><IMG height=1 src="db-parts/databasetemp_00.gif" width=419 border=0></td>
</tr>
<tr><!-- row 01 -->
<td colspan="4" ><IMG height=74 src="db-parts/databasetemp_01_01.gif" width=254 border=0 name=Ndatabasetemplate1_01_01></td>
<td><IMG height=74 src="db-parts/databasetemp_01_05.gif" width=108 border=0 name=Ndatabasetemplate1_01_05></td>
<td rowspan="2" ><IMG height=81 src="db-parts/databasetemp_01_06.gif" width=419 border=0 name=Ndatabasetemplate1_01_06></td>
<td><IMG height=74 src="db-parts/databasetemp_00.gif" width=1 border=0></td>
</tr>
<tr><!-- row 02 -->
<td colspan="4" ><IMG height=7 src="db-parts/databasetemp_02_01.gif" width=254 border=0 name=Ndatabasetemplate1_02_01></td>
<td rowspan="3" ><a href="http://www.wcaa.org/"><IMG height=41 src="db-parts/databasetemp_02_0501.gif" width=108 border=0 name=Ndatabasetemplate1_02_05></a></td>
<td><IMG height=7 src="db-parts/databasetemp_00.gif" width=1 border=0></td>
</tr>
<tr><!-- row 03 -->
<td ><A href="http://www.wcaa.org/meet.html"><IMG height=22 alt="Meet the Members of WCAA Today..." src ="db-parts/databasetemp_03_01.gif" width=86 border=0 name=Ndatabasetemplate1_03_01 ></A></td>
<td colspan="2" ><A href="https://asp3.catalog.com/markn/join_wcaa.html"><IMG height=22 alt="Secure, Online Registration for Your Professional Future..." src ="db-parts/databasetemp_03_02.gif" width=90 border=0 name=Ndatabasetemplate1_03_02 ></A></td>
<td ><A href="http://www.wcaa.org/feedback.html"><IMG height=22 alt="Send Ideas, Questions, Complaints or Suggestions..." src ="db-parts/databasetemp_03_0401.gif" width=78 border=0 name=Ndatabasetemplate1_03_04 ></A></td>
<td rowspan="2" ><IMG height=34 src="db-parts/databasetemp_03_0601.gif" width=419 border=0 name=Ndatabasetemplate1_03_06></td>
<td><IMG height=22 src="db-parts/databasetemp_00.gif" width=1 border=0></td>
</tr>
<tr><!-- row 04 -->
<td colspan="4" ><IMG height=12 src="db-parts/databasetemp_04_0101.gif" width=254 border=0 name=Ndatabasetemplate1_04_01></td>
<td><IMG height=12 src="db-parts/databasetemp_00.gif" width=1 border=0></td>
</tr>
<tr><!-- row 05 -->
<td colspan="2" ><img src="db-parts/databasetemp_05_0101.gif" align=top border=0 name=Ndatabasetemplate1_05_01 width="138" height="85" ></td>
<td colspan="4" valign="middle" align=middle>
<div align="left"><font face="Tahoma"><b><i><font size="5" color="#FFFFFF">WCAA
Member Locator </font></i></b></font></div>
</td>
<td><IMG height=85 src="db-parts/databasetemp_00.gif" width=1 border=0></td>
</tr>
<tr><!-- row 06 --> </tr>
</table>
<form name="form1" method="post" action="">
<div align="center">
<table width="600" border="0" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF" align="center">
<tr>
<td width="22">
<div align="left"><img src="corners1_r1_c1.gif" width="35" height="36"></div>
</td>
<td width="537">
<div align="center"><font face="Tahoma"><b><i><font size="5"></font></i></b><font size="3"><b><i>Find
a Window Coverings Professional</i></b></font></font></div>
</td>
<td width="41">
<div align="right"><img src="corners1_r1_c3.gif" width="30" height="36"></div>
</td>
</tr>
</table>
<table width="600" border="0" cellspacing="0" cellpadding="0" align="center" bgcolor="#FFFFFF">
<tr>
<td width="20"> </td>
<td width="96"> </td>
<td width="98"> </td>
<td width="104"><font size="2" face="Arial"></font></td>
<td width="160"> </td>
<td width="122"> </td>
</tr>
<tr>
<td width="20"> </td>
<td width="96"><font size="2"><b><font face="Arial">Records per Page:</font></b></font></td>
<td width="98"><i><b><font face="Times New Roman, Times, serif" size="2">
<select name=PerPage>
<option>5</option>
<option>10</option>
<option>15</option>
<option selected>20</option>
<option>50</option>
<option>100</option>
</select>
</font></b></i></td>
<td width="104"><font size="2" face="Arial"><b> Search By:</b></font></td>
<td width="160"><font size="2"><b><font face="Times New Roman, Times, serif">
<select name=SearchField>
<option <? if ($sSearch=="Company" || $sSearch=="")
{
print "Selected";} ?>>Company</option>
<option <? if ($sSearch=="Contact")
{
print "Selected";} ?>>Contact</option>
<option <? if ($sSearch=="State")
{
print "Selected";} ?>>State</option>
<option <? if ($sSearch=="Zip")
{
print "Selected";} ?>>Zip</option>
<option <? if ($sSearch=="Keyword")
{
print "Selected";} ?>>Keyword</option>
</select>
<font face="Arial"> </font></font></b></font></td>
<td width="122"><font size="2"><b><font face="Times New Roman, Times, serif"><font face="Arial">State:
2 letters</font></font></b></font></td>
</tr>
<tr>
<td width="20"> </td>
<td width="96"><font size="2" face="Arial"><b>Sort Order:</b></font></td>
<td width="98"><i><b><font face="Times New Roman, Times, serif" size="2">
<select name=Sort>
<option value="asc" <? if (strtolower($sSort)=="asc" || $sSort=="")
{
print "Selected";} ?>>Ascending</option>
<option value="desc" <? if (strtolower($sSort)=="desc")
{
print "Selected";} ?>>Descending</option>
</select>
</font></b></i></td>
<td width="104"><font size="2" face="Arial"><b> Search Text:</b></font></td>
<td width="160"><font size="2" face="Times New Roman, Times, serif"><i><b>
<input style="LEFT: 19px; TOP: 2px" name=SearchTxt value=<? echo $sValue; ?>>
</b></i></font></td>
<td width="122"><font size="2"><i><b>
<input type=submit value=Search name=btnSearch>
</b></i></font></td>
</tr>
<tr>
<td width="20"> </td>
<td width="96"> </td>
<td width="98"> </td>
<td width="104"> </td>
<td width="160"> </td>
<td width="122"> </td>
</tr>
</table>
<table style="WIDTH: 600px" cellspacing=0 cellpadding=0 border=0 bgcolor="#FFFFFF" align="center">
<tr>
<td width="5%"> </td>
<? if ($MM_offset+$MM_size>=0)
{
?>
<td width="17%">
<div align="center"><font face="Times New Roman, Times, serif" size="3"><i><a href="<? echo $MM_movePrev; ?>"><b>Previous</b></a></i></font></div>
</td>
<? }
else
{
?>
<td width="11%"><i><font size="3" face="Times New Roman, Times, serif"><b>
Previous</b></font></i></td>
<? } ?>
<td width="53%" align=center><i><font face="Times New Roman, Times, serif" size="3"><b>Records
<? echo $Recordset1_first; ?> To <? echo $Recordset1_last; ?></b></font></i></td>
<? if ($MM_offset+$MM_Size<$MM_rsCount)
{
?>
<td width="14%" align=right>
<div align="center"><font face="Times New Roman, Times, serif" size="3"><i><a href="<? echo $MM_moveNext; ?>"><b>Next</b></a></i></font></div>
</td>
</tr>
<? }
else
{
?>
<tr>
<td width="5%" align=right height="21" bgcolor="#FFFFFF"> </td>
<td width="17%" align=right height="21" bgcolor="#FFFFFF"><font face="Times New Roman, Times, serif" size="3"><b>Next</b></font></td>
</tr>
<? } ?>
</table>
<table style="WIDTH: 600px" cellspacing=0 cellpadding=0 border=0 bgcolor="#FFFFFF" align="center">
<tr>
<td width="41%"> </td>
<td width="25%"> </td>
<td width="13%"> </td>
<td width="21%"> </td>
</tr>
<tr>
<td width="41%">
<div align="left"><font size="4" face="Times New Roman, Times, serif"><b> 
  Company</b></font></div>
</td>
<td width="25%">
<div align="left"><font size="4" face="Times New Roman, Times, serif"><b>Contact</b></font></div>
</td>
<td width="13%">
<div align="left"><font size="4" face="Times New Roman, Times, serif"><b>State</b></font></div>
</td>
<td width="21%">
<div align="left"><font size="4" face="Times New Roman, Times, serif"><b>Zip
Code</b> </font></div>
</td>
</tr>
<tr>
<?
while((($Repeat1__numRows!=0) && (!($Recordset1==0))))
{
$offset=($Recordset1["memberID"]-1);
print "<TD>    <A HREF=member-info.asp?offset=".$offset.">".
$recordset1["COMPANY"]."</A></TD>".char(13);
print "<TD>".$recordset1["CONTACT"]."</TD>".char(13);
print "<TD>".$recordset1["STATE"]."</TD>".char(13);
print "<TD>".$recordset1["ZIP"]."</TD>".char(13)."</TR>".char(13);
$Repeat1index=$Repeat1index+1;
$Repeat1numRows=$Repeat1numRows-1;
$Recordset1=mysql_fetch_array($Recordset1_query);
flush();
}
$Recordset1=null;
//Clean up object
?>
<tr>
<td width="41%" height="19"> </td>
<td width="25%" height="19"> </td>
<td width="13%" height="19"> </td>
<td width="21%" height="19"> </td>
</tr>
<tr> </tr>
</table>
<table style="WIDTH: 600px" cellspacing=0 cellpadding=0 border=0 bgcolor="#FFFFFF" align="center"
>
<tr>
<td width="106">
<div align="left"><img src="corners1_r3_c1.gif" width="35" height="29"></div>
</td>
<td colspan=3> </td>
<td width="22">
<div align="right"><img src="corners1_r3_c3.gif" width="30" height="29"></div>
</td>
</tr>
</table>
<p> </p>
</div>
</form>
</div>
</body>
