Thanks for the reply. When I added:
<tr>
<td colspan=3 ><center>
<?php printf($result[PAYPAL_BUTTON]);
echo mysql_errno() . ": " . mysql_error() . "\n";?>
</center>
</td>
</tr>
</td> </center>
</tr>
It returned the value 0:, which to me is saying that its not pulling back
the data, but I'm not sure why. The data in the PAYPAL_BUTTON field is:
<FORM method="POST" >
<P><INPUT type="submit" value="Submit" name="subBut">
</FORM>
I will paste the entirety of my code for your reference. I'm stumped.
Thanks again.
Mark
CODE:
=============================
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<title><<website.com>></title>
<base target="main">
</HEAD>
<BODY vlink=#003399" link= #003399" background=main_files/background.gif
class=ltBackground>
<IMG alt=spacer height=1 src="main_files/spacer.gif" vspace=5 width=1><BR>
<!-- Set up connection to database -->
<?php
$db = mysql_connect("localhost", "username", "password");
mysql_select_db("website_com",$db);
$result = mysql_query("SELECT * FROM PRODUCTS where HPG_PLAN_ID =
'$planid'",$db);
?>
<TABLE align=center border=0 cellPadding=0 cellSpacing=0
width=766>
<TBODY>
<TR>
<TD vAlign=top height="100%" border=1>
<TABLE align=center border=0 cellPadding=0 cellSpacing=3 cols=2
width=708 height="60%">
<TBODY>
<TR valign=top>
<TD class=bodyText width="701" height="438" border=1>
<font size=16px face="Verdana, Arial, Helvetica, sans-serif">
<?php
printf("<b>Plan ID:</b> %s<br>\n",
mysql_result($result,0,"HPG_PLAN_ID"));
?>
</font>
<img src="main_files/darkgrey_bar.gif" height="38">
<table border=2 width=100%>
<?php
if ($result[PLAN_NAME]<>" ") {;
printf ("<tr valign=top><font size=13px face=Verdana, Arial,
Helvetica, sans-serif>");
printf ("<td colspan=3><b>Plan Name:</b>
%s<br>\n", mysql_result($result,0,"PLAN_NAME"));
printf ("</td>");
printf ("</tr></font>");
};
?>
<tr>
<td colspan=3><?php printf("<b>Plan Description:</b>
%s<br>\n", mysql_result($result,0,"PLAN_DESCRIPTION")); ?>
</td>
</tr>
<tr>
<td> <?php printf("<b>Heated Sq. Ft:</b>
%s<br>\n", mysql_result($result,0,"HEAT_SQ_FT")); ?>
</td>
<td><?php printf("<b>Exterior:</b> %s<br>\n",
mysql_result($result,0,"EXTERIOR")); ?>
</td>
<td><?php printf("<b>Number of Bedrooms:</b>
%s<br>\n", mysql_result($result,0,"NUM_BEDROOMS")); ?>
</td>
</tr>
<tr>
<td> <?php printf("<b>Un-Heated Sq. Ft:</b>
%s<br>\n", mysql_result($result,0,"UNHEAT_SQ_FT")); ?>
</td>
<td><?php printf("<b>Foundation Type(s):</b>
%s<br>\n", mysql_result($result,0,"FOUNDATION")); ?>
</td>
<td><?php printf("<b>Number of Baths:</b>
%s<br>\n", mysql_result($result,0,"NUM_BATHS")); ?>
</td>
</tr>
<tr>
<td> <?php printf("<b>Total Sq. Ft:</b>
%s<br>\n", mysql_result($result,0,"TOTAL_SQ_FT")); ?>
</td>
<td><?php printf("<b>Number of Floors:</b>
%s<br>\n", mysql_result($result,0,"NUM_FLOORS")); ?>
</td>
<td><?php printf("<b>Roof Type(s):</b>
%s<br>\n", mysql_result($result,0,"ROOF_TYPE")); ?>
</td>
</tr>
<tr>
<td> <?php printf("<b>Bonus Room:</b>
%s<br>\n", mysql_result($result,0,"BONUS_ROOM")); ?>
</td>
<td><?php printf("<b>Garage:</b> %s<br>\n",
mysql_result($result,0,"GARAGE")); ?>
</td>
<td><?php printf("<b>Number of Cars:</b>
%s<br>\n", mysql_result($result,0,"NUM_CARS")); ?>
</td>
</tr>
<tr>
<td><?php printf("<b>Roof Pitch:</b> %s<br>\n",
mysql_result($result,0,"ROOF_PITCH")); ?>
</td>
<td><?php printf("<b>Width:</b> %s<br>\n",
mysql_result($result,0,"WIDTH")); ?>
</td>
<td><?php printf("<b>Depth:</b> %s<br>\n",
mysql_result($result,0,"DEPTH")); ?>
</td>
</tr>
<tr>
<td><?php printf("<b>Sec. Roof Pitch:</b>
%s<br>\n", mysql_result($result,0,"SEC_ROOF_PITCH")); ?>
</td>
<td><?php printf("<b>Main Ceiling Height:</b>
%s<br>\n", mysql_result($result,0,"MAIN_CEIL_HEIGHT")); ?>
</td>
<td>
</td>
</font>
</tr>
<tr>
<td colspan=3 ><center>
<?php printf($result[PAYPAL_BUTTON]);
echo mysql_errno() . ": " . mysql_error() . "\n";?>
</center>
</td>
</tr>
</td> </center>
</tr>
<tr>
<td bgcolor=#F0F8FF colspan=3><font size=5><b>Optional
Products / Services:</b>
</td></font>
</tr>
<tr>
<td><?php printf("<b>Materials List
Available:</b> %s<br>\n", mysql_result($result,0,"MAT_LIST"));
?>
</td>
<td><?php printf("<b>Reproducible Sets
Available:</b> %s<br>\n",
mysql_result($result,0,"REPRODUCIBLE")); ?>
</td>
<td><?php printf("<b>Color Rendering
Available:</b> %s<br>\n", mysql_result($result,0,"COLOR_REND"));
?>
</td>
</tr>
<tr>
<td><?php printf("<b>Right-Reading Reverse Floorplan
Available:</b> %s<br>\n", mysql_result($result,0,"RR_REVERSE"));
?>
</td>
<td><?php printf("<b>Mirror Reverse Floorplan
Available:</b> %s<br>\n", mysql_result($result,0,"MIRROR_REV"));
?>
</td>
<td><?php printf("<b>CAD Files Available:</b>
%s<br>\n", mysql_result($result,0,"CAD_FILES")); ?>
</td>
</tr>
<tr>
<td colspan=3 >
</td>
</tr>
<tr>
<td colspan=3 bgcolor=#F0F8FF><font size=5> <b>Front
Elevation:<b>
</td> </font>
</tr>
<tr>
<td colspan=3 >
<?php echo "<img
src='http://www.website.com/index_files/main_files/$planid/"; .
mysql_result($result, 0,'FRONT_REND')."'>'"; ?>
</td>
</tr>
<tr>
<td colspan=3 bgcolor=#F0F8FF><font size=5> <b>First Floor
Plan:<b>
</td></font>
</tr>
<tr>
<td colspan=3 >
<?php echo "<img
src='http://www.website.com/index_files/main_files/$planid/"; .
mysql_result($result, 0,'FLRPLAN_1')."'>'"; ?>
</td>
</tr>
<?php
if ($result[FLRPLAN_2]<>" ") {
printf ("<tr>");
printf ("<td colspan=3 bgcolor=#F0F8FF>");
printf ("<font size=5> <b>Second Floor Plan:<b>
</td></font>") ;
printf ("</tr>") ;
printf ("<tr>");
printf ("<td colspan=3 >") ;
echo "<img
src='http://www.website.com/index_files/main_files/$planid/"; .
mysql_result($result, 0,'FLRPLAN_2')."'>'";
printf (" </td>") ;
printf ("</tr> ");
};
if ($result[FLRPLAN_3]<>" ") {;
printf ("<tr>");
printf ("<td colspan=3 bgcolor=#F0F8FF><font size=5>
<b>Third Floor Plan:<b> ");
printf ("</td></font> ");
printf ("</tr> ");
printf ("<tr> ");
printf ("<td colspan=3 >");
echo "<img
src='http://www.website.com/index_files/main_files/$planid/"; .
mysql_result($result, 0,'FLRPLAN_3')."'>'";
printf ("</td> ");
printf ("</tr> ");
};
if ($result[REAR_REND]<>" ") {;
printf ("<tr>");
printf (" <td colspan=3 bgcolor=#F0F8FF><font size=5>
<b>Rear Elevation:<b> ");
printf (" </td></font> ");
printf ("</tr> ");
printf ("<tr> ");
printf ("<td colspan=3 >");
echo "<img
src='http://www.website.com/index_files/main_files/$planid/"; .
mysql_result($result, 0,'REAR_REND')."'>'";
printf ("</td> ");
printf ("</tr> ");
};
if ($result[SIDE_REND1]<>" ") {;
printf ("<tr>");
printf ("<td colspan=3 bgcolor=#F0F8FF><font size=5>
<b>Side Elevation 1:<b> ");
printf ("</td></font> ");
printf ("</tr> ");
printf ("<tr> ");
printf ("<td colspan=3 >");
echo "<img
src='http://www.website.com/index_files/main_files/$planid/"; .
mysql_result($result, 0,'SIDE_REND1')."'>'";
printf ("</td> ");
printf ("</tr> ");
};
if ($result[SIDE_REND2]<>" ") {;
printf ("<tr>");
printf ("<td colspan=3 bgcolor=#F0F8FF><font size=5>
<b>Side Elevation 2:<b> ");
printf ("</td></font> ");
printf ("</tr> ");
printf ("<tr> ");
printf ("<td colspan=3 >");
echo "<img
src='http://www.website.com/index_files/main_files/$planid/"; .
mysql_result($result, 0,'SIDE_REND2')."'>'";
printf ("</td> ");
printf ("</tr> ");
};
if ($result[OTHER_IMG1]<>" ") {;
printf ("<tr>");
printf ("<td colspan=3 bgcolor=#F0F8FF><font size=5>
<b>Other Images:<b> ");
printf ("</td></font> ");
printf ("</tr> ");
printf ("<tr> ");
printf ("<td colspan=3 >");
echo "<img
src='http://www.website.com/index_files/main_files/$planid/"; .
mysql_result($result, 0,'OTHER_IMG1')."'>'";
if ($result[OTHER_IMG2]<>" ") {;
echo "<br><img
src='http://www.website.com/index_files/main_files/$planid/"; .
mysql_result($result, 0,'OTHER_IMG2')."'>'";
};
printf ("</td> ");
printf ("</tr> ");
};
if ($result[REL_PLAN1]<>" ") {;
printf ("<tr>");
printf ("<td colspan=3 > ");
printf ("</td>");
printf ("</tr>");
printf (" <tr>");
printf ("<td colspan=3 bgcolor=#F0F8FF><font size=4>
<b>Like this plan, but its not exactly what you're looking for? ");
printf ("Check out these similar plan(s): <b>");
printf (mysql_result($result, 0,'REL_PLAN1'),
mysql_result($result,0,"REL_PLAN1"));
};
if ($result[REL_PLAN2]<>" ") {;
printf (", ");
printf (mysql_result($result, 0,'REL_PLAN2'),
mysql_result($result,0,"REL_PLAN2"));
};
if ($result[REL_PLAN3]<>" ") {;
printf (", ");
printf (mysql_result($result, 0,'REL_PLAN3'),
mysql_result($result,0,"REL_PLAN3"));
};
if ($result[REL_PLAN4]<>" ") {;
printf (", ");
printf (mysql_result($result, 0,'REL_PLAN4'),
mysql_result($result,0,"REL_PLAN4"));
};
if ($result[REL_PLAN5]<>" ") {;
printf (", ");
printf (mysql_result($result, 0,'REL_PLAN5'),
mysql_result($result,0,"REL_PLAN5"));
};
if ($result[REL_PLAN6]<>" ") {;
printf (", ");
printf (mysql_result($result, 0,'REL_PLAN6'),
mysql_result($result,0,"REL_PLAN6"));
};
if ($result[REL_PLAN7]<>" ") {;
printf (", ");
printf (mysql_result($result, 0,'REL_PLAN7'),
mysql_result($result,0,"REL_PLAN7"));
};
if ($result[REL_PLAN8]<>" ") {;
printf (", ");
printf (mysql_result($result, 0,'REL_PLAN8'),
mysql_result($result,0,"REL_PLAN8"));
};
if ($result[REL_PLAN9]<>" ") {;
printf (", ");
printf (mysql_result($result, 0,'REL_PLAN9'),
mysql_result($result,0,"REL_PLAN9"));
};
printf ("</td></font>");
printf ("</tr>");
printf ("</font> ");
printf ("</table>");
//include files
include("includes/footer.php");
?>
</SPAN></p>
</TD>
</TR>
</TD>
</TR>
</TBODY>
</TABLE>
</TD>
</TR>
</TBODY>
</TABLE>
</BODY></HTML>
=============================
"David Robley" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> says...
> > It doesn't bring back any HTML when I view the source:
> >
> > <tr>
> > <td colspan=3 ><center>
> >
> >
> > </center>
> > </td>
> > </tr>
> >
> > I tried the addslashes and stripslashes but I'm not sure that I had the
> > syntax right. Any ideas? Thanks.
> >
> > Mark
> >
> > "Dasmeet Singh" <[EMAIL PROTECTED]> wrote in message
> > news:[EMAIL PROTECTED]...
> > > Markbm wrote:
> > > > I am working through an issue where I'm trying to display HTML code,
> > stored
> > > > in a text field in a MySQL database. The code that I have looks
like
> > this:
> > > >
> > > > <tr>
> > > > <td colspan=3 ><center>
> > > > <?php printf($result[PAYPAL_BUTTON]); ?>
</center>
> > > > </td>
> > > > </tr>
> > > >
> > > > This code displays nothing when viewed on the web server, although
the
> > > > contents of the db field are:
> > > >
> > > > <FORM method="POST" >
> > > > <P><INPUT type="submit" value="Submit" name="subBut">
> > > > </FORM>
> > > >
> > > > Question:
> > > >
> > > > 1. How do I get this code to display correctly (i.e. create the
button
> > /
> > > > not show the underlying HTML)?
> > > >
> > > > Any help would be greatly appreciated. Thanks for your help.
> > > >
> > > > Mark
> > > >
> > > >
> > > >
> > >
> > > Can you tell what HTML do you get from web server..ie when you view
>
> Check that your mysql query is working correctly and actually returning
> data - mysql_error is a useful debugging tool. If all else fails, try
> showing the code you are using to retrieve from the db.
>
> --
> David Robley
> Temporary Kiwi!
>
> Quod subigo farinam
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
