Hey guys i am kind of confused on something. So basically i have a web application in which i wan to create a section to fill receipt infomation, i need some infomation such as customer id customer name, customer address, customer tel, product id, sales agent id, order number and order date. The customer id, ordern number,order date ,agent id and product date will be store in one table.
What i am confused about is that will it be better to generate the customer id using php mt_rand() function based on some criterias so that this info gets directly to the order table without any further queries or generate this id with mysql and query the database again to get this info and store in the order table (and i will need to store the customer id in who bought a specific product in the orders table).
Which is better or what can i do that's better??
Sent from my 404SC using Tapatalk