Menu
Community /Pin to ProfileBookmark
——————————————————————–
@NogDogApr 08.2012 — #You can help us to help you by (a) wrapping your PHP code in [noparse]
That being said, the first problem I see is no semi-colon at the end of line #3.
Syntax error
<?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 WHERE showing=’1′ ORDER BY id ASC”;
$query = mysqli_query($myConnection, $sqlCommand) or die (mysqli_error($myConnection));
$menuDisplay = ”;
while ($row = mysqli_fetch_array($query)) {
$pid = $row[“id”];
$linklabel = $row[“linklabel”];
$menuDisplay .= ‘<a href=”index.php?pid=’ . $pid . ‘”>’ . $linklabel . ‘</a><br />’;
}
mysqli_free_result($query);
//mysqli_close($myConnection);
?>
——————————————————————–
this give me an error saying
syntax error, unexpected ‘$sqlCommand’
Sign in
to post a comment2 Comments(s) ↴
0
@NogDogApr 08.2012 — #You can help us to help you by (a) wrapping your PHP code in [noparse][code=php]...[/code][/noparse] tags, and (b) copy-and-pasting the exact error message text (including file and line number info it gives).That being said, the first problem I see is no semi-colon at the end of line #3.