Convert Cold Fusion page to PHP

I have attached the code for a web page programmed using Cold Fusion. I now need to convert this page to PHP as GoDaddy does not support Cold Fusion any longer. I am not a PHP Programmer. I started with this and it seems to be working but this is as far as I have got.

<?php
// Connection's Parameters
$db_host="MyDatabase.db.7921172.hostedresource.com";
$db_name="MyDatabase";
$username="MyUsername";
$password="MyPassword";
$db_con=mysql_connect($db_host,$username,$password);
$connection_string=mysql_select_db($db_name);
// Connection
mysql_connect($db_host,$username,$password);
mysql_select_db($db_name);

// Query
$sql = 'SELECT name, uniqueid FROM Bands';
$getUser = mysql_query($sql);
?>
<html><!-- #BeginTemplate "/Templates/template_steve2.dwt" --><!-- DW6 -->
<head>
<!-- #BeginEditable "doctitle" --> 
<title>Fly Magazine-Bands/Performers Archive</title>
<cfquery name="misc" datasource="mysqlcf_barflymagazine" dbtype="ODBC">
select name, uniqueid from bands where (name > '1%') and (name < '9%') order by name
</cfquery>

<cfloop index="letter" from="97" to="122" step="1">
<cfquery name="#chr(letter)#" datasource="mysqlcf_barflymagazine" dbtype="ODBC">
select name, uniqueid from bands where (name like '#chr(letter)#%') order by name
</cfquery>
</cfloop>

<!-- #EndEditable --> 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="style.css" >
<meta name="keywords" content="Fly magazine, Barfly, Barfly Monthy, PA Nightlife, York nightlife, Lancaster Nightlife, Central PA, Central PA Entertainment, Lancaster Entertainment, Central PA Dining, dining guide">
<meta name="description" content="Fly Magazine is you most complete guide to Nightlife, Dining & Entertainment in Central Pennsylvania">
<style type="text/css">
<!--
.listings_index {
	font-family: Arial, Helvetica, sans-serif;
	font-size: 8pt;
}
-->
</style>
<SCRIPT LANGUAGE='JAVASCRIPT' TYPE='TEXT/JAVASCRIPT'>
 <!--
