sortere efter time
HejJeg er ved at udvikle et debatforum som er lavet i tråde som så skal blive sorteret efter time...
I nedenstående eksempel er der 3 overordnede indlæg: "1 testing... :D", "test igen" og "haha..." Den tråd hvor under der sidst er lavet et indlæg skal blive vist øverst :)
Jeg ved ikke helt om I er med på hvad jeg mener, men her er et link: http://clark.avansis.dk/temp/thread/
Her er min kode (mit javascript fungerer ikke helt perfekt endnu, da trådene ikke kan lukkes igen):
<script type="text/javascript">
var expand = new Array();
function thread_expand(thread)
{
expand[thread] = true;
var img = 'img'+thread;
var div = 'div'+thread;
var td = 'td'+thread;
if(expand[thread])
{
document.getElementById(img).src = 'gfx/debate_thread_open.gif';
document.getElementById(div).style.display = '';
document.getElementById(td).style.backgroundImage = "url('gfx/debate_thread_bg.gif')";
}
else
{
document.getElementById(img).src = 'gfx/debate_thread_close.gif';
document.getElementById(div).style.display = 'none';
document.getElementById(td).style.backgroundImage = '';
}
expand[thread] = !expand[thread];
}
</script>
<link rel="stylesheet" href="req/style.css" type="text/css">
<body bgcolor="#f9f9f9">
<?
function thread($reply_id, $table)
{
global $DB;
$i = 1;
$sql = "SELECT debate.id, debate.subject, debate.time, COUNT(debate2.reply_id) AS replies, user.name
FROM $DB.$table debate, $DB.user user
LEFT JOIN $DB.$table debate2 ON debate.id=debate2.reply_id
WHERE debate.user_id=user.id && debate.reply_id=$reply_id
GROUP BY debate.id
ORDER BY debate.time DESC";
$get = mysql_query($sql);
$num = mysql_num_rows($get);
while($row = mysql_fetch_array($get))
{
?>
<table>
<tr valign="top">
<?
if($num == $i) echo '<td><img src="gfx/debate_thread_end.gif">';
elseif($row['replies']) echo '<td style="background: url(\'gfx/debate_thread_bg.gif\') margin-bottom: 10px;"><img style="cursor: hand" id="img'.$row['id'].'" onclick="thread_expand('.$row['id'].');" src="gfx/debate_thread_close.gif">';
else echo '<td style="background: url(\'gfx/debate_thread_bg.gif\') margin-bottom: 10px;"><img src="gfx/debate_thread.gif">';
?>
</td>
<td>
<table>
<tr valign="top">
<td id="td<?=$row['id']?>"><img src="gfx/debate_msg.gif"></td>
<td height="30"><span class="small_marked"><?=$row['subject']?></span><br><span class="small"><?=$row['time']?> | <?=$row['name']?></span></td>
</tr>
</table>
</td>
</tr>
<tr>
<td style="background: url('gfx/debate_thread_bg.gif');"></td>
<td colspan="2">
<div id="div<?=$row['id']?>" style="display: none;">
<?
thread($row['id'], $table);
?>
</div>
</td>
</tr>
</table>
<?
$i++;
}
}
$table = 'debate_generelt';
$sql = "SELECT debate.id, debate.subject, debate.time, COUNT(debate2.reply_id) AS replies, user.name
FROM $DB.$table debate, $DB.user user
LEFT JOIN $DB.$table debate2 ON debate.id=debate2.reply_id
WHERE debate.user_id=user.id && debate.reply_id=0
GROUP BY debate.id";
$get = mysql_query($sql);
while($row = mysql_fetch_array($get))
{
?>
<table>
<tr valign="top">
<td style="background: url('gfx/debate_thread_bg.gif') margin-bottom: 10px;">
<?
if($row['replies']) echo '<img style="cursor: hand" id="img'.$row['id'].'" onclick="thread_expand('.$row['id'].');" src="gfx/debate_thread_close.gif">';
else echo '<img src="gfx/debate_thread.gif">';
?>
</td>
<td>
<table>
<tr valign="top">
<td id="td<?=$row['id']?>"><img src="gfx/debate_msg.gif"></td>
<td height="30"><span class="small_marked"><?=$row['subject']?></span><br><span class="small"><?=$row['time']?> | <?=$row['name']?></span></td>
</tr>
</table>
</td>
</tr>
<tr>
<td style="background: url('gfx/debate_thread_bg.gif');"></td>
<td colspan="2">
<div id="div<?=$row['id']?>" style="display: none;">
<?
thread($row['id'], $table);
?>
</div>
</td>
</tr>
</table>
<?
}
?>
</body>
