The problem: The real estate site has Visual Tours on it. Since it was only the
Visual Tour brand of tours, Visual Tour gave me a piece of code that would
work for all tours on the real estate site. All I had to plug into the MySQL
database table in the field Visual Tour Code was "View the Visual Tour" and it
dynamically looked at the MLS # and pulled the correct VT tour. I also had it
setup with a "Do not show if field is empty" You can look at the live site
here: [url]http://www.century21reu.com/buy/propertyMaster.php[/url]. You can scroll and
see some properties do not show a "View the Tour" and some do.

Now, I have this thrown into the mix. We need to change the code to allow for
other tours from other companies to get added into the database table. I'm
working with this page: [url]http://www.century21reu.com/buy/propertyMasterTest.php[/url].
If I put the code in for the URL server where the code is pulling from
"http://www.CompanyABC.com and then the code number" the path is what shows up
on the site. If I place some copy like: "View the Tour" and add a link to those
words, you can click that link and go to the tour from Company ABC. However,
all the properties now will display the "View the Tour" words when they don't
have a tour associated with them.

On this page: [url]http://www.century21reu.com/buy/propertyMasterTest.php[/url]. Scroll
down to property MLS# 55364 and I would like for my link to look that way. Now,
scroll down to property MLS# 57343 and I'd like to get the code that is
displaying attached to the "View the Tour"

It doesn't seem like this should be so difficult but I'm at a loss as to how
to code it to get it to work.:confused;
----------------------------------------------------------

<table align="center" border="1">
<tr bgcolor="#FFCC33">
<td colspan="2">&nbsp;</td>
</tr>
<?php do { ?>
<tr>
<td valign="top"><div align="center">
<p><a href="propertyDetail.php?<?php echo
$MM_keepURL.(($MM_keepURL!="")?"&":"")."MLS=".$row _rsProperties['MLS']."&AgentID
=".$row_rsProperties['AgentID'] ?>"><img
src="http://c21reu.com/images/properties/<?php echo $row_rsProperties['Image'];
?>" width="160" height="120" border="2"></a><br>
</p>
<p align="left"><em><font color="#FF9900" size="1"
face="Verdana, Arial, Helvetica, sans-serif">
<?php if ($totalRows_rsProperties > 0) { // Show if
recordset not empty ?>
<a href="<?php echo $row_rsProperties['VisualTourCode'];
?>" target="_blank"><?php echo $row_rsProperties['VisualTourCode']; ?></a>
<?php } // Show if recordset not empty ?>
</font></em></p>
</div></td>
<td valign="top" class="contentparagraph"><p><font
color="#000000"><strong>STATUS:
</strong></font><font color="#FF6600"><strong><?php echo
$row_rsProperties['Status']; ?><br>
</strong></font><strong>MLS:</strong> <strong><?php echo
$row_rsProperties['MLS']; ?></strong><br>
<strong> <font
color="#000000">PropertyType:</font></strong>
<?php echo $row_rsProperties['PropertyType']; ?><br>
List Price: <?php echo
DoFormatCurrency($row_rsProperties['ListPrice'], 0, '.', ',', '$'); ?><br>
City: <?php echo $row_rsProperties['City']; ?><br>
Bedrooms: <?php echo $row_rsProperties['Bedrooms']; ?> <br>
Baths: <?php echo $row_rsProperties['Baths']; ?><br>
Half Baths: <?php echo $row_rsProperties['HalfBaths']; ?>
<font size="2"><br>
Livable SqFt: </font><?php echo
$row_rsProperties['LivableSqFt']; ?></p>
<p>&nbsp;</p></td>
</tr>
<tr bgcolor="#FFCC33">
<td height="20" colspan="2">&nbsp;</td>
</tr>
<?php } while ($row_rsProperties =
mysql_fetch_assoc($rsProperties)); ?>
</table>