Re: Need Help Building - Dynamic php content using mySQL

From: Jado (ploxly_at_hotmail.com)
Date: 10/04/04 

Date: Mon, 4 Oct 2004 11:48:07 +0100

Hi

yes that's what i'm trying to acheive.

it looks like my request hint towards free labour..(see post after yours..)

that's not really what i'm after..although i wouldn't turn it away :-)

i posted my whole page to give the whole picture..

if you could start me off with the best way to acheive this, i'm quite happy
to finish the job myself.

Thanks

Jado

"the reporter" <reporter@home> wrote in message
news:415daea6@news.starhub.net.sg...
> 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>
> >
>
> --------------------------------------------------------------------------
> --
> > --------
> >
> >
>
>