select items from mysql

radiant

New Member
making a simple movie review site to practice PHP. on one page ( a form) i write a title and review and submit, it then adds the info to mysql. i'm trying to create a page where i can delete reviews i've written. i'm going about this by returning all titles into a form tag, where i can select on and then submit that form to a process page and delete the item.having issues with the WHILE statement and SQL statement.\[code\]$conn = mysql_connect($host, $user, $password) or die("couldn't make connection");mysql_select_db('cms', $conn) or die("couldn't select database");$sql = "SELECT * FROM frontPage";$sql_result = mysql_query($sql, $conn) or die("couldn't execute query");while($row = mysql_fetch_array($sql_result)) { $movieTitle = $row['title'];}?><form method="post" action="deleteReview_process.php"><select name="title"> <option><?php echo $movieTitle; ?></select><input type="submit" name="delete" id="delete" value="http://stackoverflow.com/questions/2114612/delete" /> </form>\[/code\]
 
Back
Top