id auto_increment on multiple tables
Posted 16 October 2006 - 11:51 PM
If someone places a transfer order it assigns the order ID: 00001 in the table 'transfers' and then another customer comes along and places a duplication order it will assign the duplication order ID: 00002 rather than 00001 becuase its the first in the table 'duplication'. This is for order processing and shipping sanity.
Posted 17 October 2006 - 01:47 PM
Business Website: http://www.infotechnologist.biz
Personal Website: http://www.joyelpuryear.com
Blog Site: http://www.realmofwriting.com
Services: Web development, application development, mobile development, and custom development. All services listed on my website.
Posted 18 October 2006 - 12:13 AM
p.s. it would be nice if somehow i could add an identifier in the Order Number like WT0003 for a "Web: Transfer" or WD0004 for "Web: Duplication".
Can i generate the number from MySQL auto_increment or would i have to write a script that checks the last four digits of the last order in the orders table and adds one?
Posted 19 October 2006 - 04:06 PM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users