Page 1 of 1

Got a problem and I don't know where..please help

Posted: Sun Aug 21, 2005 8:49 am
by ianhull

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">&nbsp;</th>
    <th height="15" colspan="5" valign="top" scope="col"><div align="left" class="style10"></div>
        <div align="left"> &nbsp;</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">&nbsp;<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">&nbsp;&nbsp;&nbsp;&nbsp;<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">&nbsp;</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">&nbsp;</th>
        <td>&nbsp;</td>
        <td>&nbsp;</td>
      </tr>
      <tr>
        <th colspan="2" scope="row">&nbsp;</th>
        <td>&nbsp;</td>
        <td>&nbsp;</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">&nbsp;</th>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <th scope="col">&nbsp;</th>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <th scope="col">&nbsp;</th>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <th scope="col">&nbsp;</th>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <th scope="col">&nbsp;</th>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <th scope="col">&nbsp;</th>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <th scope="col">&nbsp;</th>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <th scope="col">&nbsp;&nbsp;</th>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <th scope="col">&nbsp;</th>
    <td>&nbsp;</td>
  </tr>
  <tr>
    <th scope="col">&nbsp;</th>
    <td>&nbsp;</td>
  </tr>
</table>
</body>
</html>

';
      }
?>
Have not got a clue why.

Posted: Sun Aug 21, 2005 8:50 am
by ianhull
My error is

Parse error: parse error, unexpected T_STRING, expecting ',' or ';' in C:\Xeneo\vr\admin\view_reports.php on line 25

Posted: Sun Aug 21, 2005 9:13 am
by bokehman
You cannot do this: <?php echo $_SESSION['companyname'] ?> in the middle of a string literal. Try the following:

Code: Select all

echo '<LINK REL=StyleSheet HREF="123.css" TYPE="text/css">
<html>
<head>
<title> '.$_SESSION['firstname'].' - '.$_SESSION['lastname'].' - '.$_SESSION['companyname'].'</title>

Posted: Sun Aug 21, 2005 9:15 am
by feyd
misplaced a dot in there bokehman. ;)