Hello,
I’m having some issues with a insert…select query, here is the code:
[php]$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.");
}[/php]
Any help would be appreciated, as PDO is not returning an error or anything.
Thanks!
Jimmy