Need Help Building - Dynamic php content using mySQL

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

Next message: Newsgroup Poster: "Re: Need Help Building - Dynamic php content using mySQL"
Previous message: Newsgroup Poster: "Re: Php version"
Next in thread: Newsgroup Poster: "Re: Need Help Building - Dynamic php content using mySQL"
Reply: Newsgroup Poster: "Re: Need Help Building - Dynamic php content using mySQL"
Reply: the reporter: "Re: Need Help Building - Dynamic php content using mySQL"
Reply: Wes S.: "Re: Need Help Building - Dynamic php content using mySQL"
Reply: ScareCrowe: "Re: Need Help Building - Dynamic php content using mySQL"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Date: Fri, 1 Oct 2004 10:41:58 +0100

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>
 Information *** 
 <table width="585" height="163" border="1" align="center" cellpadding="5"
bordercolor="#000000" bgcolor="#99CCFF">
 <tr>
 <td width="577" height="157">
Updates
 <table width="577" border="1" cellpadding="5" bordercolor="#666666"
bgcolor="#FFFFFF">
 <tr>
 <td width="140">Action Date</td>
 <td width="405"> </td>
 </tr>
 <tr>
 <td>Action Taken</td>
 <td> </td>
 </tr>
 <tr>
 <td>Actioned By</td>
 <td> </td>
 </tr>
 <tr>
 <td>Notes</td>
 <td> </td>
 </tr>
 </table>
 </td>
 </tr>
 </table>
 Lead Created:   $CurrentDate
 
 <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>Infomation
***</DIV></TD></TR>
 <TR>
 <TD colSpan=2>GENERAL COMPANY
INFORMATION</TD></TR>
 <TR>
 <TD colSpan=2>Company Name: $Company</TD>
 </TR>
 <TR>
 <TD width="50%">Tel No: $TelNo</TD>
 <TD width="50%">New Tel No:  $NewTelNo</TD>
 </TR>
 <TR>
 <TD colSpan=2>Address: $Adr1,
 $Adr2, $Adr3</TD>
 </TR>
 <TR>
 <TD vAlign=top>Town/City: $TownCity</TD>
 <TD vAlign=top>Post Code: $PostCode</TD>
 </TR>
 <TR>
 <TD vAlign=top>Fax No:  $FaxNo</TD>
 <TD vAlign=top>Address last checked: $AdrChecked</TD>
 </TR>
 <TR>
 <TD colSpan=2>Website: $WebSite</TD>
 <TR>
 <TD colSpan=2> CONTACT
INFORMATION</TD></TR>
 <TR>
 <TD vAlign=top>Full Name: $Title, $FirstName,
$Surname</TD>
 <TD vAlign=top>Position: $Position</TD>
 </TR>
 <TR>
 <TD vAlign=top>Direct Line No:  $DirectLineNo</TD>
 <TD vAlign=top>E-mail: $EMail</TD>
 </TR>
 <TR>
 <TD colSpan=2> ACTION FIELDS</TD></TR>
 <TR>
 <TD vAlign=top>Immeditate Attention:  $ImmAtt</TD>
 <TD vAlign=top>Literature: $Literature</TD>
 </TR>
 <TR>
 <TD vAlign=top>On-Site Appointment:  $OnSiteAppt</TD>
 <TD vAlign=top>Tel Appointment: $TelAppt</TD>
 </TR>
 <TR>
 <TD colSpan=2> SPECIFIC COMPANY
 INFORMATION</TD></TR>
 <TR>
 <TD vAlign=top>Nature of Business:  $NOB</TD>
 <TD vAlign=top>Aware of Company: $AwareOfCo</TD>
 </TR>
 <TR>
 <TD>Employees: $Emps</TD>
 <TD>Turnover:  $TurnOver</TD>
 </TR>
 <TR>
 <TD>SIC Code: $SIC</TD>
 <TD>Data Type: $DataType</TD>
 </TR>
 <TR>
 <TD colSpan=2>
 <CENTER>
 <HR width=500 color=blue>
 
</CENTER>
 Misc1: $Misc1 
 Misc2: $Misc2 
 Misc3: $Misc3 
 
 <DIV align=center>Updated Date- $UpdatedDate</DIV>
 
 <DIV align=center>Updated By- $UpdatedBy</DIV>
 
 <TR>
 <TD align=left colSpan=2>
 <HR align=center width=500 color=blue>
 Notes: $Notes  </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>Disclaimer: 
 Blah, Blah, Blah.</TD>
 </TR></TBODY></TABLE></CENTER></BODY></HTML>

----------------------------------------------------------------------------
--------

Next message: Newsgroup Poster: "Re: Need Help Building - Dynamic php content using mySQL"
Previous message: Newsgroup Poster: "Re: Php version"
Next in thread: Newsgroup Poster: "Re: Need Help Building - Dynamic php content using mySQL"
Reply: Newsgroup Poster: "Re: Need Help Building - Dynamic php content using mySQL"
Reply: the reporter: "Re: Need Help Building - Dynamic php content using mySQL"
Reply: Wes S.: "Re: Need Help Building - Dynamic php content using mySQL"
Reply: ScareCrowe: "Re: Need Help Building - Dynamic php content using mySQL"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]