database/news script help needed

[Anon]

hey, I have a database that stores the data for a news script (title, date, text, etc.) For example, i have one row with 3 columns. the columns are the title of the news update, the date it happened, and the actual textual update. Each row is a new update. My code right now is:

			for ($count=0; $count<=mysql_fetch_row($result); $count++) {

				$title = mysql_result($result,$count,"title");

				$time = mysql_result($result,$count,"date");

				$news = mysql_result($result,$count,"news");

				$name = mysql_result($result,$count,"name");

				$updates = mysql_result($result,$count,"updates");

then i use the variables to insert the data into html tables to fit the layout. However, using the FOR loop this way, it starts from the first row, and continues down. Thus, on my page, each new row (update) will be put under the one before it. However, in a news script it should go above it( the most recent update first). How would i alter my loop to do this?

[Anon]

This can be done one of three ways:

(1): If the MySQL query is ordering the results in some way (by date_added, say), add "DESC" to the query after the "ORDER BY date_added" clause.

(2): I assume that mysql_fetch_row here is a typo for mysql_num_rows, because otherwise the loop makes little sense. Also, the "<=" should be a "<" or you'll have trouble on the last iteration (since $count is starting at zero).

In that case, reverse the for loop by saying

for($count=mysql_num_rows($result)-1; $count>=0; $count--);

But best of all would be:

(3): Do step (1) and change the for loop to read:

$num=mysql_num_rows($result);
for($count=0; $count<$num; ++$count)
{ $my_array=mysql_fetch_array($result);
$title=$my_array['title'];
$name=$my_array['name'];
$updates=$my_array['updates'];
...
}