Posted on 2011-02-15
i've got a file which is my main file for adding orders and i need a bit of help.
the first page of my add orders is to select the customer and add additional delivery details if necessary.
when i started building all of this, i skipped the "add delivery details" aspect because it was causing a headache. i now think i have an idea of how to do it, but am i little bit stuck.
as the first page starts of the order, it inserts the customers id number, the salesman id, and the status to 1 in a new row in the _orders table. i also at this stage had the mysql_insert_id put into a session, so that each page thereafter could add more details to the record.
the way i was thinking the delivery details bit would work was it adds any extra details to a new column, and again using a mysql_insert_id, get the id number from that record, and insert it into the _orders table.
so basically, how do i use mysql_insert_query for different queries? i
hope that makes sense