devilj Posted July 27, 2004 Posted July 27, 2004 Does anyone know where the Product_ID is auto assigned in the database?
241 Posted July 27, 2004 Posted July 27, 2004 products table via auto_increment No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes.
devilj Posted July 27, 2004 Author Posted July 27, 2004 Steve, Thanks I checked this in phpMyAdmin. However, I noticed that Products_Description also creates a field called "products_id" using auto increment through I would suspect that these auto increments would be in-sync.
241 Posted July 27, 2004 Posted July 27, 2004 yes in the context of a query p.products_id is products table however pd._products_id is products_description table No longer giving free advice. Please place deposit in meter slot provided. Individual: [=] SME: [==] Corporation: [===] If deposit does not fit one of the slots provided then you are asking too much! Is your Osc dated try Phoenix raising oscommerce from the ashes.
Maj Posted August 31, 2004 Posted August 31, 2004 I think having auto-increment on both these tables is a little dangerous, the tables could get out of sync. I have a situation in one database where products table and products_description table are out of sync? What could cause it?
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.