Hi Guys,
I have a script i've setup that edits my movie reviews, I have got it to the point where it displays in the form, however when I hit submit, it's telling me it's updated but isn't!!
Heres my code:
<? include "pageheader.php" ?>
<?
$db=mysql_connect("HOST","USERNAME","PASSWORD");
mysql_select_db("DATABASE",$db);
?>
<? $movieid = $_GET['movieid'] ?>
<font size="3"><B></B></font>
<? echo $myrow["moviegenre"]; ?><BR>
<div align="center">Please select a Category: <br>
[<a href="editmovie3.php?category=drama">DRAMA</a>] [<a href="editmovie3.php?category=comedy">COMEDY</a>] [<a href="editmovie3.php?category=action">ACTION</a>] [<a href="editmovie3.php?category=animated">ANIMATED</a>] [<a href="editmovie3.php?category=horror">HORROR</a>] </div>
<BR><BR>
<?
if ($movieid == "") {
$sql="SELECT * FROM moviescomedy WHERE moviegenre LIKE '" . $_GET["category"] . "%'ORDER BY moviename ASC";
$result=mysql_query($sql);
$ncount=0;
echo "<font size=1> </font>";
while ($myrow=mysql_fetch_array($result)) {
if ($ncount<100)
{
$ncount=$ncount+1;
$movielong = str_replace("\'", "'", $movielong);
?>
<img src=../staricon.jpg> <a href=editmovie3.php?movieid=<? echo $myrow["movieid"]; ?>>
<? echo $myrow["moviename"]; ?></a><br>
<?
}
}
} else {
$sql="SELECT * FROM moviescomedy WHERE movieid=$movieid ORDER BY moviename DESC";
$result=mysql_query($sql);
$myrow=mysql_fetch_array($result);
printf("<fieldset class=fieldset><legend><span class=Header>Edit %s:</span></legend>", $myrow["moviename"]);
printf("<div class=div><div align=right> <form action=editmoviesform.php method=post>", $myrow["movieimage"]);
printf("Movie ID:<input name='movieid' type='text' value='%s' size='5' maxlength='5' /><br />", $myrow["movieid"]);
printf("Your Name:<input name='movieby' type='text' value='%s' size='30' maxlength='50' /><br />", $myrow["movieby"]);
printf("Movie Name:<input name='moviename' type='text' value='%s' size='30' maxlength='100' /><br />", $myrow["moviename"]);
printf("Director:<input name='moviedirector' type='text' value='%s' size='30' maxlength='100' /><br />", $myrow["moviedirector"]);
printf("Starring:<input name='moviestarring' type='text' value='%s' size='30' maxlength='100' /><br />", $myrow["moviestarring"]);
printf("Release Date:<input name='movierelease' type='text' value='%s' size='30' maxlength='100' /><br />", $myrow["movierelease"]);
printf("Run Time:<input name='movieruntime' type='text' value='%s' size='30' maxlength='100' /><br />", $myrow["movieruntime"]);
printf("Short Synopsis:<textarea name='movieshort' type='text' cols='50' rows='10' />%s</textarea><br />", $myrow["movieshort"]);
printf("Long Synopsis:<textarea name='movielong' type='text' cols='50' rows='10' />%s</textarea><br />", $myrow["movielong"]);
printf("Genre:<input name='moviegenre' type='text' value='%s' size='30' /></textarea><br />", $myrow["moviegenre"]);
printf("Image Link:<input name='movieimage' type='text' value='%s' size='30' maxlength='400' /><br />", $myrow["movieimage"]);
printf("Trailer Link (Retrieve short code from <a href='http://www.youtube.com' target=_blank>YOUTUBE</a>:<input name='movietrailer' type='text' value='%s' size='30' maxlength='100' /><br />", $myrow["movietrailer"]);
printf("Offical Website:<input name=moviewebsite type=text value=%s size=30 maxlength=100 /><br />", $myrow["moviewebsite"]);
printf("Rating:<label><select name='movierating'><option>U</option><option>PG</option><option>12A</option><option>15</option><option>18</option></select></label><br />", $myrow["movierating"]);
printf("Showtimes (If Any):<textarea name='movieshowtimes' type='text' cols='50' rows='10' />%s</textarea><br />", $myrow["movieshowtimes"]);
printf("Movie Mistakes (Retrieve from IMDB):<textarea name='moviemistakes' type='text' cols='50' rows='10' />%s</textarea>", $myrow["moviemistakes"]);
printf("<br /><br /><br /><label><input type='submit' value='Edit %s' /><br /></form></div></div></fieldset>", $myrow["moviename"]);
}
?>
<? include "pagefooter.php" ?>
And here is the editmoviesform.php 'The MySQL bit'
<? include "pageheader.php" ?>
<?
$username="USERNAME";
$password="PASSWORD";
$database="DATABASE";
$host="MYHOST";
$movieby=$_POST['movieby'];
$moviename=$_POST['moviename'];
$moviedirector=$_POST['moviedirector'];
$moviestarring=$_POST['moviestarring'];
$movierelease=$_POST['movierelease'];
$movieruntime=$_POST['movieruntime'];
$movieshort=$_POST['movieshort'];
$movielong=$_POST['movielong'];
$moviegenre=$_POST['moviegenre'];
$movieimage=$_POST['movieimage'];
$movietrailer=$_POST['movietrailer'];
$moviewebsite=$_POST['moviewebsite'];
mysql_connect($host,$username,$password);
mysql_select_db($database);
$query = "UPDATE moviescomedy SET ('$movieby','$moviename','$moviedirector','$moviestarring','$movierelease','$movieruntime','$movieshort','$movielong','$moviegenre','$movieimage','$movietrailer','$moviewebsite') WHERE movieid='$movieid'";
mysql_query($query);
mysql_close();
?>
<fieldset class="fieldset"><legend><span class="Header">Add Movie:</span></legend>
<div class="div">
<div align="center">
Hi <?php print "$movieby"; ?> Your Movie Was Edited Successfully!<br />
<br /><?php print "$moviename"; ?><br><img src="<?php print "$movieimage"; ?>">
<table width="102" height="102" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center"></td>
</tr>
</table>
<br />
<a href="editmovie3.php">Edit another Movie?</a> </div>
</div>
</fieldset>
<? include "pagefooter.php" ?>
Does anyone see what could be wrong?
Help would be appreciated!!!
Thanks,
Andy
