I am creating a custom template for my site I simply want to select some data from my database and print it out but vbulletin is throwing me back an error and the page doesn't work properly. Im thinking it might just be my sloppy PHP coding.
The following error occurred when attempting to evaluate this template:
Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/fhlinux205/h/halo3forum.co.uk/user/htdocs/includes/adminfunctions_template.php(3593) : eval()'d code on line 41
This is likely caused by a malformed conditional statement. It is highly recommended that you fix this error before continuing, but you may continue as-is if you wish.
is the error.. My code is as follows:
Obviously I have the ** replaced with my database connection details.
I believe the problem comes from this part of the code
Any help greatly appreciated.
The following error occurred when attempting to evaluate this template:
Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/fhlinux205/h/halo3forum.co.uk/user/htdocs/includes/adminfunctions_template.php(3593) : eval()'d code on line 41
This is likely caused by a malformed conditional statement. It is highly recommended that you fix this error before continuing, but you may continue as-is if you wish.
is the error.. My code is as follows:
PHP Code:
$stylevar[htmldoctype]
<html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">
<head>
$headinclude
<title>$vboptions[bbtitle]</title>
</head>
<body>
$header
$navbar
<!-- Custom Code Start Here -->
<center>
<table width="100%" bgcolor="#f5f5ff" cellspacing="0" cellpadding="2" style="border-top:1px solid black; border-left:1px solid black; border-right:1px solid black;">
<tr><td class="tcat" style="border-bottom:1px solid black;">Teams</td></tr>
<tr><td> Add a team </td></tr></table>
<br><br>
<table width="100%" bgcolor="#f5f5ff" cellspacing="0" cellpadding="2" style="border-top:1px solid black; border-left:1px solid black; border-right:1px solid black;">
<tr><td class="tcat" style="border-bottom:1px solid black;">Current Teams</td></tr>
<tr><td>
<?php
$dbhost = '**';
$dbuser = '**';
$dbpass = '**';
$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die();
$dbname = 'ionxdesign';
mysql_select_db($dbname);
$query="select * from teams order by id";
$result=mysql_query($query);
if (!$result)
{
die (mysql_error());
}
$num_rows=mysql_num_rows($result);
for ($i=0;$i<$num_rows;$i++)
{
$row=mysql_fetch_array($result);
$teamname=($row['teamname']);
$p1=($row['p1']);
$p2=($row['p2']);
$p3=($row['p3']);
$p4=($row['p4']);
echo '<table>
<tr><td><b>' . ($row['teamname']) . '</b></td></tr>
<tr><td>' . ($row['p1']) . '</td></tr>
<tr><td>' . ($row['p2']) . '</td></tr>
<tr><td>' . ($row['p3']) . '</td></tr>
<tr><td>' . ($row['p4']) . '</td></tr>
</table><br><br>';
}
?>
</td></tr></table>
<!-- / Custom Code Ends here -->
$footer
</body>
</html>
I believe the problem comes from this part of the code
PHP Code:
$p1=($row['p1']);
$p2=($row['p2']);
$p3=($row['p3']);
$p4=($row['p4']);
Comment