Re: [PHP-DB] PDO PgSQL: _pdo_pgsql_notice

Samuel ROZE wrote: To use PostgreSQL's Notices with PDO, i'm modifying the source for trying to store into "errmsg" (which I can get with PDO::errorInfo) the notice. The "_pdo_pgsql_notice" function is called everytime that there's an notice. The notice message is in the "message" var. This wha

Re: [PHP-DB] Sorting MYSQL results Paging and column heads

Edward Brookhouse wrote: Hi All, I am working on a PHP page to display results from a MySQL db and I am having a problem getting my results to page properly. When the page loads, it looks fine, but hitting next/previous does not change the data? db_connect_ecelerity(DBUSER, DBUSERPW); $q

Re: [PHP-DB] PDO PgSQL: _pdo_pgsql_notice

To use PostgreSQL's Notices with PDO, i'm modifying the source for trying to store into "errmsg" (which I can get with PDO::errorInfo) the notice. The "_pdo_pgsql_notice" function is called everytime that there's an notice. The notice message is in the "message" var. This what i had tried: --

[PHP-DB] PDO PgSQL: _pdo_pgsql_notice

Hi ! I'm reading the source of PDO PostgreSQL driver and i see that there's an empty function, _pdo_pgsql_notice, which is very interesting ! I think that it is used when PostgreSQL throw Notices. But, nothing is done... I want to know if somebody know why the content of the function is commented

[PHP-DB] Sorting MYSQL results Paging and column heads

Hi All, I am working on a PHP page to display results from a MySQL db and I am having a problem getting my results to page properly. When the page loads, it looks fine, but hitting next/previous does not change the data? Any thoughts appreciated - Edward Ebrooathealthydirectionsdotcom http

Re: [PHP-DB] PDO and PostgreSQL - RAISE NOTICE

Thanks a lot ! I'm now understanding why PDO exists.. It is not for replace the actual PostgreSQL/MySQL/SQLite/Firebird/... PHP drivers but for help to developp with many DB with one code. Well... I can developp an extension to PDO PostgreSQL driver, is that correct ? It may help many users like m

Re: [PHP-DB] Need help in triggers

What are you really want to do ? This is an exemple: CREATE FUNCTION myfunction () RETURNS trigger AS $$ BEGIN NEW.update_date = 'now'::date; RETURN NEW; END; $$ LANGUAGE plpgsql; CREATE TRIGGER set_update_date AFTER INSERT ON matable FOR EACH ROW EXECUTE PROCEDURE myfunction();

Re: [PHP-DB] Need help in triggers

Yogendra Kaushik wrote: Hi all's i am working on an application in which we are using PostgreSql as an database, i need to write trigger for my application. Can any one help me how can i write it. i have try to write it, but did not get success. do you using PEAR? to help database?

Re: [PHP-DB] Need help in triggers

Read the manual: http://www.postgresql.org/docs/8.1/interactive/sql-createtrigger.html Best _Pavan On Monday 05 October 2009 14:36:47 Yogendra Kaushik wrote: > Hi all's >i am working on an application in which we are using PostgreSql as an > database, i need to write trigger for my applicati

[PHP-DB] Need help in triggers

Hi all's i am working on an application in which we are using PostgreSql as an database, i need to write trigger for my application. Can any one help me how can i write it. i have try to write it, but did not get success. -- Regard's Yogendra kaushik

Re: [PHP-DB] PDO and PostgreSQL - RAISE NOTICE

Samuel ROZE wrote: Hi, Thanks for your reply. In fact, my request returns a result which i get with the fetch method. But, it must returns other informations, which are not in the result... This informations are neturned before the result in console... So, i don't know how I can get that. PD