Re: Need Help Building - Dynamic php content using mySQL

From: the reporter (reporter_at_home)
Date: 10/02/04 

Date: Sun, 3 Oct 2004 03:21:29 +0800

huh? what do u wish to achieve?

i believe that u have some data stored in mySQL and want to use PHP to
extract the information out and display it in HTML format?

"Jado" <ploxly@hotmail.com> wrote in message
news:415d266a$0$22757$db0fefd9@news.zen.co.uk...
> Hi
>
> I'm trying to output a fact *** so people without correct software
> applications can view data on our intranet using a browser
>
> I know little about php and mySQL, but someone else has installed all that
> for me.
>
> basically I've designed a html page as I would like the output to look.
> wherever I've wanted to display dynamic content pulled from mySQL, I've
> added a place holder in the format of '$VarName'.
>
> I was wondering if anyone would look at my html page and convert it to how
> it needs to be in order to work under php.
>
> I know I will need to run a query in order to return 1 record to display,
so
> I will ask that question in another article.
>
> Thanks
>
> Jado
>
> Here's the html
> -----------------------------------------------------------
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD><TITLE>Information ***</TITLE>
> <META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
> <STYLE type=text/css>A:link {
> COLOR: #0044dd; TEXT-DECORATION: underline
> }
> A:visited {
> COLOR: #0044dd; TEXT-DECORATION: underline
> }
> A:hover {
> COLOR: #0066ff; TEXT-DECORATION: none
> }
> A:active {
> COLOR: #0066ff; TEXT-DECORATION: none
> }
> </STYLE>
>
> <META content="MSHTML 6.00.2800.1458" name=GENERATOR></HEAD>
> <BODY text=#000000 bgColor=#aaddff>
> <CENTER>
> <strong><font color="#000000">Information ***</font></strong><br>
> <table width="585" height="163" border="1" align="center"
cellpadding="5"
> bordercolor="#000000" bgcolor="#99CCFF">
> <tr>
> <td width="577" height="157"><strong><font color="#000000">
> Updates</font></strong>
> <table width="577" border="1" cellpadding="5"
bordercolor="#666666"
> bgcolor="#FFFFFF">
> <tr>
> <td width="140"><strong>Action Date</strong></td>
> <td width="405">&nbsp;</td>
> </tr>
> <tr>
> <td><strong>Action Taken</strong></td>
> <td>&nbsp;</td>
> </tr>
> <tr>
> <td><strong>Actioned By</strong></td>
> <td>&nbsp;</td>
> </tr>
> <tr>
> <td><strong>Notes</strong></td>
> <td>&nbsp;</td>
> </tr>
> </table>
> </td>
> </tr>
> </table>
> <p><B>Lead Created: &nbsp;&nbsp;<font
> color="#FF0000">$CurrentDate</font></B>
> </p>
> <TABLE
> style="BORDER-RIGHT: #000099 3px solid; PADDING-RIGHT: 3px; BORDER-TOP:
> #000099 3px solid; PADDING-LEFT: 5px; BORDER-LEFT: #000099 3px solid;
> BORDER-BOTTOM: #000099 0px solid"
> cellSpacing=0 cellPadding=0 width=600 bgColor=#ffffff border=0>
> <TBODY>
> <TR>
> <TD colSpan=2>
> <DIV align=center><B><FONT size=+2>Infomation
> ***</FONT></B></DIV></TD></TR>
> <TR>
> <TD colSpan=2><B><FONT size=2>GENERAL COMPANY
> INFORMATION</FONT></B></TD></TR>
> <TR>
> <TD colSpan=2>Company Name: <font
> color="#cc0000">$Company</font></TD>
> </TR>
> <TR>
> <TD width="50%">Tel No: <FONT color=#cc0000>$TelNo</FONT></TD>
> <TD width="50%">New Tel No: <FONT
> color=#cc0000>&nbsp;$NewTelNo</FONT></TD>
> </TR>
> <TR>
> <TD colSpan=2>Address: <FONT color=#cc0000>$Adr1<font
> color="#000000">,
> </font>$Adr2<font color="#000000">, </font>$Adr3</FONT></TD>
> </TR>
> <TR>
> <TD vAlign=top>Town/City: <FONT
color=#cc0000>$TownCity</FONT></TD>
> <TD vAlign=top>Post Code: <FONT
color=#cc0000>$PostCode</FONT></TD>
> </TR>
> <TR>
> <TD vAlign=top>Fax No: <FONT
color=#cc0000>&nbsp;$FaxNo</FONT></TD>
> <TD vAlign=top>Address last checked: <FONT
> color=#cc0000>$AdrChecked</FONT></TD>
> </TR>
> <TR>
> <TD colSpan=2>Website: <font color="#CC0000">$WebSite</font></TD>
> <TR>
> <TD colSpan=2><B><FONT size=2><BR>CONTACT
> INFORMATION</FONT></B></TD></TR>
> <TR>
> <TD vAlign=top>Full Name: <FONT color=#cc0000>$Title, $FirstName,
> $Surname</FONT></TD>
> <TD vAlign=top>Position: <FONT color=#cc0000>$Position</FONT></TD>
> </TR>
> <TR>
> <TD vAlign=top>Direct Line No: <FONT
> color=#cc0000>&nbsp;$DirectLineNo</FONT></TD>
> <TD vAlign=top>E-mail: <font color="#CC0000">$EMail</font></TD>
> </TR>
> <TR>
> <TD colSpan=2><B><FONT size=2><BR>ACTION FIELDS</FONT></B></TD></TR>
> <TR>
> <TD vAlign=top>Immeditate Attention: <FONT
> color=#cc0000>&nbsp;$ImmAtt</FONT></TD>
> <TD vAlign=top>Literature: <FONT
> color=#cc0000>$Literature</FONT></TD>
> </TR>
> <TR>
> <TD vAlign=top>On-Site Appointment: <FONT
> color=#cc0000>&nbsp;$OnSiteAppt</FONT></TD>
> <TD vAlign=top>Tel Appointment: <FONT
> color=#cc0000>$TelAppt</FONT></TD>
> </TR>
> <TR>
> <TD colSpan=2><B><FONT size=2><BR>SPECIFIC COMPANY
> INFORMATION</FONT></B></TD></TR>
> <TR>
> <TD vAlign=top>Nature of Business: <FONT
> color=#cc0000>&nbsp;$NOB</FONT></TD>
> <TD vAlign=top>Aware of Company: <FONT
> color=#cc0000>$AwareOfCo</FONT></TD>
> </TR>
> <TR>
> <TD>Employees: <FONT color=#cc0000>$Emps</FONT></TD>
> <TD>Turnover: <FONT color=#cc0000>&nbsp;$TurnOver</FONT></TD>
> </TR>
> <TR>
> <TD>SIC Code: <FONT color=#cc0000>$SIC</FONT></TD>
> <TD>Data Type: <FONT color=#cc0000>$DataType</FONT></TD>
> </TR>
> <TR>
> <TD colSpan=2>
> <CENTER>
> <HR width=500 color=blue>
> <FONT
> color=#cc0000><SPAN class=961501612-14012004></SPAN></FONT> <B> </B>
> </CENTER>
> <p>Misc1: <font color="#FF0000">$Misc1</font><br>
> Misc2: <font color="#CC0000">$Misc2</font><br>
> Misc3: <font color="#CC0000">$Misc3<B> </B></font></p>
> <B>
> <DIV align=center>Updated Date- <FONT
> color=#cc0000>$UpdatedDate</FONT></DIV>
> </B><BR><B>
> <DIV align=center>Updated By- <FONT
> color=#cc0000>$UpdatedBy</FONT></DIV>
> </B>
> <TR>
> <TD align=left colSpan=2>
> <HR align=center width=500 color=blue>
> Notes: <FONT color=#cc0000>$Notes</FONT> &nbsp;</TD>
> </TR></TBODY></TABLE>
> <TABLE
> style="BORDER-RIGHT: #000099 3px solid; BORDER-TOP: #000099 2px solid;
> PADDING-LEFT: 5px; BORDER-LEFT: #000099 3px solid; BORDER-BOTTOM: #000099
> 3px solid"
> cellSpacing=0 cellPadding=0 width=600 bgColor=#ffffff border=0>
> <TBODY>
> <TR>
> <TD vAlign=top bgColor=#e0e0e0 colSpan=2><B><FONT
> size=+1>Disclaimer:</FONT></B><BR>
> <FONT size=-1>Blah, Blah, Blah.</FONT></TD>
> </TR></TBODY></TABLE></CENTER></BODY></HTML>
>
> -------------------------------------------------------------------------- 

--
> --------
>
>