sammy1jackson12
New Member
using a drop-down list that's populated from database fields, i need to select an option and then delete that from the database. i'm trying to do this by sending the form to a process php page where i pull in the select option from the post array and then delete it from the database and return to the index page. having issues with getting the array variable from the post array. can anyone help with some code on how to get the variable and then delete the mysql title\[code\]<form method="post" action="deleteReview_process.php"><select name="title"> <?php while($row = mysql_fetch_array($sql_result)) { $movieTitle = $row['title']; ?><option><?php echo $movieTitle; ?></option> <?php } ?></select><input type="submit" name="delete" id="delete" value="http://stackoverflow.com/questions/2114891/delete" />\[/code\]---- and the process page ---\[code\]include 'inc/db.inc.php';if($_POST['delete']) { $title = $_POST['title'][$movieTitle]; <------ NOT WORKING $sql = "DELETE" . $title . "FROM pageTitle"; mysql_query($sql, $conn) or die("couldn't execute query"); header("Location: http://localhost/cms/index.php"); } else { header("Location: http://localhost/cms/deleteReview.php"); }\[/code\]