PHP help

1

I have 1 database: CONTENT

I have 2 tables inside the database:

  1. APPROVE
    columns: ID, approve_content, approve_date

  2. PUBLISHED
    columns: ID, published_content, published_date

i have a index page where you can see what’s inside the published_content columns.

I want an admin page where you see all the content waiting to be approved. that content is inside the APPROVE table. i already have the script for that. then, i have a form where you input the ID of the approve_content, when you select the ID, and click SUBMIT, the script is supposed to:

delete from APPROVE table and
write it in the PUBLISHED table

my script erases from the APPROVE table but DOES NOT pass that data into the PUBLISHED table in the PUBLISHED_CONTENT row.

how can i do that?

this is my script:

 <p>MANAGEMENT</p>
 <p>
 
 <form action="<?=$_SERVER['PHP_SELF']?>" method="post">
 <p>Approve: <br />
 <textarea name="publishedID" rows="1" cols="3" wrap>
 </textarea><br />
 <input type="submit" name="published_go" value="submit" />
 </p></form></p>

<?php

if (isset($_POST[published_go]))
{
$publishedID = $_POST[‘publishedID’];

$variable_1 = “SELECT approve_content FROM approve WHERE id = ‘$publishedID’”;
$get_data = mysql_query($variable_1);

if(!$get_data)
{
echo “You keep on being stupid” . mysql_error();
exit;
}

$row = mysql_fetch_assoc($get_data);
$curdate = ‘CURDATE()’;

$insert_in_DB = “INSERT INTO published SET
published_content = ‘$get_data’,
published_date = ‘$curdate’”;
$do_insert = mysql_query($insert_in_DB);

$delete_from_DB = “DELETE FROM approve WHERE id = ‘$publishedID’”;
$do_delete = mysql_query($delete_from_DB);
}

?>

THANKS IN ADVANCE!
:red: