Help with accending and decending comment order.

[xiofire]

I have never had so many problems with a simple little PHP comment script in my life.
But, maybe I'm just having a bad week.
Heres the problem:



And the script:

<?php
}
$tbl_name2 = "CENSORED";

$sql2 = "SELECT * FROM $tbl_name2 WHERE CENSORED='$id'";
$result2 = mysql_query($sql2);

while($rows = mysql_fetch_array($result2)){
    ?>
    <div style="margin-top: 10px; margin-bottom: 10px; border: 1px solid #666; -moz-border-radius: 5px; -webkit-border-radius: 5px; padding: 5px;">
    <strong><a href="<?=$rows['a_web']?>"><?=$rows['a_name']?></a></strong>&nbsp;<small>said:</small>
    <p>
    <?=$rows['a_answer']?>
    </p>
    <small><span style="font-family: georgia; color: #666">Posted on <?=$rows['a_datetime']?></span></small>
        </div>
    <?php
}

$sql3 = "SELECT view FROM $tbl_name WHERE id='$id'";
$result3 = mysql_query($sql3);

$rows = mysql_fetch_array($result3);
$view = $rows['view'];

if(empty($view)){
    $view = 1;
    $sql4 = "INSERT INTO $tbl_name(view) VALUES('$view') WHERE id='$id'";
    $result4 = mysql_query($sql4);
}

$addview = $view+1;
$sql5 = "update $tbl_name set view='$addview' WHERE id='$id'";
$result5 = mysql_query($sql5);

mysql_close();
?>

Any help?

[forum_amnesiac]

Depends on how you are storing the variable "'a_datetime'".

If it is the unix date stamp then you can do a SORT on that field when you extract the records.

If it is not a numeric date stamp then you need to split the field and rebuild it into YYYYMMDDHHMM and then sort on that.

[Schmoopy]

Should be a simple ORDER BY statement in the query, add something like:

"SELECT * FROM $tbl_name2 WHERE CENSORED='$id' ORDER BY `date`, `time` ASC"; 

[xiofire]

You are very helpful, Schmoopy.
Thanks!

[xiofire]

So I changed it to order by datetime and ID, and it works!
These forums are great!

[Schmoopy]

Glad to hear it

Good luck with developing the rest of your site.