000

<?php
$host="localhost"; // Host name
$username="buyersch_post"; // Mysql username
$password="FDDdma222"; // Mysql password
$db_name="buyersch_question"; // Database name
$tbl_name="forum_question2"; // 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");

$page = $_GET['page'];

$sql2="SELECT id, datetime FROM forum_question2 WHERE 1 ORDER BY datetime DESC LIMIT 5, 1";
$date = mysql_query($sql2);
$rowholder=mysql_fetch_array($date);
$dates = $rowholder['datetime'];
$ids = $rowholder['id'];
$sql3="DELETE FROM forum_question2 WHERE datetime < '$dates'";
$derp=mysql_query($sql3);
$sql4="DELETE FROM forum_answer2 WHERE question_id='$ids'";
$derp=mysql_query($sql4);

$sql="SELECT * FROM $tbl_name ORDER BY datetime DESC LIMIT 0, 5";
// OREDER BY id DESC is order result by descending
$result=mysql_query($sql);

print <<<_HTML
<title>Hookupchan.org Forum</title>
<body bgcolor=000000>
<p align=center><img src="images/banner.png" /></p>
<br/>
<br/>
<br/>
<table width="400" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<form id="form1" name="form1" method="post" action="add_topic2.php" enctype="multipart/form-data">
<td>
<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td colspan="3" bgcolor="#E6E6E6"><strong>Create New Topic</strong> </td>
</tr>
<tr>
<td width="14%"><strong>Topic</strong></td>
<td width="2%">:</td>
<td width="84%"><input name="topic" type="text" id="topic" size="50" /></td>
</tr>
<tr>
<td valign="top"><strong>Detail</strong></td>
<td valign="top">:</td>
<td><textarea name="detail" cols="50" rows="3" id="detail"></textarea></td>
</tr>
<tr>
<td><strong>Name</strong></td>
<td>:</td>
<td><input name="name" type="text" id="name" size="50" /></td>
</tr>
<tr>
<td><strong>Email</strong></td>
<td>:</td>
<td><input name="email" type="text" id="email" size="50" /></td>
</tr>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<tr>
<td><input name="data" type="file" id="data" /> </td>
<tr/>
<tr>
<td><input type="submit" name="Submit" value="Submit" /> </td>
</tr>
</table>
</td>
</form>
</tr>
</table>
<br/>
<br/>
_HTML;

?>
<table width="90%" border="0" align="center" cellpadding="3" cellspacing="0" bgcolor="#CCCCCC">
<tr>
<td width="6%" align="center" bgcolor="#E6E6E6"><strong>#</strong></td>
<td width="15%" align="center" bgcolor="#E6E6E6"><strong>Topic</strong></td>
<td width="53%" align="center" bgcolor="#E6E6E6"><strong>Detail</strong></td>
<td width="13%" align="center" bgcolor="#E6E6E6"><strong>Replies</strong></td>
<td width="13%" align="center" bgcolor="#E6E6E6"><strong>Date/Time</strong></td>
</tr>

<?php
while($rows=mysql_fetch_array($result)){ // Start looping table row
?>
<tr>
<td bgcolor="#7FFFD4"><? echo $rows['id']; ?></td>
<td bgcolor="#7FFFD4">

<a href="view_topic2.php?id=<? echo $rows['id']; ?>">REPLY</a><BR>
<a href="view_topic2.php?id=<? echo $rows['id']; ?>"><img src="show.php?id=<? echo $rows['id']; ?>" height=200 width=200 /></a>
<br/>
<a href="view_topic2.php?id=<? echo $rows['id']; ?>"><? echo $rows['topic']; ?></a><BR></td>
<td align="center" bgcolor="#7FFFD4"><? echo $rows['detail']; ?></td>
<td align="center" bgcolor="#7FFFD4"><? echo $rows['reply']; ?></td>
<td align="center" bgcolor="#7FFFD4"><? echo $rows['datetime']; ?></td>
</tr>

<?php

$id = $rows['id'];
$sql2 = "select * from (select * from forum_answer2 where question_id='$id' order by a_datetime desc limit 0, 2) as tbl order by tbl.a_datetime asc";
$data2=mysql_query($sql2);

while($rows2=mysql_fetch_array($data2))
{
?>

<?php
if($rows2['a_data'])
{
?>
<a href=ashow.php?id=<? echo $id; ?>&ad=<? echo $rows2['a_id']; ?>><img src=ashow.php?id=<? echo $id; ?>&ad=<? echo $rows2['a_id']; ?> height=200 width=200 /></a>
<?php
}
?>
</td>
<td align="center" bgcolor="#FFFFFF"><? echo $rows2['a_answer']; ?></td>
<td align="center" bgcolor="#FFFFFF"></td>
<td align="center" bgcolor="#FFFFFF"><? echo $rows2['a_datetime']; ?></td>
</tr>

<?php
}
unset($rows2);
?>

<?php
// Exit looping and close connection

}
mysql_close();
?>

</table>