Ascending and Descending whilst retreving data.

LeZeNkO

Heya, ive got this code for the index of my site.....now basiccly I want to get the news into descending order and im not 100% sure on how to do it....

Here's the code

<html>

<th height="127" scope="row" bordercolor="#666666" bgcolor="#000040" align="left"><font size="-1">
<? require_once('frame.css'); ?>
<div align="center">
<?php
$link = mysql_connect("localhost", "root", "");
mysql_select_db("lez", $link);
$qry = mysql_query("SELECT * FROM site", $link);

<?php

if (mysql_num_rows($qry) > 2) {
for ($i = 2; $i<mysql_num_fields($qry); $i++) {

}

?><?php

if (mysql_num_rows($qry) > 2) {
for ($j = 2; $j<mysql_num_rows($qry); $j++) {

?>

<?php

    for ($k = 0; $k<mysql_num_fields($qry); $k++) {
        echo "" . mysql_result($qry,$j, $k) . "<div align=center><br><br>";
    }

    ?><?php

}

}

?> </div> </html>

Any ides? please rply

thanks, lez.

leatherback

Hi,

at the end of the select statement, just add ' order by' with the colum name and the desc or asc (descendingvss ascending):

$qry = mysql_query("SELECT * FROM site order by date desc", $link);