/**************************************************** 
     AUTHOR: WWW.CGISCRIPT.NET, LLC
     URL: http://www.cgiscript.net
     Use the code for FREE but leave this message intact.
     Download your FREE CGI/Perl Scripts today!
     ( http://www.cgiscript.net/scripts.htm )
****************************************************/
var win=null;
function NewWindow(mypage,myname,w,h,pos,infocus){
if(pos=="random"){myleft=(screen.width)?Math.floor(Math.random()*(screen.width-w)):100;mytop=(screen.height)?Math.floor(Math.random()*((screen.height-h)-75)):100;}
if(pos=="center"){myleft=(screen.width)?(screen.width-w)/2:100;mytop=(screen.height)?(screen.height-h)/2:100;}
else if((pos!='center' && pos!="random") || pos==null){myleft=0;mytop=20}
settings="width=" + w + ",height=" + h + ",top=" + mytop + ",left=" + myleft + ",scrollbars=no,location=no,directories=no,status=no,menubar=no,toolbar=no,resizable=no";win=window.open(mypage,myname,settings);
win.focus();}
// -->
</script>
</head>
<a name="top"></a>
<body bgcolor="#FFFFFF" link="#000099" vlink="#000099" alink="#000099">
<table border="0" cellpadding="0" cellspacing="0" width="761" align="center" bordercolor="#000000">
  <tr> 
    <td rowspan="2" valign="top" background="images/left_background.gif"> 
      <p><img src="images/flylogo.gif" width="175" height="133"></p>
      <table width="115" border="0" cellspacing="5" bgcolor="#FFFF99">
        <tr> 
          <td><img src="images/nav_currentissue.gif" width="115" height="19" border="0"></td>
        </tr>
        <tr> 
          <td height="13"><img src="images/nav_headline_links.gif" width="111" height="15" usemap="#Map8" border="0"><map name="Map8"><area shape="rect" coords="0,0,109,14" href="http://www.flymagazine.net/"></map></td>
        </tr>
        <tr> 
          <td> 
            <p><img src="images/nav_lancaster.gif" width="110" height="17"></p>
          </td>
        </tr>
        <tr> 
          <td height="40"><img src="images/nav_editionlinks.gif" width="111" height="43" usemap="#Map" border="0"><map name="Map"><area shape="rect" coords="2,0,110,11" href="lancaster/lanc_contents.htm"><area shape="rect" coords="1,9,110,20" href="lancaster/lanc_featurestory.htm"><area shape="rect" coords="2,20,112,30" href="lancaster/lanc_calendar.php"><area shape="rect" coords="2,30,112,41" href="lancaster/lanc_dining.php"></map></td>
        </tr>
        <tr> 
          <td><img src="images/nav_york.gif" width="110" height="17"></td>
        </tr>
        <tr> 
          <td height="29"><img src="images/nav_editionlinks.gif" width="111" height="43" usemap="#Map2" border="0"><map name="Map2"><area shape="rect" coords="1,-2,111,9" href="york/york_contents.htm"><area shape="rect" coords="0,9,110,20" href="york/york_featurestory.htm"><area shape="rect" coords="0,20,110,31" href="york/york_calendar.php"><area shape="rect" coords="1,30,111,42" href="york/york_dining.php"></map></td>
        </tr>
        <tr>
          <td><img src="images/nav_harrisburg.gif" width="110" height="17"></td>
        </tr>
        <tr>
          <td><img src="images/nav_editionlinks.gif" width="111" height="43" usemap="#Map10" border="0"><map name="Map10"><area shape="rect" coords="0,1,101,11" href="hsbg/hsbg_contents.htm"><area shape="rect" coords="2,10,77,21" href="hsbg/hsbg_featurestory.htm"><area shape="rect" coords="1,22,100,31" href="hsbg/hsbg_calendar.php"><area shape="rect" coords="1,30,106,41" href="hsbg/hsbg_dining.php"></map></td>
        </tr>
        <tr>
          <td><img src="images/nav_general.gif" width="110" height="17"></td>
        </tr>
        <tr>
          <td height="35"><p><img src="images/nav_editorial_links.gif" width="111" height="35" usemap="#Map3" border="0"></p></td>
        </tr>
        <tr> 
          <td height="35"> 
            <p><map name="Map3"><area shape="rect" coords="0,-2,110,11" href="movie_previews.htm"><area shape="rect" coords="-1,11,109,22" href="concert_listings.htm"><area shape="rect" coords="1,22,111,33" href="theatre_listings.htm"></map>
              <strong><font size="2pt"><img src="images/wheresthefly.gif" width="115" height="38"></font></strong><br>
          <span class="listings_index">Fly Magazine is distributed free to more than 820 locations throughout Central PA. See our <a href="http://www.flymagazine.net/list.htm">distribution list</a> for a location near you.</span></p></td>
        </tr>
        <tr> 
          <td><img src="images/nav_articlearchives.gif" width="115" height="19"></td>
        </tr>
        <tr> 
          <td height="27"><img src="images/nav_archive_links.gif" width="111" height="23" usemap="#Map4" border="0"><map name="Map4"><area shape="rect" coords="0,0,110,13" href="archive_dining.html"><area shape="rect" coords="0,12,110,23" href="archive_bands.html"></map></td>
        </tr>
        <tr> 
          <td><img src="images/nav_feedback.gif" width="115" height="19"></td>
        </tr>
        <tr> 
          <td height="26"><img src="images/nav_feedback_links.gif" width="111" height="33" usemap="#Map5" border="0"><map name="Map5"><area shape="rect" coords="0,0,109,34" href="feedback.htm"></map></td>
        </tr>
        <tr> 
          <td height="2"><img src="images/nav_aboutus.gif" width="115" height="19"></td>
        </tr>
        <tr> 
          <td height="48"><img src="images/nav_aboutus_links.gif" width="111" height="40" usemap="#Map6" border="0"><map name="Map6"><area shape="rect" coords="0,0,110,11" href="general_info.htm"><area shape="rect" coords="1,9,111,20" href="editorial_info.htm"><area shape="rect" coords="0,20,110,32" href="advertising_info.htm"><area shape="rect" coords="0,32,110,41" href="contacts.htm"></map></td>
        </tr>
        <tr> 
          <td><img src="images/nav_links.gif" width="115" height="19"></td>
        </tr>
        <tr> 
          <td height="27"><img src="images/nav_links_link.gif" width="111" height="23" usemap="#Map7" border="0"><map name="Map7"><area shape="rect" coords="0,0,110,12" href="links_bands.htm"><area shape="rect" coords="0,10,110,22" href="links_area_venues.htm"></map></td>
        </tr>
      </table>
      <table width="115" border="0" cellspacing="5" bgcolor="#FFFF99">
        <tr>
          <td height="27"><a href="http://www.harrisburghello.com"><img src="images/ad_buttons/hbghello_small.jpg" width="115" height="67" border="0"></a></td>
        </tr>
      </table></td>
    <td valign="top" rowspan="2"> 
      <p><img src="images/top_header.gif" width="403" height="84"><img src="images/address.gif" width="183" height="84" usemap="#Map9" border="0"><map name="Map9"><area shape="rect" coords="25,50,158,66" href="http://www.flymagazine.net/editor.html"></map></p>
      <!-- #BeginEditable "content" --> 
      <table width="586" border="0">
        <tr> 
          <td width="400"> 
            <table width="400" border="0" cellpadding="0">
              <tr> 
                <td colspan="2"><img src="images/headers/header_band_archive.gif" width="400" height="55"></td>
              </tr>
              <tr valign="top"> 
                <td colspan="2" height="219">
				<p>Click on a letter to jump down the archive list.</p>
				<p><font size="3"><b><a href="#a">A</a>
				<a href="#b">B</a>
				<a href="#c">C</a>
				<a href="#d">D</a>
				<a href="#e">E</a>
				<a href="#f">F</a>
				<a href="#g">G</a>
				<a href="#h">H</a>
				<a href="#i">I</a>
				<a href="#j">J</a>
				<a href="#k">K</a>
				<a href="#l">L</a>
				<a href="#m">M</a>
				<a href="#n">N</a>
				<a href="#o">O</a>
				<a href="#p">P</a>
				<a href="#q">Q</a>
				<a href="#r">R</a>
				<a href="#s">S</a>
				<a href="#t">T</a>
				<a href="#u">U</a>
				<a href="#v">V</a>
				<a href="#w">W</a>
				<a href="#x">X</a>
				<a href="#y">Y</a>
				<a href="#z">Z</a></b></font></p>
				<img src="images/blue_line.gif">				
				
				<p><table bgcolor="black" width="25"><tr><td align="center">
				<font color="white"><b>#'s</b></font>
				</td></tr></table>
				<cfoutput query="misc">
				<a href="archive_bands_article.cfm?id=#uniqueid#">#name#</a><br>
				</cfoutput></p>
				
				<cfloop index="letter" from="97" to="122" step="1">
				<p><cfoutput>
				
				<table bgcolor="black" width="25"><tr><td align="center">
				<font color="white"><b>
				<a name="#chr(letter)#">#ucase(chr(letter))#</a>
				</b></font>
				</td></tr></table>
				
				</cfoutput>
				<cfoutput query="#chr(letter)#">
				<a href="archive_bands_article.cfm?id=#uniqueid#">#name#</a><br>
				</cfoutput></p>
				</cfloop>		
                
				</td>
              </tr>
            </table>
            <p>&nbsp;</p>
            <p>&nbsp;</p>
            <p>&nbsp;</p>
          </td>
          <td bgcolor="#FFFFFF" width="177" background="images/right_line.gif" valign="top"><cfinclude template="Templates/ad_buttons.htm"></td>
        </tr>
      </table>
      <!-- #EndEditable -->
       </td>
  </tr>
