Forum Moderators: coopster
I want a page with a form that loads the oldest record id #1 from database A into a form so it can be edited if need be and then a button that says Submit that will delete the record from database A and put the record into database B and a button that says Reject, which will just simply destory the record in database A
i know its complicated, but help with the PHP would be greatly appreciated
here are a couple of threads that might help with portions of your question from our PHP Forum Library [webmasterworld.com]
Basics of extracting data from MySQL using PHP [webmasterworld.com]
Help developing MySQL search query [webmasterworld.com]
I can also give you the basic logic of what you are trying to which might help
1. select last record from db A
2. load those values into a page/form
3. if submit is clicked
a. take form values and insert into db B
b. delete record from db A
4. if reject is clicked
a. delete record from db A
5. forward to a 'process complete' page
that about covers it. I would start by selecting the record and displaying it, once that is complete then you can move on to the inserting and deleting.
We have an AdSense Forum [webmasterworld.com] here also