well, first of all, the link to the site is broken. you are linking us to your cpanel and a https:// link. which most browsers find dangerous. anyways. It looks like it isnt retriving the data from the database. Is the table names and data bases exactly the same as they were on your colleges mysql database? If they arnt, you will have to change the table name in your code.
His source code:
HTML Code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link rel="stylesheet" type="text/css" href="NHS_CSS.css" />
<style type="text/css">
th
{color:#FFFFFF;
background-color:#000000}
td
{border-top-color:#000000;
border-top-width:1px;
border-top-style:dashed}
.white
{background-color:#FFFFFF}
.darkgray
{background-color:#999999}
.lightgray
{background-color: #CCCCCC;}
table
{border:2px solid #000000}
#mainfloat
{width:250px;
position:relative;
float:left}
#mainfloat2{
float:right
}
</style>
<title>Untitled Document</title>
</head>
<body>
<?php
mysql_connect("localhost", "nhsadmin_admin", "*********") or die('There was a problem connecting to the mysql server. Error returned: '. mysql_error());
mysql_select_db("NHS") or die('Could not select database');
?>
<div id="container">
<div id="header"><h1>HAHS National Honor Society</h1>
</div>
<div id="main">
<div id="topNavigation">
<a href="index.html">NHS Home</a> |
<a href="membersHome.html">Members Home</a> |
<a href="membersEvents.html">Events</a> |
Meetings |
<a href="membersCommittees.html">Committees</a> |
<a href="membersByLaws.html">By-Laws</a>
</div>
<div id="content">
<h2>Meetings</h2>
<?php
$rat = mysql_query("select * from meetings order by year asc");
$x=0;
while($row = mysql_fetch_array($rat)){
$output[$x] = $row;
$x++;
}
?>
<table>
<tr>
<th>Name</th>
<th>Date</th>
<th>Time</th>
</tr>
<?php
foreach($output as $value3){
if(($counter % 2) == 0){
echo"<tr class=\"white\">
<td>$value3[Name]</td>
<td>$value3[Date]</td>
<td>$value3[Time]</td>
</tr>";
}
else{
echo"<tr class=\"lightgray\">
<td>$value3[Name]</td>
<td>$value3[Date]</td>
<td>$value3[Time]</td>
</tr>";
}
$counter++;
}
?>
</table>
</div>
</div>
<div id="footer">Site Design by Shane Pile
</div>
</div>
</body>
</html>
LinkBack URL
About LinkBacks
Trouble getting info from mysql databases
Reply With Quote
