i have a text box and a rename button
when i select a particular value in the drop down box and enter a name in the textbox and then click on rename button ...it should rename the selected namefrom dropdown to the name entered in textbox
but its not doing so in my script
i m dead sure its something in the update command line which i m using... plz help
Code: Select all
<?php
$genre_name = $_POST['genre'];
$genrename = 'genrename';
$genrevalue = array();
$genre_select = $_POST['genrename'];
$query_name = " SELECT image_category.genre FROM image_category ";
$result = mysql_query($query_name);
confirm_query($result);
?>
<?
//-----------Rename genre in database ---------------------
if (isset($_POST['rename_genre'])) {
$query = "UPDATE image_category
SET image_category.genre = '$genre_name'
WHERE image_category.genre = '". mysql_real_escape_string($genre_select) ."'";
$result1 = mysql_query($query, $connection);
echo $genre_select;
echo $genre_name;
if ($result1) {
$message = "new genre has been renamed";
}
else {
$message = "new genre could not be renamed";
}
}
?>
<td id="page">
<?php if (!empty($message)) {echo "<p class=\"message\">" . $message . "</p>";} ?>
<form action="rename_genre.php" method="post">
<table>
<div style="position: absolute; width: 100px; height: 32px; z-index: 1; left: 225px; top: 5px" id="layer1">
<td><br>
<select name="genrename" maxlength="30">
<?php
//-----------displays genre from database ---------------------
while ($record = mysql_fetch_assoc($result)) {
while (list($genrename, $genrevalue) = each ($record)) {
echo '<option>'.htmlentities($genrevalue).'</option>';
}
echo "<BR>";
}
?>
</select> </td>
<tr>
<td>Genre</td>
<td><input type="text" name="genre" maxlength="20" value="<?php echo htmlentities($genre_name); ?>" /></td>
</tr>
<tr>
<td colspan="2"><input type="submit" name="rename_genre" value="rename_genre" /></td>
</tr>
</table>
</form>
</td>
</body>