On 20/10/10 09:55, Jimmy Sole wrote:
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.
Doesn't look like it should - it looks like a valid query.
Check your database logs or even run the query inside a transaction (and
rollback) to see if it errors.
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
