Code: Select all
$output2 = '';
if (isset($_GET['secid']))
{
$host="localhost"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="Forum"; // Database name
$tbl_name2="forum_answer"; // Table name
$id=$_GET['secid'];
$sql2 = mysql_query("SELECT * FROM $tbl_name2 WHERE question_id='$id'");
$Count = mysql_num_rows($sql2);
if ($Count > 0)
{
while($row = mysql_fetch_array($sql2))
{
$a_id = $row["a_id"];
$a_name = $row["a_name"];
$a_email = $row["a_email"];
$a_answer = $row["a_answer"];
$a_datetime = $row["a_datetime"];
$output2 =
'
<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">' . $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">' . $a_name . '</td>
</tr>
<tr>
<td bgcolor="#F8F7F1"><strong>Email</strong></td>
<td bgcolor="#F8F7F1">:</td>
<td bgcolor="#F8F7F1">' . $a_email . '</td>
</tr>
<tr>
<td bgcolor="#F8F7F1"><strong>Answer</strong></td>
<td bgcolor="#F8F7F1">:</td>
<td bgcolor="#F8F7F1">' . $a_answer . '</td>
</tr>
<tr>
<td bgcolor="#F8F7F1"><strong>Date/Time</strong></td>
<td bgcolor="#F8F7F1">:</td>
<td bgcolor="#F8F7F1">' . $a_datetime . '</td>
</tr>
</table>
</td>
</tr>
</table><br>
';
}
}
else
{
echo"not greater then 0";
}
}
?>Youssef