ChristianX
Programmer
what i am trying to do is this:
1)The user can click a link to bring up all the items in the database they have added
2)The user can then click a particular item (which is a link) to bring them to a page with the details of that item
Now instead of the add or delete option i wish to add another button-Approve Item. So if a user puts an item up for sale they can delay putting it for sale until they approve it. If they decide to definately post it for sale they can click approve: This will approve the item for selling and will initiate the following to occur:
1) Approve the item and add the record displayed to an ApprovedItems table
and
2) Delete the item from the old Items table (to save on memory)
The items in the Approved Items table will be made available to view by users.
How do i implement such a page? To delete from one table whilst at same time adding the same record to another table?
Thanks to anyone who reads this and can help!
1)The user can click a link to bring up all the items in the database they have added
2)The user can then click a particular item (which is a link) to bring them to a page with the details of that item
Now instead of the add or delete option i wish to add another button-Approve Item. So if a user puts an item up for sale they can delay putting it for sale until they approve it. If they decide to definately post it for sale they can click approve: This will approve the item for selling and will initiate the following to occur:
1) Approve the item and add the record displayed to an ApprovedItems table
and
2) Delete the item from the old Items table (to save on memory)
The items in the Approved Items table will be made available to view by users.
How do i implement such a page? To delete from one table whilst at same time adding the same record to another table?
Thanks to anyone who reads this and can help!