Hi Nafiseh, I'm not fully sure I understand your question. However, I think you are asking how to display the data that is returned in a certain form (sort?). If so, read on.
Are you using the Database Interface (DBI) Module? If so, Answer to 1: Not entirely sure....Check a SQL tutorial site. It should work if you follow the example below. Just change the value of "$query" Answer to 2: .....Connect to database, specifying user name, password, etc..... $query = "SELECT * FROM table_name ORDER BY column_name"; ### ORDER BY returns the data generated by the query $sth = $dbh->prepare($query); $sth -> execute(); my @row; .....Disconnect from database....... Finally, I think you might have the wrong mailing list. There are mailing lists that deal specifically with database issues. Check out [EMAIL PROTECTED] for more help on DBI stuff. Also, see if you can find a mailing list for Postgres. I hope this helps. Simon ############################################## --- nafiseh saberi <[EMAIL PROTECTED]> wrote: > hi dear team... > how r u ? > > 1-how can I delete one column in table that build in postgres ?? > (there is not parameter in ALTER) > 2-how can I sort the column of table in form of that I want?? > > thx. > ______________________________ > Sincerely yours Nafiseh Saberi > > People will forget what you said ... > People will forget what you did... > But people will Never Forget > how you made them feel. > > < Any suggestion are welcome to me > > __________________________________ > ===== ######################################### Warmest Regards, Simon K. Chan - [EMAIL PROTECTED] "Great spirits have always encountered violent opposition from mediocre minds." -Albert Einstein __________________________________________________ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]