correct file order in DnS gallery

Task - correct file sorting in gallery system. We have a wrong order here <[login to view URL]> Wrong: 1 10 11 12 13 14 2 3 ... 8 9.jpg. This is the order we want: 1 2 3 4 ... 9 10 11 [login to view URL] ... We need to fix a database query in function listAllRecordsInGroupOrdered or write a new function for this script : <[login to view URL]> ) something like: public function listAllRecordsInGroupOrdered($groupId, $order) { $sql = "SELECT * from upload WHERE group_id=" . $groupId . " ORDER BY " . $order; $result = mysql_query ( $sql ); if (! $result) { throw new Exception ( "database query failed: " . mysql_error () ); } $num = mysql_numrows ( $result ); $listRecords = array (); $i = 0; while ( $i < $num ) { $rid = mysql_result ( $result, $i, "upload_id" ); $remoteFile = mysql_result ( $result, $i, "remote_file" ); $originalSize = mysql_result ( $result, $i, "original_size" ); $record = new UploadRecord (); $record->setId ( $rid ); $record->setRemoteFile ( $remoteFile ); $record->setOriginalSize ( $originalSize ); array_push ( $listRecords, $record ); $i ++; } Joshua Scott photographer - [[login to view URL]][1]