Parse error: syntax error, unexpected $end in E:\wamp\www\forums\view_topic.php on li

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • James Long
    New Member
    • Dec 2011
    • 1

    Parse error: syntax error, unexpected $end in E:\wamp\www\forums\view_topic.php on li

    I am getting the following error:
    Parse error: syntax error, unexpected $end in E:\wamp\www\for ums\view_topic. php on line 138
    And i am a newbie..
    I have been working on the code for ages and now it dosent work!!!

    HELP


    Code:
    <?php
    $host="localhost"; // Host name 
    $username="root"; // Mysql username 
    $password=""; // Mysql password 
    $db_name="forum"; // Database name 
    $tbl_name="forum_question"; // Table name
    
    // Connect to server and select database.
    mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
    mysql_select_db("$db_name")or die("cannot select DB");
    
    
    // get value of id that sent from address bar 
    $id=$_GET['id'];
    
    $sql="SELECT * FROM $tbl_name WHERE id='$id'";
    $result=mysql_query($sql);
    
    $rows=mysql_fetch_array($result);
    ?>
    <table width="400" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
    <tr>
    <td><table width="100%" border="0" cellpadding="3" cellspacing="1" bordercolor="1" bgcolor="#FFFFFF">
    <tr>
    <td bgcolor="#F8F7F1"><strong><?php echo $rows['topic']; ?></strong></td>
    </tr>
    
    <tr>
    <td bgcolor="#F8F7F1"><?php echo $rows['detail']; ?></td>
    </tr>
    
    <tr>
    <td bgcolor="#F8F7F1"><strong>By :</strong> <?php echo $rows['name']; ?> <strong>Email : </strong><?php echo $rows['email'];?></td>
    </tr>
    
    <tr>
    <td bgcolor="#F8F7F1"><strong>Date/time : </strong><?php echo $rows['datetime']; ?></td>
    </tr>
    </table></td>
    </tr>
    </table>
    <BR>
    <?php
    $tbl_name2="forum_answer"; // Switch to table "forum_answer"
    
    $sql2="SELECT * FROM $tbl_name2 WHERE question_id='$id'";
    $result2=mysql_query($sql2);
    
    while($rows=mysql_fetch_array($result2)){
    ?>
    <table width="400" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
    <tr>
    <td><table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
    <tr>
    <td bgcolor="#F8F7F1"><strong>ID</strong></td>
    <td bgcolor="#F8F7F1">:</td>
    <td bgcolor="#F8F7F1"><?php echo $rows['a_id']; ?></td>
    </tr>
    <tr>
    <td width="18%" bgcolor="#F8F7F1"><strong>Name</strong></td>
    <td width="5%" bgcolor="#F8F7F1">:</td>
    <td width="77%" bgcolor="#F8F7F1"><?php echo $rows['a_name']; ?></td>
    </tr>
    <tr>
    <td bgcolor="#F8F7F1"><strong>Email</strong></td>
    <td bgcolor="#F8F7F1">:</td>
    <td bgcolor="#F8F7F1"><?php echo $rows['a_email']; ?></td>
    </tr>
    <tr>
    <td bgcolor="#F8F7F1"><strong>Answer</strong></td>
    <td bgcolor="#F8F7F1">:</td>
    <td bgcolor="#F8F7F1"><?php echo $rows['a_answer']; ?></td>
    </tr>
    <tr>
    <td bgcolor="#F8F7F1"><strong>Date/Time</strong></td>
    <td bgcolor="#F8F7F1">:</td>
    <td bgcolor="#F8F7F1"><?php echo $rows['a_datetime']; ?></td>
    </tr>
    </table></td>
    </tr>
    </table><br>
    
    <?
    }
    
    $sql3="SELECT view FROM $tbl_name WHERE id='$id'";
    $result3=mysql_query($sql3);
    
    $rows=mysql_fetch_array($result3);
    $view=$rows['view'];
    
    // if have no counter value set counter = 1
    if(empty($view)){
    $view=1;
    $sql4="INSERT INTO $tbl_name(view) VALUES('$view') WHERE id='$id'";
    $result4=mysql_query($sql4);
    }
    
    
    // count more value
    $addview=$view+1;
    $sql5="update $tbl_name set view='$addview' WHERE id='$id'";
    $result5=mysql_query($sql5);
    
    mysql_close();
    ?>
    
    <BR>
    <table width="400" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
    <tr>
    <form name="form1" method="post" action="add_answer.php">
    <td>
    <table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
    <tr>
    <td width="18%"><strong>Name</strong></td>
    <td width="3%">:</td>
    <td width="79%"><input name="a_name" type="text" id="a_name" size="45"></td>
    </tr>
    <tr>
    <td><strong>Email</strong></td>
    <td>:</td>
    <td><input name="a_email" type="text" id="a_email" size="45"></td>
    </tr>
    <tr>
    <td valign="top"><strong>Answer</strong></td>
    <td valign="top">:</td>
    <td><textarea name="a_answer" cols="45" rows="3" id="a_answer"></textarea></td>
    </tr>
    <tr>
    <td>&nbsp;</td>
    <td><input name="id" type="hidden" value="<?php echo $id; ?>"></td>
    <td><input type="submit" name="Submit" value="Submit"> <input type="reset" name="Submit2" value="Reset"></td>
    </tr>
    </table>
    </td>
    </form>
    </tr>
    </table>
    The last line in 139
    Last edited by Dormilich; Dec 23 '11, 11:31 PM. Reason: please use [CODE] [/CODE] when posting code
  • Dormilich
    Recognized Expert Expert
    • Aug 2008
    • 8694

    #2
    that error usually comes up if there is a bracket mismatch (e.g. missing })

    Comment

    Working...