anh_shjn
06-06-2010, 02:35
<?php
$sql1 = "SELECT * FROM categories";
$result1 = mysql_query($sql1) or die(mysql_error());
while($row1 = mysql_fetch_array($result1)){
echo"<div id='middlepreview'><div id='middlepreviewheader'>".$row1['category_name']."</div>";
$sql="SELECT * FROM comments,users,news WHERE comments.user_id = users.user_id AND comments.news_id = news.news_id AND comments.comment_id ='". $row1['comment_id']."' ORDER BY comments.comment_date DESC ";
$result = mysql_query($sql) or die( mysql_error());
while($row = mysql_fetch_array($result)){
?>
<form action="xuly/xlcomment.php?comment_id=<?php echo $row['comment_id']; ?>&do=delete" method="post">
<?php
echo"
<div id='middlecommentid'>
<div id='middlecommentdate'>".$row['user_name']."...........".date(' \N\g\à\y\: j/n/Y....... \L\ú\c h:i A',strtotime($row['comment_date']))."' .................................................. ..............................................</div>
<div id='middlecommentpicture'><img src='".$row['user_avatar']."' width='80' height='80' /></div>
<div id='middlecommentcontent'>".$row['comment_content']."
<div style='width:50px; float:right'><input type='submit' value='Xóa'/></div>
</div>
</div>";
echo"___________________";
?>
</form>
<hr/>
<?php
}
echo"</div>";
}
?>
EM ko hiu mih sai o cho nao. Sau khi chay no chi hien ra dung cai ket qua cua vong lap thu 1 con vong lap thu 2 thi ko hien ra j ca. Ai giup em voi em dang can gap.
$sql1 = "SELECT * FROM categories";
$result1 = mysql_query($sql1) or die(mysql_error());
while($row1 = mysql_fetch_array($result1)){
echo"<div id='middlepreview'><div id='middlepreviewheader'>".$row1['category_name']."</div>";
$sql="SELECT * FROM comments,users,news WHERE comments.user_id = users.user_id AND comments.news_id = news.news_id AND comments.comment_id ='". $row1['comment_id']."' ORDER BY comments.comment_date DESC ";
$result = mysql_query($sql) or die( mysql_error());
while($row = mysql_fetch_array($result)){
?>
<form action="xuly/xlcomment.php?comment_id=<?php echo $row['comment_id']; ?>&do=delete" method="post">
<?php
echo"
<div id='middlecommentid'>
<div id='middlecommentdate'>".$row['user_name']."...........".date(' \N\g\à\y\: j/n/Y....... \L\ú\c h:i A',strtotime($row['comment_date']))."' .................................................. ..............................................</div>
<div id='middlecommentpicture'><img src='".$row['user_avatar']."' width='80' height='80' /></div>
<div id='middlecommentcontent'>".$row['comment_content']."
<div style='width:50px; float:right'><input type='submit' value='Xóa'/></div>
</div>
</div>";
echo"___________________";
?>
</form>
<hr/>
<?php
}
echo"</div>";
}
?>
EM ko hiu mih sai o cho nao. Sau khi chay no chi hien ra dung cai ket qua cua vong lap thu 1 con vong lap thu 2 thi ko hien ra j ca. Ai giup em voi em dang can gap.