Hello everyone,
I'm having trouble executing a insert select query in PHP
Here is the code:
$exec = self::init()->prepare("INSERT INTO owners (f_name, l_name, username,
password, email, company, str_address,
city, state,
zip, phone, website, desc, categories)
SELECT f_name, l_name, username,
password, email, company, street_address,
city, state, zip,
phone_number, website, description, categories FROM pending
WHERE pid <> '0'");
if ($exec->execute() !== false) {
return true;
} else {
throw new Exception("Error processing the query.");
}
Any help would be appreciated, as PDO is not returning an error or anything.
Thanks!
Jimmy
-----Original Message-----
From: php-db-digest-help@xxxxxxxxxxxxx
[mailto:php-db-digest-help@xxxxxxxxxxxxx]
Sent: Tuesday, October 19, 2010 6:24 PM
To: php-db@xxxxxxxxxxxxx
Subject: php-db Digest 19 Oct 2010 22:24:15 -0000 Issue 4629
php-db Digest 19 Oct 2010 22:24:15 -0000 Issue 4629
Topics (messages 47397 through 47397):
Database and Table creation
47397 by: Ethan Rosenberg
Administrivia:
To subscribe to the digest, e-mail:
php-db-digest-subscribe@xxxxxxxxxxxxx
To unsubscribe from the digest, e-mail:
php-db-digest-unsubscribe@xxxxxxxxxxxxx
To post to the list, e-mail:
php-db@xxxxxxxxxxxxx
----------------------------------------------------------------------
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
