Hello!
I’m a beginner in PHP/MySql. I read some book, but now I want to customize my own scripts instead of just doing the tutorials. Yesterday, I tried and tried, but couldn’t achieve what I wanted. This is what I wanted to do:
I have a MySql database called: CONTENT
I have two tables in database CONTENT: approve and published
each one has 3 columns: ID, content, and the date
I need an Administrator’s page to see the to be approved content that is inside table APPROVE, and then the administrator enters the content ID in a field to approve it and be published.
The script is supposed to delete the row in table APPROVE and write it in table PUBLISH (since table PUBLISH contains the published data).
I tried and tried but couldn’t do it. Could anybody help me please?
Leo