verano Posted November 22, 2010 Share Posted November 22, 2010 Parse error: syntax error, unexpected T_WHILE in /home/smileits/public_html/space/post.php on line 87 <? session_start(); // This forum was developed by Adam M. B. from aWeb Labs // Visit us at http://www.labs.aweb.com.au // for forum problems, bugs, or ideas email yougotmail@gmail.com // thanks for trying out or using this forum // aWebBB version 1.2 released under the GNU GPL // connect to database and pull up info include "config.php"; $user123=$_POST['Username']; $db = mysql_connect($db_host,$db_user,$db_pass); mysql_select_db ($db_name) or die ("Cannot connect to database"); //Get the data $query = "SELECT id, username, password FROM users WHERE username='$user123'"; $result = mysql_query($query); /* Here we fetch the result as an array */ while($r=mysql_fetch_array($result)) { /* This bit sets our data from each row as variables, to make it easier to display */ $id=$r["id"]; $_Username=$r["username"]; $_Password=$r["password"]; // If the form was submitted if ($_POST['Submitted'] == "True") { // If the username and password match up, then continue... if ($_POST['Username'] == $_Username && $_POST['Password'] == $_Password) { // Username and password matched, set them as logged in and set the // Username to a session variable. $_SESSION['Logged_In'] = "True"; $_SESSION['Username'] = $_Username; } } } mysql_close($db); // If they are NOT logged in then show the form to login... if ($_SESSION['Logged_In'] != "True") { echo "<META HTTP-EQUIV=\"refresh\" content=\"0; URL=login.php?page=" . $_SERVER['PHP_SELF'] . "\">"; } else { include("header.php"); include "config.php"; $db = mysql_connect($db_host,$db_user,$db_pass); mysql_select_db ($db_name) or die ("Cannot connect to database"); $query = "SELECT sig, avatar FROM users WHERE username = '$_SESSION[username]'"; $result = mysql_query($query); while($r=mysql_fetch_array($result)) { $sig=$r["sig"]; $avatar=$r["avatar"]; ?> <script type="text/javascript"> <!-- function insertext(text){ document.post.fpost.value+=" "+ text; document.post.fpost.focus(); } //--> </script> <style type='text/css'><!--.bordercontrol {padding: 0px; border-right: 1px solid silver; border-top: 1px solid #DDDDDD; border-left: 1px solid #DDDDDD; border-bottom: 1px solid #DDDDDD;}A.post:hover, A.post:active {background-color: #DDDDDD}A.post:hover .bordercontrol, A.post:active .bordercontrol {background-color: silver; padding: 0px; border:1px; border-thickness: 1px; border-color: grey; border-style: solid}--></style> <div class="side-headline"><b>New Forum Thread:</b></div><br> <div align="center"> <form name="post" method="post" action="post.php?a=post"> <input type="hidden" name="sig" value="<?=$sig;?>"> <input type="hidden" name="avatar" value="<?=$avatar;?>"> <div class="grey-box"> Thread Name: <input type="text" name="tname" size="30" max="10"></div> <div class="grey-box">Select a Category: <select name="category" id="category"> <?php if ($_GET['c'] != "") { $catthing = " WHERE category != '$_GET[c]'"; $cit=$_GET['c']; echo "<option value=\"$cit\" selected>$cit</option>"; } else { } //connection to database include "config.php"; $db = mysql_connect($db_host,$db_user,$db_pass); mysql_select_db ($db_name) or die ("Cannot connect to database"); $query = "SELECT category FROM fcat$catthing"; $result = mysql_query($sql) while($r=mysql_fetch_array($result)) { $cname=$r["category"]; echo "<option value=\"$cname\">$cname</option>"; } mysql_close($db); ?> </select> </div> <div class="grey-box"><a class="post" href="javascript:insertext('')"><img class="bordercontrol" alt="smile" src="smilies/smile.gif" border="0" vspace="1" width="18" height="18"></a><a class="post" href="javascript:insertext('')"><img class="bordercontrol" alt="wink" src="smilies/wink.gif" border="0" vspace="1" width="18" height="18"></a><a class="post" href="javascript:insertext(':-p')"><img class="bordercontrol" alt="tongue" src="smilies/tongue.gif" border="0" vspace="1" width="18" height="18"></a><a class="post" href="javascript:insertext('>')"><img class="bordercontrol" alt="angry" src="smilies/angry.gif" border="0" vspace="1" width="18" height="18"></a><a class="post" href="javascript:insertext('')"><img class="bordercontrol" alt="sad" src="smilies/sad.gif" border="0" vspace="1" width="18" height="18"></a><a class="post" href="javascript:insertext(':-D')"><img class="bordercontrol" alt="laughing" src="smilies/laughing.gif" border="0" vspace="1" width="18" height="18"></a><a class="post" href="javascript:insertext('<b> </b>')" title="Bold"><img class="bordercontrol" src="format_edit/ed_format_bold.gif" border="0" width="18" height="18" vspace="1"></a><a class="post" href="javascript:insertext('<i> </i>')" title="Italics"><img class="bordercontrol" src="format_edit/ed_format_italic.gif" border="0" width="18" height="18" vspace="1"></a><a class="post" href="javascript:insertext('<s> </s>')" title="Strikethrough"><img class="bordercontrol" src="format_edit/ed_format_strike.gif" border="0" width="18" height="18" vspace="1"></a><a class="post" href="javascript:insertext('<u> </u>')" title="Underline"><img class="bordercontrol" src="format_edit/ed_format_underline.gif" border="0" vspace="1" width="18" height="18"></a><a class="post" href="javascript:insertext('<a href=www.website.com> linked text </a>')" title="Insert Link"><img class="bordercontrol" src="format_edit/ed_link.gif" border="0" vspace="1" width="18" height="18"></a><a class="post" href="javascript:insertext('<br>')" title="New Line"><img class="bordercontrol" src="format_edit/ed_left_to_right.gif" border="0" vspace="1" width="18" height="18"></a><a class="post" href="#" onClick="document.post.reset()"><img class="bordercontrol" src="format_edit/ed_delete.gif" border="0" vspace="1" width="18" height="18" title="Erase all"></a> </div> <div class="grey-box"> Thread Text: <br> <textarea name="fpost" cols="45" rows="7"></textarea></div> <div class="grey-box"><div align="center"> <input type="submit" name="Submit" value="Post New Thread"> </form></div></div></div> <? } if ($_GET['a'] == "post") { $time1=date("H:i:s"); $rand=rand(1000000, 9999999); include "config.php"; // As you can see we connected to the database with config $db = mysql_connect($db_host, $db_user, $db_pass); mysql_select_db ($db_name) or die ("Cannot connect to database"); $query = "INSERT INTO flist(tid, categories, tname, poster, date) VALUES('$rand','$_POST[category]','$_POST[tname]','$_SESSION[username]', now())"; mysql_query($query); echo "Thread "; mysql_close($db); include "config.php"; // As you can see we connected to the database with config $db = mysql_connect($db_host, $db_user, $db_pass); mysql_select_db ($db_name) or die ("Cannot connect to database"); $query = "INSERT INTO forum(tid, categories, tname, poster, fpost, sig, avatar, time, date) VALUES('$rand','$_POST[category]','$_POST[tname]','$_SESSION[username]','$_POST[fpost]','$_POST[sig]','$_POST[avatar]','$time1', now())"; mysql_query($query); echo "Submitted"; echo '<meta http-equiv="refresh" content="0;url=index.php">'; mysql_close($db); } else { } include("footer.php"); // If they want to logout then if ($_GET['mode'] == "logout") { // Start the session session_start(); // Put all the session variables into an array $_SESSION = array(); // and finally remove all the session variables session_destroy(); // Redirect to show results.. echo "<META HTTP-EQUIV=\"refresh\" content=\"1; URL=" . $_SERVER['PHP_SELF'] . "\">"; } } ?> error appears on line 87 which shows... while($r=mysql_fetch_array($result)) Quote Link to comment Share on other sites More sharing options...
Pikachu2000 Posted November 22, 2010 Share Posted November 22, 2010 The line terminating semicolon is missing on the previous line. Quote Link to comment Share on other sites More sharing options...
verano Posted November 22, 2010 Author Share Posted November 22, 2010 wow, im speechless, I learned something AND it fixed the problem. thank you X2 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.