any way to insert data into two tables at the same time?
what I have is a table called `order` and a table called `lmcharge`.
a person inputs data from a form and i need to take the data from both and some goes into one table, some goes into another
here is an example:
student_id, class_id, order_type, date, status
//student_id, class_id, order_type will be from the form
student_id, order_id, lm_number
//student_id, and lm_number will also be from the form but order_id will have to be from the order table
anyone have a clue?