</table>
<!-- #BeginEditable "properties" -->
<table width="761" border="0" cellspacing="0" cellpadding="0" align="center">
  <tr> 
    <td width="128" align="right"><img src="images/left_bottom_corner.gif" width="126" height="55"></td>
<td width="633" bgcolor="ffff99"><div align="center" style="border-top:4px solid #000;"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Copyright                     
            <script language="JavaScript">
new Date();
var d = new Date();
document.write(d.getFullYear()); 
            </script>
        . All Rights Reserved.</strong></font></div></td>
  </tr>
</table>
<!-- #EndEditable -->
<script type="text/javascript">


  var _gaq = _gaq || [];
  _gaq.push(['_setAccount', 'UA-323327-19']);
  _gaq.push(['_trackPageview']);


  (function() {
    var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
    ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
  })();


</script>
</body>
<!-- #EndTemplate --></html>

Open in new window

mburk1968Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Sudaraka WijesingheWeb Application ProgrammerCommented:
I think the most suitable solution for you is to find a new host that support CF, or hire a professional who know both CF and PHP to do the conversion.
0
eriksmtkaCommented:
there isn't really a whole lot of "CF" to refactor here.  it's just a couple of database queries and loops to output the data

understand of course, that with out a bank of test data, i can't really test this.  syntactically it should be correct though.  if you get any errors.. let me know, and i'll tell you if it's something that can be corrected without test data.

