kljuuda PHP...

man ir skripts kas no datubaazes nolasa pievienotos rakstus...probleema taa ka vins jaunaakos rakstus visu laiku pievieno beigaas....kaa lai panaak lai jaunaakie raksti vienmeer buutu saakumaa

<?php
     $query = "SELECT id, title, author, post, DATE_FORMAT(date, '%M %d, %Y') as sd FROM news_posts";
     $result = @mysql_query($query);
     
     if ($result) {
     while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
     $url = 'comments.php?id='.$row['id'];
     echo '<div class="item">'.'<p><b>'.$row['title'].'</b><br />
     '.$row['sd'].'<br />
     Posted by : <b>'.$row['author'].'</b><br />
     '.$row['post'].'<br />
     <a href="javascript:openComments(\''.$url.'\')">Add new comment or view posted comments</a></p>'.'</div>';
     }
     } else {
     echo 'There are no news posts to display';
     }
     ?>

Komentāri:

#1 Mad182 @ 2008.10.22 22:17

Ar ORDER BY date vai id un DESC vai ASC, vari sakārtot kādā secībā gribi.

http://www.tizag.com/mysqlTutorial/mysqlorderby.php

#2 gaziks52 @ 2008.10.22 22:29

ok....viss straadaa...paldies!!!