ASC by datetime issue

[wanted420]

Here is my problem now. This is how i am out putting the data and i can not see a way to DES or ASC but the timeset.

$num=mysql_num_rows($post2);

$i=0;
 while ($i<$num)
 {
$username="SELECT username FROM post WHERE id='$id'";
$username2=mysql_query($username);
$username3=mysql_fetch_array($username2);
$username4=$username3['username'];
$topic="SELECT topic FROM post WHERE id='$id'";
$topic2=mysql_query($topic);
$topic3=mysql_fetch_array($topic2);
$time="SELECT timeset FROM post WHERE id='$id'";
$set=mysql_query($time);
$ts=mysql_fetch_array($set);
$timeset=$ts['timeset'];
$topic4=$topic3['topic'];
$s=$username4;
 echo "<tr>";
 echo "<td>"; 
 echo $username4 . "<br>Posted: " . $timeset;
 echo "</td>";
 echo "<td> <a href='showthread.php?".$s."=&threadid=".$id."'>".$topic4."</a>";
 echo "</td>";
 echo "</tr>";
 $i=$i+1;
 $id=$id+1;
 }

[tekky]

You are doing this way too hard.... all this can be done (including your sorting...) by this..

$num=mysql_num_rows($post2);

$i=0;
while ($i<$num)
{
    $sql ="SELECT username, topic, timeset FROM post WHERE id='$id' ORDER BY timeset DESC";
    $res=mysql_query($sql);
    while( $row = mysql_fetch_array($res))
    {
        echo '<tr><td>'; 
        echo $row['username'] .'<br>Posted: ' . $row['timeset'];
        echo "</td><td> <a href='showthread.php?".$row['username'].'=&threadid='.$id."'>".$row['topic'].'</a></td></tr>';
    }
$i++;
$id++;
}

[wanted420]

I actually had just finished doing it like you said with it working now and i just now saw your reply 😃 that makes me happy! but i still have one issue 🙁 lol it doesnt seem to be changing the order that it outputs the info. i tried both DESC and ASC. i know its putting the datetime into the data base like this:

2004-04-10 04:41:38

i am wondering if it is just tryin to order by 2004-04-10 and not the time. got any ideas?

here is my new code:

$i=0;
while ($i<$num)
{
$get="SELECT username,topic,timeset FROM post WHERE id='$id' ORDER BY timeset ASC";
$get2=mysql_query($get);
while ($username=mysql_fetch_array($get2))
{
 echo "<tr><td>"; 
 echo $username['username'] . "<br>Posted: " . $username['timeset'];
 echo "</td><td> <a href='showthread.php?" . $username['username'] . "=&threadid=" . $id . "'>" . $username['topic'] . "</a></td></tr>";
}
 $i++;
 $id++;
}

EDIT:
I think it has to do with the $id. It chooses the one post and there is only one timeset to DESC or ASC from. Then same thing happens on next post. Not sure how to fix it yet but I am thinking.

[tekky]

ewww, oke didnt know you were using a DATETIME column...

$get="SELECT id, username,topic,timeset FROM post ORDER BY UNIX_TIMESTAMP(timeset) ASC LIMIT $i, $num"; 
$get2=mysql_query($get); 
while ($username=mysql_fetch_array($get2)) 
{ 
 echo "<tr><td>";  

 echo $username['username'] . "<br>Posted: " . $username['timeset']; 
 echo "</td><td> <a href='showthread.php?" . $username['username'] . "=&threadid=" . $username['id'] . "'>" . $username['topic'] . "</a></td></tr>"; 
}

I would really suggest not using $username as your $row var... but thats up to you...

[wanted420]

Dont worry the whole username thing will be changed once i get it working like i want 😃 Ok so i think my code pretty much is like yours now:

$post = "SELECT username FROM post"; 
$post2 = mysql_query($post);
$num=mysql_num_rows($post2);
$i=0;
while ($i<$num)
{
$get="SELECT id,username,topic,timeset FROM post ORDER BY UNIX_TIMESTAMP(timeset) DESC LIMIT $i, $num";
$get2=mysql_query($get);
while ($username=mysql_fetch_array($get2))
{
 echo "<tr><td>"; 
 echo $username['username'] . "<br>Posted: " . $username['timeset'];
 echo "</td><td> <a href='showthread.php?" . $username['username'] . "=&threadid=" . $username['id'] . "'>" . $username['topic'] . "</a></td></tr>";
}
 $i++;
}

BUT i still have an issue. It repeats the out put over and over and over.

EDIT:
ok i think i found the pattern for the repeating.
list of topics, with repeat:

topic1
topic2
topic3
topic4
topic5
topic2
topic3
topic4
topic5
topic3
topic4
topic5
topic4
topic5
topic5

EDIT:
I got it to work...i took out the second while loop:

while ($username=mysql_fetch_array($get2))
//is now this
$username=mysql_fetch_array($get2);

[/COLOR]

[tekky]

should have been able to accomplish the same thing by deleting the WHILE $i loop and leaving it how i posted 2 posts ago... the LIMIT $i, $num would handle retrieving the propper rows

[wanted420]

OH i didnt even see that you had taken that while loop out. Does one work better then the other? or it doesnt matter? Also how can i go about getting AM and PM to add to the time? I am searchin php.net right now but no success.

[tekky]

if its a MYSQL DATETIME you could use DATE_FORMAT I believe, you can find it by searching the documentation at www.mysql.com

[wanted420]

OK i think i have everything working like i want it. i just need to know if there is a way to check to if a number is ODD or EVEN. If there is plz give example THX

[tekky]

Originally posted by wanted420
OK i think i have everything working like i want it. i just need to know if there is a way to check to if a number is ODD or EVEN. If there is plz give example THX

//% == modulus == remainder of X divided by Y so....
// 3 % 2 = 1 (odd #)
// 4 % 2 = 0 (even #)

if ($num % 2)
{
    //this is even
}
else
{
    //this is odd
}