Re: PostgreSQL query many escape characters?
| From: | John DeSoi | Date: | Sun, 03 May 2009 02:26:46 +0000 |
| Subject: | Re: PostgreSQL query many escape characters? | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-46166@lists.php.net to get a copy of this message | ||
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: INSERT INTO "tblPeople"("fName","mName","lName", ivlweb, cnsweb) VALUES ('Frank', 'D', 'Oz', 't', 't'); Second query: INSERT INTO "tblContactInformation"("contactItem","contactType") VALUES ('foz@indiana.edu', '0010') Can't execute 2nd query Actually, neither query executes.What is the exact error message you are seeing? John DeSoi, Ph.D.