Re: [PHP] trim string

2001-03-21 Thread Gary Huntress
Perform the trim as part of the query: "Select rtrim(app_name) , rtrim( status) from approval_list where doc_no='6'" "Wen Ni Leong" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I need help in this basic string function. > I query from the database by using

[PHP] phpinfo() doesn't list compiled --with

2001-03-20 Thread Gary Huntress
I compiled php --with-pgsql, but phpinfo() doesn't list that.is this a problem with php.ini? Thanks, Gary -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-m

Re: [PHP] mySQL - Swap data in a field between two rows

2001-03-17 Thread Gary Huntress
I don't mean to be argumentative, but why would you need to do this? A key field is usually intended to uniquely identify a row and nothing more, the actual value of the key (whether the id is 1 or 2) *should* be immaterial. I'm probably over simplifying this, but are you sure you really need