also.. it doesn't hurt to be "bi-lingual". ;) i would really advise you to pick up PHP and start coding in that.  PHP hosts are so ubiquitous and inexpensive.  CF is JUST NOT WORTH the paper it's printed on.

<html><!-- #BeginTemplate "/Templates/template_steve2.dwt" --><!-- DW6 -->
<head>
<!-- #BeginEditable "doctitle" --> 
<title>Fly Magazine-Bands/Performers Archive</title>

<?php
$db_host="MyDatabase.db.7921172.hostedresource.com";
$db_name="MyDatabase";
$username="MyUsername";
$password="MyPassword";

// Connection
mysql_connect($db_host,$username,$password);
mysql_select_db($db_name);

$conn = mysql_connect($db_host, $username, $password);
mysql_select_db($db_name, $conn);

$SQL = "select name, uniqueid from bands where (name > '1%') and (name < '9%') order by name";
$misc = mysql_query($SQL, $conn);

for ($letter = 97; $letter <= 122; $letter++) {
    $chrletter = chr($letter);
    $SQL = "select name, uniqueid from bands where (name like '$letter%') order by name";
    $result[$chrletter] = mysql_query($SQL, $conn);
}

?>

<!-- #EndEditable --> 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="style.css" >
<meta name="keywords" content="Fly magazine, Barfly, Barfly Monthy, PA Nightlife, York nightlife, Lancaster Nightlife, Central PA, Central PA Entertainment, Lancaster Entertainment, Central PA Dining, dining guide">
<meta name="description" content="Fly Magazine is you most complete guide to Nightlife, Dining & Entertainment in Central Pennsylvania">
<style type="text/css">
<!--
.listings_index {
	font-family: Arial, Helvetica, sans-serif;
	font-size: 8pt;
}
-->
</style>
<SCRIPT LANGUAGE='JAVASCRIPT' TYPE='TEXT/JAVASCRIPT'>
 <!--
