Guest Posted May 19, 2004 Share Posted May 19, 2004 Can I change the Order Number ?! I hope the order number is started at 5 numbers e.g.: 00001...00002.....01568.....05565 How to do it?! Thanks~ Quote Link to comment Share on other sites More sharing options...
Guest Posted May 19, 2004 Share Posted May 19, 2004 the database contains the order numbers, in order table, u can also use the contribution random order generator Quote Link to comment Share on other sites More sharing options...
Guest Posted May 19, 2004 Share Posted May 19, 2004 the database contains the order numbers, in order table, u can also use the contribution random order generator But the random order generator will be generate the unknow number, can it generate in sequence ?! thx~ Quote Link to comment Share on other sites More sharing options...
Guest Posted May 19, 2004 Share Posted May 19, 2004 no, just change the order # to a a few numbers below what you want it to start with, then place a test order or two Quote Link to comment Share on other sites More sharing options...
Guest Posted May 19, 2004 Share Posted May 19, 2004 no, just change the order # to a a few numbers below what you want it to start with, then place a test order or two oh...ok~ let me try, thanks~ :lol: Quote Link to comment Share on other sites More sharing options...
Guest Posted May 19, 2004 Share Posted May 19, 2004 ///////////////// RAMDOMIZING SCRIPRT BY PATRIC VEVERKA \\\\\\\\\\\\\\\\\\ $t1 = date("mdy"); srand ((float) microtime() * 10000000); $input = array ("A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T", "U", "V", "W", "X", "Y", "Z"); $rand_keys = array_rand ($input, 2); $l1 = $input[$rand_keys[0]]; $l2 = $input[$rand_keys[1]]; $r1 = rand(0,9); $ordernum = $l1.$l2.$t1.$r1; ///////////////// End of Randomizing Script \\\\\\\\\\\\\\\\\\\ I see this script, where can I define the order numer that I like ?! that's all. This produces the random order number like KY1002025 It say the random order number like KY1002025, but I need to use standard order number, how can I do?! Thanks~ Quote Link to comment Share on other sites More sharing options...
Guest Posted May 19, 2004 Share Posted May 19, 2004 any other distribute can meet my requirement?! Quote Link to comment Share on other sites More sharing options...
nrlatsha Posted May 19, 2004 Share Posted May 19, 2004 no, just change the order # to a a few numbers below what you want it to start with, then place a test order or two oh...ok~ let me try, thanks~ :lol: Do that Quote 9 times out of 10 its a PEBCAK Error (Problem exists between chair and keyboard) Replace that and you're fine... Link to comment Share on other sites More sharing options...
Guest Posted May 19, 2004 Share Posted May 19, 2004 no, just change the order # to a a few numbers below what you want it to start with, then place a test order or two change which code ?! can you briefy describe ?!??! Thank You!! Quote Link to comment Share on other sites More sharing options...
Guest Posted May 19, 2004 Share Posted May 19, 2004 no, just change the order # to a a few numbers below what you want it to start with, then place a test order or two oh...ok~ let me try, thanks~ :lol: Do that But I don't know how to do it? Quote Link to comment Share on other sites More sharing options...
Guest Posted May 19, 2004 Share Posted May 19, 2004 OK~ I got it :P I edit the data in " Order " Table of Mysql database. Thanks~ Quote Link to comment Share on other sites More sharing options...
Guest Posted July 28, 2007 Share Posted July 28, 2007 OK~ I got it :P I edit the data in " Order " Table of Mysql database. Thanks~ where in the database did you find the order numbers, i dont see the last order number so i have no reference?? thanks. Quote Link to comment Share on other sites More sharing options...
Guest Posted August 3, 2008 Share Posted August 3, 2008 where in the database did you find the order numbers, i dont see the last order number so i have no reference?? thanks. don't bother to find the order numbers, just run the following query at mysql if you want your number to start from 1000. alter table orders auto_increment = 1000; Jason Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.