About updating PSQL Database

[tanveer91]

Hi all,

I have written a script to update specific records in a psql database.......my problem is that every time i update a record, the updated records is shown at the bottom of the list on the web broswer.

How can keep the list in its original order after i update records?.........your help is greatly appreciated.

 

[Bastien]

in the sql query that pulls the info out of the data base

use the ORDER BY clause to pick a certain order. can be 1 to more elements to order by.

ie
select * from myTable
order by date

hth
Bastien

There are many ways to skin this cat,
but it still tastes like chicken