[SOLVED] Small easy to fix problem i think.. Im still noob sorry..

[mikelmao]

Hello... Well im still 13 and learning PHP.. And i need some help with a easy to fix problem.. Well i wana Order my News From Newest to lowest.. I number my news as id's I guess i have to ORDER BY but How?? Thanks ^^

[sasa]

order by id desc (on end of query string)

[mikelmao]

Could you give me a Example>?

[DarkWater]

SELECT * FROM news WHERE news_id=$id ORDER BY id DESC;

 

Something like that.  Obviously use your own query.

[mikelmao]

Wtf i dont get it ^^ what do u mean with id DESC ? i know what DESC is.. Im not that noob..

[trq]

You need to pick a field to order by. eg; ORDER BY <fldname>

 

The examples posted above are odering by a field named id, though its probably best to order by a date or timestamp type of field.

[mikelmao]

OOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO.. ill see if it works

[mikelmao]

Well it works but the newst post goes last..  How do i do get the newest post on top

[mikelmao]

does anybody know?

[mikelmao]

Please help me people at PHP Freaks

 

[mikelmao]

Is anyone availebel for helping?

 

[MadnessRed]

sort it ascending

 

SELECT * FROM news WHERE news_id=$id ORDER BY id ASC;

 

also in many forums multiposting like that is frowned upon

 

edit: that was just using logic, I have no idea if it actually works or not, if am a complete noob at sql, starting trying it yesterday

 

edit2: can you post your entire php code though as i think I am trying to do the same thing as you, or similar

[fenway]

Yes, indeed it is... you won't get any help that way.

[mikelmao]

include "connect.php";

$news = mysql_query("SELECT * FROM rs");

if(mysql_num_rows($news) > 0)

{

  while($n = mysql_fetch_array($news))

  {

  print "<dt><span class='newsdate'>" . $n['date'] . "</span>" . $n['titel'] . "</dt>";

  print "<dd>

<table width='100%'><tr>

<td style='text-align: justify; vertical-align: top;'>". nl2br($n['news']) ."</td>

<td style='padding-left: 1em; text-align: right; vertical-align: top;'>

</td></tr></table>";

  }

}

else

  {

  echo "ther is no news";

  }

  mysql_close($con);

?>

[mikelmao]

I forgot to post the first <? lol Sorry bbut its ther

[fenway]

How about the table structure?

[MadnessRed]

Try this

 

 

<?php

include "connect.php";

$news = mysql_query("SELECT * FROM rs ORDER BY id ASC");
if(mysql_num_rows($news) > 0)
{
  while($n = mysql_fetch_array($news))
  {
  print "<dt><span class='newsdate'>" . $n['date'] . "</span>" . $n['titel'] . "</dt>";
  print "<dd>
  <table width='100%'><tr>
  <td style='text-align: justify; vertical-align: top;'>". nl2br($n['news']) ."</td>
  <td style='padding-left: 1em; text-align: right; vertical-align: top;'>
  </td></tr></table>";
  }
}
else
  {
  echo "There is no news at the moment.";
  }
mysql_close($con);
?>

 

[mikelmao]

Try this

 

 

<?php

include "connect.php";

$news = mysql_query("SELECT * FROM rs ORDER BY id ASC");
if(mysql_num_rows($news) > 0)
{
  while($n = mysql_fetch_array($news))
  {
  print "<dt><span class='newsdate'>" . $n['date'] . "</span>" . $n['titel'] . "</dt>";
  print "<dd>
  <table width='100%'><tr>
  <td style='text-align: justify; vertical-align: top;'>". nl2br($n['news']) ."</td>
  <td style='padding-left: 1em; text-align: right; vertical-align: top;'>
  </td></tr></table>";
  }
}
else
  {
  echo "There is no news at the moment.";
  }
mysql_close($con);
?>

 

Tryed it but the newest post is still as last

[trq]

Change the query to order by descending then.

 

$news = mysql_query("SELECT * FROM rs ORDER BY id DESC");

 

It helps if you attempt to learn from peoples replies.

[MadnessRed]

similar problem

 

what would be the correct way of doing this?

 

$result = mysql_query('SELECT * FROM `madnessred_sites` ORDER BY '$sort' '$order' '); 

 

edit: answere

 

$result = mysql_query("SELECT * FROM `madnessred_sites` ORDER BY '$sort' '$order' "); 

 

Also I found out what wrong with the code we gave lmao, ASC isn't right for ascending.

[fenway]

Drop the single quotes...