I recently finished reading PHP 4 Bible. Now I am trying to make my first script in PHP. I am running into trouble with the script that displays the news form my MySQL database. I want the script to display the news posting from the database by ID, form the greatest ID(The newst post), to the least ID(The oldest post). I am not shure how to order the results from the query. Any help is appreciated. I will enclose the display code below.
//Get info from the database
$query = "SELECT * FROM Articles";
$result = mysql_query($query);
//Print out news
while(list($ID, $Title, $Date, $Content) = mysql_fetch_row($result))
{
ord($ID);
Print("<tr>\n");
Print("<td bgcolor='#6B635A' align='center'>\n");
Print("<b>$Title</b>\n");
Print("</td>\n");
Print("</tr>\n");
Print("<tr>\n");
Print("<td>\n");
Print("$Content\n");
Print("<br>\n");
//Print("<div align='right'>\n");
Print("Posted: $Date\n");
//Print("</div>\n");
Print("</td>\n");
Print("</tr>\n");
};
Please note that this is not the full script code.
