All pastes #259209 Raw Edit

Mine

public text v1 · immutable
#259209 ·published 2006-11-27 06:20 UTC
rendered paste body
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Caffeine-Studios</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style>
body{
background-color: #000000;
background-image: url
}

div.wrapper{ 
width: 600px;
margin-left: 300px;
margin-right: 300px;

}

div.apple{
width: 600px;
border-bottom: 1px dotted cyan;
border-top: 1px dotted cyan;
}


div.public {
border-style: solid;
border-color: #555555;
background-color: #000000;
border-width: 1px;
padding: 6px;
align: left;
}
div.split
{width: 600px;
border-bottom: 1px dashed #2D2D2D;
}

div.under
{width: 150px;
border-bottom: 1px dashed #000000;
}

.style2 {
	font-family: Arial, Helvetica, sans-serif;
	font-weight: bold;
}
.style4 {color: #333333}
.style6 {font-size: 9px}
a:link {
	color: #990000;
}
a:hover {
	color: #000000;
}
.style14 {
	font-family: Arial, Helvetica, sans-serif;
	font-size: 10px;
	font-weight: bold;
color: #00FFFF
}
.style24 {color: #33FFFF}
.style26 {font-family: Arial, Helvetica, sans-serif; font-weight: bold; color: #00FFFF; }
</style>
</head>

<body>
<div align="center" class="style2"><span class="style4"><span class="style24">Eddland<br>
      <span class="style6">Content Management System </span></span><span class="style6"><br>
    <br>
    <br>
</span></span></div>
<div align="center"><div class="wrapper">            </div>
<div class="apple">
  <table width="600" border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td height="179" bgcolor="#DDFFFF"><div class="public">
          <div align="left">
          <div class="under"><span class="style14">Entries<br>
          </span></div>
          <span class="style26"><br>
             <?php
//connect to mysql
//change user and password to your mySQL name and password
include 'library/config.php';
include 'library/opendb.php';
	
//select which database you want to edit


//select the table
$result = mysql_query("select * from news");


//grab all the content
while($r=mysql_fetch_array($result))



{	
   //the format is $variable = $r["nameofmysqlcolumn"];
   //modify these to match your mysql table columns
  
   $title=$r["title"];
   $content=$r["content"];
   $who=$r["who"];
   $date=$r["date"];
   $time=$r["time"];
   $id=$r["id"];
   
   //display the row
  
   echo "$title <br> $content <br> $who <br> $date $time <br>";
}
?>
</span></div>
        </div></td>
    </tr>
  </table>
    <br>
</div>
</div>
<div align="center" class="style14">Content Management system coded by Spangles.</div>
</body>
</html>