Got a problem and I don't know where..please help
Posted: Sun Aug 21, 2005 8:49 am
Code: Select all
<?php session_start(); ?>
<?php
if ($_SESSION['usrlevel'] == ""){ echo '.<meta http-equiv="refresh" content="0;URL=unauthorized.php">.';
}elseif($_SESSION['usrlevel'] == "Yes"){
}elseif($_SESSION['usrlevel'] == "No"){ echo '.<meta http-equiv="refresh" content="0;URL=usercontent.php">.';
}else{ echo '.<meta http-equiv="refresh" content="0;URL=unauthorized.php">.';
}
?>
<?php
include_once("connect.php");
$sql = "SELECT DISTINCT id, companyname, address, postcode, workdone, doneby, doneon, addedby, addedon, comments from service_list ORDER BY id DESC";
$result = mysql_query($sql)
or die ("Couldn't select data from table");
echo "\n";
while ($line = mysql_fetch_array($result))
{
extract($line);
echo '<LINK REL=StyleSheet HREF="123.css" TYPE="text/css">
<html>
<head>
<title> <?php echo $_SESSION['firstname'] ?> - <?php echo $_SESSION['lastname'] ?> - <?php echo $_SESSION['companyname'] ?></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<style type="text/css">
<!--
.style10 {font-size: 36px}
.style11 {font-size: 36px; color: #999999; }
.style12 {color: #999999}
.style14 {font-size: 12px}
.style7 {font-size: 24px}
.style9 { color: #333333;
font-size: 12px;
}
body,td,th {
font-family: Geneva, Arial, Helvetica, sans-serif;
font-size: 12px;
color: #333333;
}
a:link {
color: #333333;
}
a:visited {
color: #333333;
}
a:hover {
color: #FF6600;
}
a:active {
color: #333333;
}
.style15 {color: #FFFFFF}
-->
</style>
</head>
<body>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<th width="1%" rowspan="9" valign="top" scope="col"> </th>
<th height="15" colspan="5" valign="top" scope="col"><div align="left" class="style10"></div>
<div align="left"> </div></th>
<th height="15" valign="middle" scope="col"><div align="left"></div></th>
</tr>
<tr>
<td height="27" colspan="5" valign="top"><div align="right"><span class="style7"></span></div>
<div align="left"><span class="style7"> <span class="style11"><img src="icons/crxlogo.jpg" width="341" height="42" /><span class="style9 style14"><b></b></span></span></span></div></td>
<td width="29%" valign="top" class="style9"><div align="left" class="style9 style14"><span class="style14 style15"><b><b><span class="style12"></span></b></b></span></div></td>
</tr>
<tr>
<td width="1%" valign="top">
<div align="right"><img src="icons/top_left.gif" width="11" height="36" /></div></td>
<td colspan="4" valign="top"><img src="icons/top_center.gif" width="100%" height="36" />
<div align="left"><span class="style14"></span> </div></td>
<td valign="top"><img src="icons/top_right.gif" width="11" height="36" /></td>
</tr>
<tr>
<td colspan="3" valign="middle"><div align="left"> <span class="style9"><span class="style14"><?php echo $_SESSION['firstname'] ?>,</span></span><span class="style14"> To view a companies report please click the green arrow.</span></div></td>
<td width="4%" valign="middle"><a href="http://www.vrconsult.co.uk"><img src="icons/home.jpg" width="28" height="28" border="0" /></a></td>
<td width="13%" valign="middle"><a href="http://www.vrconsult.co.uk">Back to Website </a></td>
<td><div align="left"><span class="style7"><span class="style9"></span></span></div></td>
</tr>
<tr>
<td colspan="5" rowspan="15" valign="top" class="style9"><div align="left" class="style14"> </div>
<div align="left"></div> <a href="http://www.vrconsult.co.uk"> </a>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<th width="1%" scope="col"> </th>
<th width="29%" bgcolor="#990000" scope="col"><span class="style15">'.$companyname.'</span></th>
<th width="43%" bgcolor="#003366" scope="col"><span class="style15">'.$workdone.'</span></th>
<th width="27%" bgcolor="#336633" scope="col"><span class="style15">'.$doneon.'</span></th>
</tr>
<tr>
<th colspan="2" scope="row"> </th>
<td> </td>
<td> </td>
</tr>
<tr>
<th colspan="2" scope="row"> </th>
<td> </td>
<td> </td>
</tr>
</table></td>
<td height="32"><div align="left"></div></td>
</tr>
<tr>
<td height="15" class="style9"><div align="left"></div>
<div align="left"></div>
<div align="left"><span class="style10"></span></div></td>
</tr>
<tr>
<td height="42" class="style9"><div align="left"> </div></td>
</tr>
<tr>
<td height="40"><div align="left"><span class="style10"></span></div></td>
</tr>
<tr>
<td><div align="left"></div></td>
</tr>
<tr>
<th scope="col"> </th>
<td> </td>
</tr>
<tr>
<th scope="col"> </th>
<td> </td>
</tr>
<tr>
<th scope="col"> </th>
<td> </td>
</tr>
<tr>
<th scope="col"> </th>
<td> </td>
</tr>
<tr>
<th scope="col"> </th>
<td> </td>
</tr>
<tr>
<th scope="col"> </th>
<td> </td>
</tr>
<tr>
<th scope="col"> </th>
<td> </td>
</tr>
<tr>
<th scope="col"> </th>
<td> </td>
</tr>
<tr>
<th scope="col"> </th>
<td> </td>
</tr>
<tr>
<th scope="col"> </th>
<td> </td>
</tr>
</table>
</body>
</html>
';
}
?>