is there a way to change the order in which the db is queried and outputed.
i have a really basic news page but it displays the articles in reverse order can some one help me out with this?
mysql_connect("localhost","delta_delta","******") or die ("Cant connect to db");
mysql_select_db("delta_main") or die ("Cant select db");
$result = mysql_query('SELECT * FROM `news`) or exit(mysql_error());
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
printf ('
<table width="600" border="0" cellspacing="1" cellpadding="1">
<tr>
<td align="center" class="thCornerL"><b>%s</b></td>
</tr>
<tr>
<td valign="top" class="row1"><span class="genmed">%s</span></td>
</tr>
</table>
<br>
', $row[0], $row[1]);
}