I have two databases _blue (it contains the shipping and terms of invoices)
The second database is _pickblue (it contains the items that people can order)
They are tied together master record of field named blueid and blueid2
I have created a add screen to enter a new invoice and from that invoice when the person hits submit, I want it to remember the blue id number and advance the screen to master table file at pickblue_list.php?mastertable=cblue&masterkey1=???
Now I understand that I need to put in the after record a header locations url. But what I need is for it to remember and automatically change the last part of the url to the new blueid number it got.
example:
pickblue_list.mastertable=cblue&masterkey1=
Right now I have my afterAdd code as this and it errors out:
[color=#FF0000]$_SESSION["blueid"] = $keys["blueid"];
//** Redirect to another page ****
header("Location: pickblue_list.php?mastertable=cblue&masterkey1=$value["blueid"]");
exit();
Any help would be greatly appreciated.
Kim