RE: [PHP-DB] Incrementing Primary Key

2010-10-28 Thread Jimmy Sole
The () around null seem like that could be the issue, just try to put NULL for the value -Original Message- From: Ethan Rosenberg [mailto:eth...@earthlink.net] Sent: Thursday, October 28, 2010 2:02 PM To: Bastien Koert Cc: Max E.K; php-db-lists.php.net; rquadl...@googlemail.com Subject:

RE: [PHP-DB] Incrementing Primary Key

2010-10-28 Thread Jimmy Sole
Actually, after looking at it further, you have the records set to only have not null values yet you are passing a null value to it. -Original Message- From: Ethan Rosenberg [mailto:eth...@earthlink.net] Sent: Thursday, October 28, 2010 2:02 PM To: Bastien Koert Cc: Max E.K;

RE: [PHP-DB] Incrementing Primary Key

2010-10-27 Thread Jimmy Sole
I think having a table for each site would be sufficent -Original Message- From: Ethan Rosenberg [mailto:eth...@earthlink.net] Sent: Wednesday, October 27, 2010 9:11 AM To: php-db-lists.php.net Subject: [PHP-DB] Incrementing Primary Key Dear List - Thanks for all your excellent help.

RE: [PHP-DB] Incrementing Primary Key

2010-10-27 Thread Jimmy Sole
Just set the primary key to AUTO_INCREMENT on each field and you won't have to worry about it -Original Message- From: Ethan Rosenberg [mailto:eth...@earthlink.net] Sent: Wednesday, October 27, 2010 9:11 AM To: php-db-lists.php.net Subject: [PHP-DB] Incrementing Primary Key Dear List -

RE: [PHP-DB] Incrementing Primary Key

2010-10-27 Thread Jimmy Sole
In my opinion, having a database for each site would require a lot of unnecessary work, as you would have to connect to every database in order to handle the sites. Having one database with tables for all the sites would be more productive as you would not have to change the connection info for

[PHP-DB] RE: php-db Digest 19 Oct 2010 22:24:15 -0000 Issue 4629

2010-10-19 Thread Jimmy Sole
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,