[SOLVED] putting selected values in order

[twixter]

Hi,

 

I have a slight prob. I got this script where it displays the list of the last 5 topics by date. problem is, it does show the last 5 topics, but the newest is at the bottom of the list.

 

How can i make it show the last 5 entries, newest first?

 

Thank you!

 

 

Mae

 

 

 

 

<?

$row_count = mysql_num_rows(mysql_query("SELECT * FROM main  where topic='statement' ORDER BY date ASC")) - 5;

$result = mysql_query("
SELECT * 
FROM main where topic='statement' ORDER BY date ASC
LIMIT ".$row_count.", 5") or die("error!");

if ($result) {


while ($r = mysql_fetch_array($result)) {
$id = $r["id"];
$topic = $r["topic"];
$date = $r["date"];
$title = $r["title"];
$area = $r["area"];
$os = $r["os"];

echo " &#8226 <a href=\"view.php?id=$id&topic=$topic&date=$date&title=$title&os=$os\">$title</a> <br> "; 
}

} else {

echo "No data.";

}
?>

[maxudaskin]

Change ASC to DESC.

 

I am probably wrong, but it won't hurt to try.

[twixter]

heya maxudaskin, i tried that, changed one or both to "DESC" but it showed the very first 5 entries (the oldest ones).

 

Thanks for the suggestion. it didn't hurt, dont worry.

[rhodesa]

Go back to your original code, and get the records in reverse order...follow Example #1: http://us3.php.net/manual/en/function.mysql-data-seek.php

[awpti]

Change the ORDER BY to the table's auto_increment field.

 

ORDER BY id DESC will give you the newest 5, in order from newest to oldest.

[rhodesa]

ok...i interpreted that differently. twixter, do you want the oldest entries ordered newest to oldest or the most recent entries newest to oldest?

[twixter]

Hi awpti. I'll probably do that instead since it's the closest workaround. id is in auto_increment. thank you for your suggestion.

 

rhodesa, i'll need the newest 5 entries by date, newest one on top.

right now, what happens is like, 96, 97, 98, 99, 100 but i want it to be like 100, 99, 98, 97, 96.

 

i'll probably use ORDER BY id for the meantime.

 

Thanks too!

 

 

[twixter]

well, i tried using ORDER BY id and it still does the same thing.  ???

 

 

[rhodesa]

<?php
  $query = "SELECT * FROM `main` WHERE `topic` = 'statement' ORDER BY id DESC LIMIT 5";
  $result = mysql_query($query) or die("error!");

  if(mysql_num_rows($result){
    while ($r = mysql_fetch_array($result)) {
      $id = $r["id"];
      $topic = $r["topic"];
      $date = $r["date"];
      $title = $r["title"];
      $area = $r["area"];
      $os = $r["os"];

      echo " &#8226 <a href=\"view.php?id=$id&topic=$topic&date=$date&title=$title&os=$os\">$title</a> <br> "; 
    }
  } else {
    echo "No data.";
  }
?>

[twixter]

Hi Rhodesa!

 

I got this error:

 

Parse error: syntax error, unexpected '{' in /home/XXXX/public_html/statements/index.php on line 21

 

where line 21 is

  if(mysql_num_rows($result){ 

[ryeman98]

Hi Rhodesa!

 

I got this error:

 

Parse error: syntax error, unexpected '{' in /home/XXXX/public_html/statements/index.php on line 21

 

where line 21 is

  if(mysql_num_rows($result){ 

 

You're missing a closing bracket:

 if(mysql_num_rows($result)){

[twixter]

whoops! thanks ryman98!

 

Thanks rhodesa!