My ignorance with databases will probably show here, but I haven't been able to solve this myself so I thought I'd post.
I'm working on converting a DB driven site using mysql specific commands to the PEAR DB method. One of the fields I have in my mysql database is a auto_increment primary key (will show below). On my php script I used to use mysql_insert_id to get the id (number) of my last insert so I can pass this to the next page (multiple tables). When I tried to use nextID(), it kept creating "_seq" tables in my DB depending on what I specified as the sequence(argument). This causes a problem because it returns 1, because there's nothing previously in _seq table. The real _seq or auto_increment is in my table chamber(described below). My question is: is there anyway to make nextID() use the id/auto_increment in the table I've setup previously and have id/data in rather than having it create _seq and rewrite all of my code?? Hope I'm clear. If not drop me an e-mail. Thanks Chris D. mysql> describe chamber; +--------------+----------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+----------------------+------+-----+---------+----------------+ | id | smallint(5) unsigned | | PRI | NULL | auto_increment | | company | varchar(255) | YES | | NULL | | | contact_name | varchar(100) | YES | | NULL | | | address | varchar(100) | YES | | NULL | | | city | varchar(75) | YES | | NULL | | | state | varchar(50) | YES | | NULL | | | phone | varchar(100) | YES | | NULL | | | fax | varchar(100) | YES | | NULL | | | category | varchar(100) | YES | | NULL | | | email | varchar(100) | YES | | NULL | | | company_url | varchar(255) | YES | | NULL | | | ad_url | varchar(255) | YES | | NULL | | +--------------+----------------------+------+-----+---------+----------------+ 12 rows in set (0.00 sec) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]