Koolguy
November 20th, 2000, 18:49
I can't seem to get this script to update the database:
<html>
<head><title>Edit a music review</title></head>
<body>
<?
if ($submit) {
@MYSQL_CONNECT("localhost","username","password");
@mysql_select_db("koolplace_com");
$sqlquery = "UPDATE music_review SET artist='$artist', album='$album', publisher='$publisher', genre='$genre', review='$review' WHERE id = '$id'";
$results = mysql_query($sqlquery);
$id= mysql_insert_id();
print "<p>Your review has been updated, it has an id of: <b>$id</b>";
MYSQL_CLOSE();
} else {
@MYSQL_CONNECT("localhost","username","password");
@mysql_select_db("koolplace_com");
$query = "select artist,album,publisher,genre,review from music_review where id=$id";
$result = @MYSQL_QUERY($query);
$artist = @MYSQL_RESULT($result,0,"artist");
$album = @MYSQL_RESULT($result,0,"album");
$publisher = @MYSQL_RESULT($result,0,"publisher");
$genre = @MYSQL_RESULT($result,0,"genre");
$review = @MYSQL_RESULT($result,0,"review");
MYSQL_CLOSE();
?>
<form method="post" action="<?php echo $PHP_SELF; ?>" enctype="multipart/form-data">
<input type="hidden" value="<?echo $id;?>" name="id">
<table width="500" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="2"><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#000000">Add
a review, please replace ' with '</font></td>
</tr>
<tr>
<td width="435"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Artist:
</font></td>
<td width="65">
<input type="text" name="artist" value="<?echo "$artist";?>">
</td>
</tr>
<tr>
<td width="435"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Album:
</font></td>
<td width="65">
<input type="text" name="album" value="<?echo "$album";?>">
</td>
</tr>
<tr>
<td width="435"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Record
Company:</font></td>
<td width="65">
<input type="text" name="publisher" value="<?echo "$publisher";?>">
</td>
</tr>
<tr>
<td width="435"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Genre:</font></td>
<td width="65">
<input type="text" name="genre" value="<?echo "$genre";?>">
</td>
</tr>
<tr>
<td colspan="2">
<textarea name="review" rows="20" cols="90"><?echo $review;?></textarea>
</td>
</tr>
<tr>
<td colspan="2">
<input type="submit" value="Submit" name="submit">
</td>
</tr>
</table>
</form>
<? } ?>
</body>
</html>
<html>
<head><title>Edit a music review</title></head>
<body>
<?
if ($submit) {
@MYSQL_CONNECT("localhost","username","password");
@mysql_select_db("koolplace_com");
$sqlquery = "UPDATE music_review SET artist='$artist', album='$album', publisher='$publisher', genre='$genre', review='$review' WHERE id = '$id'";
$results = mysql_query($sqlquery);
$id= mysql_insert_id();
print "<p>Your review has been updated, it has an id of: <b>$id</b>";
MYSQL_CLOSE();
} else {
@MYSQL_CONNECT("localhost","username","password");
@mysql_select_db("koolplace_com");
$query = "select artist,album,publisher,genre,review from music_review where id=$id";
$result = @MYSQL_QUERY($query);
$artist = @MYSQL_RESULT($result,0,"artist");
$album = @MYSQL_RESULT($result,0,"album");
$publisher = @MYSQL_RESULT($result,0,"publisher");
$genre = @MYSQL_RESULT($result,0,"genre");
$review = @MYSQL_RESULT($result,0,"review");
MYSQL_CLOSE();
?>
<form method="post" action="<?php echo $PHP_SELF; ?>" enctype="multipart/form-data">
<input type="hidden" value="<?echo $id;?>" name="id">
<table width="500" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="2"><font face="Verdana, Arial, Helvetica, sans-serif" size="1" color="#000000">Add
a review, please replace ' with '</font></td>
</tr>
<tr>
<td width="435"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Artist:
</font></td>
<td width="65">
<input type="text" name="artist" value="<?echo "$artist";?>">
</td>
</tr>
<tr>
<td width="435"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Album:
</font></td>
<td width="65">
<input type="text" name="album" value="<?echo "$album";?>">
</td>
</tr>
<tr>
<td width="435"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Record
Company:</font></td>
<td width="65">
<input type="text" name="publisher" value="<?echo "$publisher";?>">
</td>
</tr>
<tr>
<td width="435"><font size="1" face="Verdana, Arial, Helvetica, sans-serif">Genre:</font></td>
<td width="65">
<input type="text" name="genre" value="<?echo "$genre";?>">
</td>
</tr>
<tr>
<td colspan="2">
<textarea name="review" rows="20" cols="90"><?echo $review;?></textarea>
</td>
</tr>
<tr>
<td colspan="2">
<input type="submit" value="Submit" name="submit">
</td>
</tr>
</table>
</form>
<? } ?>
</body>
</html>