How to store two values in 1 field in store summary

I have a new field in my orders table that is named SerialNumber. I want to store the date field as the first6 number and then the OrderId field as the last numbers. I am currently on orderID number 19. I want the SerialNumber field to hold the date and orderID so that the SerialNumber field will look like 11100919.
So my question is how do I bind both values from the confirm page into the store summary. I can get the date there but I don't know what to use as orderId since it is a blank value in the wizard.

This will not be possible. The value of the orderID column cannot be known until the order record is inserted.


you can create the serial number value in the PHP page that will display the record to the user though, using the CONCAT function to concatenate the orderID and orderDate columns together:

SELECT CONCAT(orderID, '', orderdate) as serailNum FROM orders

Thanks Jason,
I understand. I just need the serial numbers to be 8 digits and to be sequential so that no two are the same. Can you point me in another direction?

The best solution is the one I provided in my previous reply where you use the CONCAT function to create the serial number at run time

The CONCAT function will create the serial number for you by programmatic combining the orderID and orderDate column when you display the information to the user. you dont need to store the serial in a separate column, just combine the two columns IN The SQL when the order info is requested by the user.

Thanks, that is what i did.