Search results show Edit/Delete in reversed order to the rows

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Search table phrases, on field phrase choose "LIKE %...%" and search for 
"%rome%"
2.
3.

What is the expected output?
Clicking on Edit/Delete for the first row to Edit/Delete the first row

What do you see instead?
Clicking on Edit/Delete on the first row Edits/Deletes the last row (reversed 
order)

What version of the product are you using? On what operating system? Which
Database Extension (PDO/SQLiteDatabase/SQLiteDatabase3 - see Database
structure-tab in phpLiteAdmin)?

Linux
SQLite version: 3.8.7.4
SQLite extension [?]: PDO
PHP version: 5.6.4

Please provide any additional information below.

Original issue reported on code.google.com by erict...@gmail.com on 18 Jan 2015 at 4:14

Attachments:

• rome.sqlite

[GoogleCodeExporter]

What version are you using? 1.9.5 or a development version of 1.9.6?

I cannot reproduce this with 1.9.5. Neither with the current development 
version of 1.9.6 just committed. But there were bugs in the previous 
development version with the search function, though I am not sure your exact 
problem.

Original comment by crazy4ch...@gmail.com on 19 Jan 2015 at 1:53

[GoogleCodeExporter]

I am using version 1.9.5

Using the file attached: rome.sqlite

1. Click on [Table] phrases
2. Click Search
3. On the field/column for phrase, select the "LIKE %...%" Operator
4. In the textbox for field/column phrase, type "%rome%"
5. Click the Search button
Search results produce three records, id 12,13,57
6. Click Edit for the first record, id 12 "rome wasn't built in a day"

Results:
The edit record page for id 57 "play the fiddle while rome burns"
, which was the last record of the search results

Expected results:
The edit record page for id 12 "rome wasn't built in a day"

If it's still not quite clear then I'll wait for you to post a link for the 
latest version and test for this bug and report back.

Original comment by erict...@gmail.com on 20 Jan 2015 at 8:16