/**************************************************** 
     AUTHOR: WWW.CGISCRIPT.NET, LLC
     URL: http://www.cgiscript.net
     Use the code for FREE but leave this message intact.
     Download your FREE CGI/Perl Scripts today!
     ( http://www.cgiscript.net/scripts.htm )
****************************************************/
var win=null;
function NewWindow(mypage,myname,w,h,pos,infocus){
if(pos=="random"){myleft=(screen.width)?Math.floor(Math.random()*(screen.width-w)):100;mytop=(screen.height)?Math.floor(Math.random()*((screen.height-h)-75)):100;}
if(pos=="center"){myleft=(screen.width)?(screen.width-w)/2:100;mytop=(screen.height)?(screen.height-h)/2:100;}
else if((pos!='center' && pos!="random") || pos==null){myleft=0;mytop=20}
settings="width=" + w + ",height=" + h + ",top=" + mytop + ",left=" + myleft + ",scrollbars=no,location=no,directories=no,status=no,menubar=no,toolbar=no,resizable=no";win=window.open(mypage,myname,settings);
win.focus();}
// -->
</script>
</head>
<a name="top"></a>
<body bgcolor="#FFFFFF" link="#000099" vlink="#000099" alink="#000099">
<table border="0" cellpadding="0" cellspacing="0" width="761" align="center" bordercolor="#000000">
  <tr> 
    <td rowspan="2" valign="top" background="images/left_background.gif"> 
      <p><img src="images/flylogo.gif" width="175" height="133"></p>
      <table width="115" border="0" cellspacing="5" bgcolor="#FFFF99">
        <tr> 
          <td><img src="images/nav_currentissue.gif" width="115" height="19" border="0"></td>
        </tr>
        <tr> 
          <td height="13"><img src="images/nav_headline_links.gif" width="111" height="15" usemap="#Map8" border="0"><map name="Map8"><area shape="rect" coords="0,0,109,14" href="http://www.flymagazine.net/"></map></td>
        </tr>
        <tr> 
          <td> 
            <p><img src="images/nav_lancaster.gif" width="110" height="17"></p>
          </td>
        </tr>
        <tr> 
          <td height="40"><img src="images/nav_editionlinks.gif" width="111" height="43" usemap="#Map" border="0"><map name="Map"><area shape="rect" coords="2,0,110,11" href="lancaster/lanc_contents.htm"><area shape="rect" coords="1,9,110,20" href="lancaster/lanc_featurestory.htm"><area shape="rect" coords="2,20,112,30" href="lancaster/lanc_calendar.php"><area shape="rect" coords="2,30,112,41" href="lancaster/lanc_dining.php"></map></td>
        </tr>
        <tr> 
          <td><img src="images/nav_york.gif" width="110" height="17"></td>
        </tr>
        <tr> 
          <td height="29"><img src="images/nav_editionlinks.gif" width="111" height="43" usemap="#Map2" border="0"><map name="Map2"><area shape="rect" coords="1,-2,111,9" href="york/york_contents.htm"><area shape="rect" coords="0,9,110,20" href="york/york_featurestory.htm"><area shape="rect" coords="0,20,110,31" href="york/york_calendar.php"><area shape="rect" coords="1,30,111,42" href="york/york_dining.php"></map></td>
        </tr>
        <tr>
          <td><img src="images/nav_harrisburg.gif" width="110" height="17"></td>
        </tr>
        <tr>
          <td><img src="images/nav_editionlinks.gif" width="111" height="43" usemap="#Map10" border="0"><map name="Map10"><area shape="rect" coords="0,1,101,11" href="hsbg/hsbg_contents.htm"><area shape="rect" coords="2,10,77,21" href="hsbg/hsbg_featurestory.htm"><area shape="rect" coords="1,22,100,31" href="hsbg/hsbg_calendar.php"><area shape="rect" coords="1,30,106,41" href="hsbg/hsbg_dining.php"></map></td>
        </tr>
        <tr>
          <td><img src="images/nav_general.gif" width="110" height="17"></td>
        </tr>
        <tr>
          <td height="35"><p><img src="images/nav_editorial_links.gif" width="111" height="35" usemap="#Map3" border="0"></p></td>
        </tr>
        <tr> 
          <td height="35"> 
            <p><map name="Map3"><area shape="rect" coords="0,-2,110,11" href="movie_previews.htm"><area shape="rect" coords="-1,11,109,22" href="concert_listings.htm"><area shape="rect" coords="1,22,111,33" href="theatre_listings.htm"></map>
              <strong><font size="2pt"><img src="images/wheresthefly.gif" width="115" height="38"></font></strong><br>
          <span class="listings_index">Fly Magazine is distributed free to more than 820 locations throughout Central PA. See our <a href="http://www.flymagazine.net/list.htm">distribution list</a> for a location near you.</span></p></td>
        </tr>
        <tr> 
          <td><img src="images/nav_articlearchives.gif" width="115" height="19"></td>
        </tr>
        <tr> 
          <td height="27"><img src="images/nav_archive_links.gif" width="111" height="23" usemap="#Map4" border="0"><map name="Map4"><area shape="rect" coords="0,0,110,13" href="archive_dining.html"><area shape="rect" coords="0,12,110,23" href="archive_bands.html"></map></td>
        </tr>
        <tr> 
          <td><img src="images/nav_feedback.gif" width="115" height="19"></td>
        </tr>
        <tr> 
          <td height="26"><img src="images/nav_feedback_links.gif" width="111" height="33" usemap="#Map5" border="0"><map name="Map5"><area shape="rect" coords="0,0,109,34" href="feedback.htm"></map></td>
        </tr>
        <tr> 
          <td height="2"><img src="images/nav_aboutus.gif" width="115" height="19"></td>
        </tr>
        <tr> 
          <td height="48"><img src="images/nav_aboutus_links.gif" width="111" height="40" usemap="#Map6" border="0"><map name="Map6"><area shape="rect" coords="0,0,110,11" href="general_info.htm"><area shape="rect" coords="1,9,111,20" href="editorial_info.htm"><area shape="rect" coords="0,20,110,32" href="advertising_info.htm"><area shape="rect" coords="0,32,110,41" href="contacts.htm"></map></td>
        </tr>
        <tr> 
          <td><img src="images/nav_links.gif" width="115" height="19"></td>
        </tr>
        <tr> 
          <td height="27"><img src="images/nav_links_link.gif" width="111" height="23" usemap="#Map7" border="0"><map name="Map7"><area shape="rect" coords="0,0,110,12" href="links_bands.htm"><area shape="rect" coords="0,10,110,22" href="links_area_venues.htm"></map></td>
        </tr>
      </table>
      <table width="115" border="0" cellspacing="5" bgcolor="#FFFF99">
        <tr>
          <td height="27"><a href="http://www.harrisburghello.com"><img src="images/ad_buttons/hbghello_small.jpg" width="115" height="67" border="0"></a></td>
        </tr>
      </table></td>
    <td valign="top" rowspan="2"> 
      <p><img src="images/top_header.gif" width="403" height="84"><img src="images/address.gif" width="183" height="84" usemap="#Map9" border="0"><map name="Map9"><area shape="rect" coords="25,50,158,66" href="http://www.flymagazine.net/editor.html"></map></p>
      <!-- #BeginEditable "content" --> 
      <table width="586" border="0">
        <tr> 
          <td width="400"> 
            <table width="400" border="0" cellpadding="0">
              <tr> 
                <td colspan="2"><img src="images/headers/header_band_archive.gif" width="400" height="55"></td>
              </tr>
              <tr valign="top"> 
                <td colspan="2" height="219">
				<p>Click on a letter to jump down the archive list.</p>
				<p><font size="3"><b><a href="#a">A</a>
				<a href="#b">B</a>
				<a href="#c">C</a>
				<a href="#d">D</a>
				<a href="#e">E</a>
				<a href="#f">F</a>
				<a href="#g">G</a>
				<a href="#h">H</a>
				<a href="#i">I</a>
				<a href="#j">J</a>
				<a href="#k">K</a>
				<a href="#l">L</a>
				<a href="#m">M</a>
				<a href="#n">N</a>
				<a href="#o">O</a>
				<a href="#p">P</a>
				<a href="#q">Q</a>
				<a href="#r">R</a>
				<a href="#s">S</a>
				<a href="#t">T</a>
				<a href="#u">U</a>
				<a href="#v">V</a>
				<a href="#w">W</a>
				<a href="#x">X</a>
				<a href="#y">Y</a>
				<a href="#z">Z</a></b></font></p>
				<img src="images/blue_line.gif">				
				
				<p><table bgcolor="black" width="25"><tr><td align="center">
				<font color="white"><b>#'s</b></font>
				</td></tr></table>
                <?php while ($record = mysql_fetch_assoc($misc)) { ?>

				<a href="archive_bands_article.cfm?id=#uniqueid#"><?php echo $record['name']; ?></a><br>
				<?php } ?></p>
				
				<?php foreach ($result as $letter => $sub_result) { ?>
                <p>
				
				<table bgcolor="black" width="25"><tr><td align="center">
				<font color="white"><b>
				<a name="<?php echo $letter; ?>"><?php echo strtoupper($letter); ?></a>
				</b></font>
				</td></tr></table>
				
				<?php while ($record = mysql_fetch_assoc($sub_result[$letter])) { ?>
				<a href="archive_bands_article.cfm?id=<?php echo $record['uniqueid']; ?>"><?php echo $record['name']; ?></a><br>
				</p>
				<?php } ?>
                
				</td>
              </tr>
            </table>
            <p>&nbsp;</p>
            <p>&nbsp;</p>
            <p>&nbsp;</p>
          </td>
          <td bgcolor="#FFFFFF" width="177" background="images/right_line.gif" valign="top"><cfinclude template="Templates/ad_buttons.htm"></td>
        </tr>
      </table>
      <!-- #EndEditable -->
       </td>
  </tr>
</table>
<!-- #BeginEditable "properties" -->
<table width="761" border="0" cellspacing="0" cellpadding="0" align="center">
  <tr> 
    <td width="128" align="right"><img src="images/left_bottom_corner.gif" width="126" height="55"></td>
<td width="633" bgcolor="ffff99"><div align="center" style="border-top:4px solid #000;"><font size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong>Copyright                     
            <script language="JavaScript">
new Date();
var d = new Date();
document.write(d.getFullYear()); 
            </script>
        . All Rights Reserved.</strong></font></div></td>
  </tr>
</table>
<!-- #EndEditable -->
<script type="text/javascript">


  var _gaq = _gaq || [];
  _gaq.push(['_setAccount', 'UA-323327-19']);
  _gaq.push(['_trackPageview']);


  (function() {
    var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
    ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
  })();


</script>
</body>
<!-- #EndTemplate --></html>

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mburk1968Author Commented:
I am getting this?
Parse error: syntax error, unexpected $end in D:\Hosting\7921172\html\archive_bands.php on line 247
0
mburk1968Author Commented:
Code displays and error in the browser. No additional support was provided.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PHP

From novice to tech pro — start learning today.