view_topic.php

<?
session_start();
include("functions.php");
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<link href="style.css" rel="stylesheet" type="text/css">
<?
$userid = $_SESSION['userid'];
if(!is_numeric($userid)) { die('Af sikkerhedsmæssige årsager er siden stoppet i at loade. Kontakt webmaster hvis fejlen fortsætte'); exit(); }
?>
<?php
$host="localhost"; // Host name
$username="users_camilla"; // Mysql username
$password=""; // Mysql password -ER UDFYLDT
$db_name="users_camilla"; // Database name
$tbl_name="forum_question"; // Table name

// Connect to server and select databse.
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="100%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#E0EEEE">
<tr>
<td><table width="100%" border="0" cellpadding="3" cellspacing="1" bordercolor="1" bgcolor="#E6F4F8">
<p align="left">
<tr>
<td bgcolor='#C3E4F2'><strong>Oprettet af:</strong> <? echo $rows['name']; ?></td>
<td bgcolor="#C3E4F2"> <b><? echo $rows['topic']; ?></b></td></p>
<td bgcolor="#C3E4F2"><strong>Dato: </strong><? echo $rows['datetime']; ?></td>
</tr>
</table></td>
</tr>
</table>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#E0EEEE">
<tr>
<td><table width="100%" border="0" cellpadding="3" cellspacing="1" bordercolor="1" bgcolor="#E6F4F8">
<tr>
<td bgcolor="#E6F4F8"><? echo $rows['detail']; ?></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="100%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#C3E4F2">
<tr>
<td><table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#E6F4F8">
<tr>
<td width="18%" bgcolor="#C3E4F2"><strong>Stutteri</strong> <? echo $rows['a_myusername']; ?>
<td width="496" valign="top" bgcolor="#C3E4F2">
<p align="right">
<td bgcolor="#8FC1D5"><strong>#</strong><? echo $rows['a_id']; ?></td>
</tr>
<tr>
<td width="100%" bgcolor="#E6F4F8"><? echo $rows['a_answer']; ?></td>
</tr>
</table></td>
</tr>
</table><br>
<?
}

$sql3="SELECT view FROM $tbl_name WHERE id='$id' ORDER BY '$id' DESC";
$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();
?>
<link href="style.css" rel="stylesheet" type="text/css">
<BR>
<table width="400" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#C3E4F2">
<tr>
<form name="form1" method="post" action="add_answer.php">
<td>
<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#E6F4F8">
<tr>
<td width="18%"><strong>Stutterinavn</strong></td>
<td width="3%">:</td>
<td width="79%"> <?php echo $_SESSION['myusername']; ?></td>
<td><input name="a_myusername" type="hidden" value="<?php echo $_SESSION['myusername']; ?>" id="a_myusername" size="50" /></td>
</tr>
<tr>
<td valign="top"><strong>Svar</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="<? echo $id; ?>"></td>
<td><input type="submit" name="Submit" value="Send"> <input type="reset" name="Submit2" value="Reset"></td>
</tr>
</table>
</td>
</form>
</tr>
</table>
<? include("footer.php"); ?>