Current location: Hot Scripts Forums » Programming Languages » PHP » Remove data from table after submission


Remove data from table after submission

Reply
  #1 (permalink)  
Old 09-21-09, 03:47 PM
cyberfolli cyberfolli is offline
Newbie Coder
 
Join Date: Jan 2004
Posts: 93
Thanks: 8
Thanked 0 Times in 0 Posts
Remove data from table after submission

OK I am so close to completion on this little project.

Basically I am taking info and submitting it to a table this works! now after that data is submited to the new table I would like to remove it from the table I took it from.. hence the delete query below the insert..


Code:
$stamp = $_POST['stamp']; 
$reoccurr = $_POST['reoccurr'];
$title = $_POST['title'];
$department = $_POST['department'];
$notes = $_POST['notes'];

ini_set ("display_errors", "1");
error_reporting(E_ALL);  

mysql_query("INSERT INTO `events` (stamp, reoccurr, title, department, notes) VALUES ('$stamp','$reoccurr','$title','$department','$notes')");

$ID = $_POST['ID']; 


mysql_query ("delete FROM events_cue WHERE ID='".$ID."'"); 
	 
echo "<center> <a href=cue.php>Return to cue</a>";

Last edited by cyberfolli; 09-21-09 at 03:48 PM. Reason: Needed to subscribe
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiShare on FacebookShare on Stumble UponShare on Twitter
Reply With Quote
  #2 (permalink)  
Old 09-21-09, 03:52 PM
cyberfolli cyberfolli is offline
Newbie Coder
 
Join Date: Jan 2004
Posts: 93
Thanks: 8
Thanked 0 Times in 0 Posts
Figured it out!

Figured it out! sorry ..
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiShare on FacebookShare on Stumble UponShare on Twitter
Reply With Quote
Reply

Bookmarks

Tags
remove data


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MYSQL database countll Database 2 06-19-07 05:20 PM


All times are GMT -5. The time now is 11:11 AM.
vBulletin® Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.