webhost Posted March 14, 2003 Share Posted March 14, 2003 hi there, How does one change the order process number? Cheers :0 Link to comment Share on other sites More sharing options...
mugitty Posted March 14, 2003 Share Posted March 14, 2003 Do you mean the order number that is automatically assigned to each order? ... if you want to REALLY see something that doesn't set up right out of the box without some tweaking, try being a Foster Parent! Link to comment Share on other sites More sharing options...
webhost Posted March 14, 2003 Author Share Posted March 14, 2003 yes, thats correct! Link to comment Share on other sites More sharing options...
mugitty Posted March 14, 2003 Share Posted March 14, 2003 Create a dummy order, then go into your database and change the order id for that order to whatever number you want your sequence to start with (i.e. 2000). The next order placed will be 2001. As far as I know, it must be digits only - I don't think that auto-increment can accept letters. ... if you want to REALLY see something that doesn't set up right out of the box without some tweaking, try being a Foster Parent! Link to comment Share on other sites More sharing options...
webhost Posted March 14, 2003 Author Share Posted March 14, 2003 Field Type [Documentation] Length/Values* Attributes Null Default Extra which box do I enter the number 2131 Link to comment Share on other sites More sharing options...
mugitty Posted March 14, 2003 Share Posted March 14, 2003 In your osC database: TABLE: orders FIELD: orders_id ... if you want to REALLY see something that doesn't set up right out of the box without some tweaking, try being a Foster Parent! Link to comment Share on other sites More sharing options...
webhost Posted March 14, 2003 Author Share Posted March 14, 2003 under which box do I make the changes Field Type[Documentation] Length/Values* Attributes Null Default Extra which box do I enter the number 2131 Link to comment Share on other sites More sharing options...
Guest Posted March 14, 2003 Share Posted March 14, 2003 You are looking at the orders table, click "browse". That will show you the contents of the table. Then you can edit the #. Link to comment Share on other sites More sharing options...
Ajeh Posted March 14, 2003 Share Posted March 14, 2003 Personally, I create an order then edit *all* order tables and change the orders_id number I made to the new orders_id number so everybody matches up. But that is just me ... :wink: Link to comment Share on other sites More sharing options...
mugitty Posted March 14, 2003 Share Posted March 14, 2003 Assuming that you're using phpMyAdmin: Click on "orders" in the left column, choose "Browse" from the toolbar at the top, find the dummy order that you placed, click on "edit" and then change the "Value" in Field "orders_id" to what you want your starting order number to be, then select "Save" and "Go" at the bottom of the page. ... if you want to REALLY see something that doesn't set up right out of the box without some tweaking, try being a Foster Parent! Link to comment Share on other sites More sharing options...
shienhang Posted September 15, 2003 Share Posted September 15, 2003 thank you i follow the steps and change my order id sucessfully. have a nice day to all of you. bye :D Link to comment Share on other sites More sharing options...
Guest Posted September 15, 2003 Share Posted September 15, 2003 There is a way to find all posts by a member: Click on the MEMBER link at the top of the page Members At the bottom there is a box 'Search All Available' and an empty box. Drop the 'all available' box. Select either 'names begins' or 'name contains' Enter the member name - all or part as per slection above. Click GO All matching members will be displayed Click on the member you want, then click on find all posts Long winded but it does work. Link to comment Share on other sites More sharing options...
Guest Posted September 15, 2003 Share Posted September 15, 2003 Sorry - managed the above reply in the wrong place!!!! Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.