Help please. Coding error.

CombatWombat

Hey, I have a coding error. Anyone help me? Here is the error:

Parse error: syntax error, unexpected T_VARIABLE in /home/projecth/public_html/index.php on line 6

Here is the code:

<?php
session_start();
require_once"scripts/connect_to_mysql.php"

//Build Main Navigation menu and gather page data here
$sqlCommand ="SELECT id, linklabel FROM pages ORDER BY pageorder ASC";
$query ="mysqli_query($myConnection, $sqlCommand) or die (mysqli_error());

$menuDisplay = ";
while ($row = mysqli_fetch_array($query)){
	$pid = $row["id"];
	$linklabel = $row["linklabel"];

$menuDisplay = '<a href="index.php?pid=' . $pid . '">Home</a><br />'
}
mysqli_free_result($query);
//mysqli_close($myConnection).

?>

<!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=utf-8" />
<title>Test</title>
<style type="text/css">
<!--
body,td,th {
	color: #FFF;
}
body {
	background-image: url(../root_directory/style/stripBG.jpg);
	background-repeat: repeat;
	color:#FFF
}
a:link {
	color: #D3B12C;
	text-decoration: none;
}
a:visited {
	text-decoration: none;
	color: #D6D6D6;
}
a:hover {
	text-decoration: underline;
	color: #FFF;
}
a:active {
	text-decoration: none;
	color: #FFF;
}
-->
</style></head>

<body>
<table width="888" border="0" align="center" cellpadding="6" style="border #6B450C">
  <tr>
    <td width="200" height="58"><img src="../root_directory/style/logo.png" width="200" height="150" alt="Logo" /></td>
    <td width="584" bgcolor="#150D00">$CustomModule</td>
  </tr>
</table>
<table width="888" border="0" align="center" cellpadding="6" style="border #6B450C">
  <tr>
    <td width="22%" valign ="top" bgcolor="#150D00"><?php echo $menuDisplay, ?><br />

<td width="586" bgcolor="#150D00">$Body<br />

<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br /></td>
  </tr>
</table>
<table width="888" border="0" align="center" cellpadding="6" style="border #6B450C">
  <tr>
    <td bgcolor="#150D00">$Footer</td>
  </tr>
</table>
<p>&nbsp;</p>
</body>
</html>

Neville1985

your mysql_query has a " before it, thus making it a string, and the string closes on the $menuDisplay var. so Remove the " from the start of $query var and close the $menuDisplay.

$sqlCommand = "SELECT id, linklabel FROM pages ORDER BY pageorder ASC";
$query = mysqli_query($myConnection, $sqlCommand) or die (mysqli_error());

$menuDisplay = "";

Try that, I'm not sure if there are any other errors, that's just what I noticed at quick glance.

EDIT:
Also get your hands on a PHP IDE, it will colorcode everything so you can see these kinds of errors. Google it, there are plenty of free ones out there.

CombatWombat

Nope, didn't work.

I am trying it on this website. It is just giving me the same error. Even AFTER I fixed it.

Any help is appreciated.

Here is the edited code.

<?php
session_start();
require_once"scripts/connect_to_mysql.php"

//Build Main Navigation menu and gather page data here
$sqlCommand = "SELECT id, linklabel FROM pages ORDER BY pageorder ASC";
$query = mysqli_query($myConnection, $sqlCommand) or die (mysqli_error());

$menuDisplay = '"";
while ($row = mysqli_fetch_array($query)){
	$pid = $row["id"];
	$linklabel = $row["linklabel"];

$menuDisplay = '<a href="index.php?pid=' . $pid . '">Home</a><br />'
}
mysqli_free_result($query);
//mysqli_close($myConnection).

?>

<!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=utf-8" />
<title>Test</title>
<style type="text/css">
<!--
body,td,th {
	color: #FFF;
}
body {
	background-image: url(../root_directory/style/stripBG.jpg);
	background-repeat: repeat;
	color:#FFF
}
a:link {
	color: #D3B12C;
	text-decoration: none;
}
a:visited {
	text-decoration: none;
	color: #D6D6D6;
}
a:hover {
	text-decoration: underline;
	color: #FFF;
}
a:active {
	text-decoration: none;
	color: #FFF;
}
-->
</style></head>

<body>
<table width="888" border="0" align="center" cellpadding="6" style="border #6B450C">
  <tr>
    <td width="200" height="58"><img src="style/logo.png" width="200" height="150" alt="Logo" /></td>
    <td width="584" bgcolor="#150D00">$CustomModule</td>
  </tr>
</table>
<table width="888" border="0" align="center" cellpadding="6" style="border #6B450C">
  <tr>
    <td width="22%" valign ="top" bgcolor="#150D00"><?php echo $menuDisplay, ?><br />

<td width="586" bgcolor="#150D00">$Body<br />

<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br /></td>
  </tr>
</table>
<table width="888" border="0" align="center" cellpadding="6" style="border #6B450C">
  <tr>
    <td bgcolor="#150D00">$Footer</td>
  </tr>
</table>
<p>&nbsp;</p>
</body>
</html>

CombatWombat

Im sorry, forgot to put the link in there, I mean this website.
Sorry.

rincewind456

Count how many ' (single quotes) you have!

You will then find the cause of your problems.

Also if you use an editor with syntax highlighting these sorts of errors are much easier to spot.

dagon

in the above posted code i see 2 missing semi colons and one missing single quote.

CombatWombat

Could you please tell me where the errors are please.

rincewind456

Line 3

require_once"scripts/connect_to_mysql.php"

missing semicolon.
Line 9

$menuDisplay = '"";

has a stray ' (single quote)
Line 14

$menuDisplay = '<a href="index.php?pid=' . $pid . '">Home</a><br />'

missing semicolon.
Line 64

    <td width="22&#37;" valign ="top" bgcolor="#150D00"><?php echo $menuDisplay, ?><br />

has a stray , comma.

CombatWombat

There is something wrong with line 6, and I am SUCH a newb to php. So, like someone like tell me how, or edit the code for me? I would appreciate it ALOT! Thanks.

rincewind456

CombatWombat;10933475 wrote:
There is something wrong with line 6, and I am SUCH a newb to php. So, like someone like tell me how, or edit the code for me? I would appreciate it ALOT! Thanks.

Why do you say that? Does your page show an error? If so show us the error.