MySQL Table not updating

Anon

When using the following code, the table does not update. I know it is getting thru the if statement because the echo's are displayed, and the altered strings are appearing.. just not in the database.

if ($action == updatemovie) {
$db = mysql_connect("$site", "$user", "$pass");
mysql_select_db("$user",$db);

$update_movie_details = "UPDATE moviedetails SET title='$title', subtitle=$subtitle, alttitle=$alttitle, titlequote$titlequote, stars=$stars, director=$director, writer=$writer, producer=$producer, horrorgenre=$horrorgenre, bodycount=$bodycount, rating=$rating, year=$year, runningtime=$runningtime, plotorblurb=$plotorblurb, trivia=$trivia, links=$links WHERE movieid='$movieid'";
mysql_query($update_movie_details);

// test line
echo "$title $subtitle $alttitle $year $movieid";

echo "Thank you! The Movie Information has been entered into the database.";
echo "Click <a href=\"moviedetails.php?movieid=$movieid\" target=\"_blank\">HERE</a> to view the submission online.";
}

Thanks in advance!

Clint

Anon

echo the query to the screen. copy to string and paste it into mysql command prompt. does it work? are there errors? how many records are shown as updated ?

try adding this code after all mysql statments.

check_db($query);
..
function check_db($query = '')

{

if ( mysql_errno() )

{

echo "Error: Problem with DataBase : $this->database_db \n";

echo "Error: " . mysql_errno() . ':' . mysql_error() . " \n";

echo "Query: $query \n";

exit();

}

if (@$GLOBALS['DB_DEBUG'])  
  echo "Query: $query<br>\n";

}

this is from my class so modify as needed.

Chris Lee
lee@mediawaveonline.com

[deleted]

Use error checking, have a look at this:

http://www.xs4all.nl/~vinny/index.html#4

Anon

Thanks Chris, echo'ing the query to the screen helped. The variables should have quotes around them (title='$title') which I originally had, but didn't work.. because of the typo error: titlequote$titlequote

Thanks again.