[left]can someone tell me why this doesnt work…[/left]
[left] [/left]
<html>
<head>
<title>Here are your records:</title>
<meta http-equiv=“Content-Type” content=“text/html; charset=iso-8859-1”>
<style type=“text/css”>
<!–
body {
font-family: Tahoma, Verdana, Arial, sans-serif;
font-size: 16px;
color: #FFFFFF;
background-color: #999999;
}
.row {
font-family: Tahoma, Verdana, Arial, sans-serif;
font-size: 16px;
font-weight: 900;
color: #FFFFFF;
background-color: #000000;
border: 2px solid #FFFFFF;
}
.body1 {
font-family: Tahoma, Verdana, Arial, sans-serif;
font-size: 16px;
font-weight: normal;
color: #000000;
background-color: #6699FF;
border: 2px solid #FFFFFF;
}
.body2 {
font-family: Tahoma, Verdana, Arial, sans-serif;
font-size: 16px;
font-weight: normal;
background-color: #006699;
color: #FFFFFF
}
–>
</style>
</head>
<body>
<table width=“50%” align=“center”>
<tr class=“row”><td>Name</td><td>Email</td><td>Website</td></tr>
<?php
$connection = mysql_connect(“localhost”, “nigolmvc_nigolmv”, “******”) or die(“Error connecting to database”);
mysql_select_db(“nigolmvc_nightspotz”, $connection);
$result = mysql_query(“SELECT * FROM guestbook ORDER BY id”, $connection) or die(“error querying database”);
$i = 0;
while($result_ar = mysql_fetch_assoc($result)){
?>
<tr <?php if($i%2 == 1){ echo “class=‘body2’”; }else{echo “class=‘body1’”;}?>>
<td>
<?php echo $result_ar[‘name’]; ?></td>
<td>
<?php echo $result_ar[‘email’]; ?>
</td>
<td>
<?php echo $result_ar[‘website’]; ?>
</td>
</tr>
<?php
$i+=1;
}
?>
</table>
</body>
</html>
