RE: php-db Digest 19 Oct 2010 22:24:15 -0000 Issue 4629

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@lists.php.net [mailto:php-db-digest-help@lists.php.net] Sent: Tuesday, October 19, 2010 6:24 PM To: php-db@lists.php.net 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@lists.php.net To unsubscribe from the digest, e-mail: php-db-digest-unsubscribe@lists.php.net To post to the list, e-mail: php-db@lists.php.net ----------------------------------------------------------------------