Perl question/ order by id desc

[Anon]

$sqlstatement .= " order by id desc";
This is the command that one would use when using PostgreSQL to have all the new entries. go on top. (just like this maeesage board)
I am working with a CGI script that does the opposite by sending all the new entries to the bottom of the list.
I do realize that this is a php forum but I did try a cgi forum and know one seem to know.
By any chance would anyone here know what the command in Perl is?

Much thanks
Krenee

[[deleted]]

I guess you are looking for something like
SELECT *
FROM table
ORDER BY id ASC

[Anon]

Hello, Vincent,
Where would I add
SELECT *
FROM table
ORDER BY id ASC

This is how the code start:

LIST
#

Listing profiles with categories

###############################
sub list
{
my @table_template;
open (TEMP, "<${root}$tempz{'list_table'}");
if($flocking) {flock TEMP, 2;}
while(($thisrow = <TEMP>))
{ push(@table_template, $thisrow); }
if($flocking) {flock TEMP, 8;}
close TEMP;

open (TEMP, "<${root}$database");
 	if($flocking) {flock TEMP, 2;}
 		while(($thisrow = <TEMP>))
 		{ push(@list_lines, $thisrow);}
 	if($flocking) {flock TEMP, 8;}
close TEMP;

[[deleted]]

Sorry, I thought you were talking about creating an SQL statement...