Re: [PHP-DB] PostgreSQL query many escape characters?

2009-05-02 Thread John DeSoi
On May 1, 2009, at 3:59 PM, Carol Walter wrote: It would be much easier to read and write like this: $query = 'INSERT INTO tblPeople(fName,mName,lName, ivlweb, cnsweb)' . VALUES ($new_f_name_new, $new_m_name_new, $new_l_name_new, $new_ivl_web_peop, $new_cns_web_peop);; First query:

Re: [PHP-DB] PostgreSQL query many escape characters?

2009-05-01 Thread danaketh
Hi, you should post the INSERT query too. I'd recommend you to print the query before running it. Just put echo $query; before/after pg_query(). You'll see what are you sending to the database. This may help you find the problem. Also using ` instead of in query may help you to make it

Re: [PHP-DB] PostgreSQL query many escape characters?

2009-05-01 Thread Carol Walter
Okay, Here are the queries I've written. I gave up on trying to make pg_query_params() work but this is what I have using pg_query(). I have been printing the query. In fact, I can take the query as constructed, paste it into psql and it runs just fine. I would be grateful for any