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


------------------------------------------------------------ ----------


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

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

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