Updating Records in MySQL

[dbaz]

This is my first post... a friend recommended I ask someone on this board... so, any help is GREATLY appreciated.

I'm simply trying to update an existing MySQL database from an HTML form. For some reason, when I hit submit, it doesn't give me an error... but, also doesn't actually update the content in the database. Any ideas?

<?php
$name = $POST['name'];
$theater = $POST['theater'];
$address = $POST['address'];
$city = $POST['city'];
$state = $POST['state'];
$zip = $POST['zip'];
$phone = $POST['phone'];
$ticketlink = $POST['ticketlink'];
$description = $POST['description'];
$reviews = $POST['reviews'];
$ebay = $POST['ebay'];
$epinions = $POST['epinions'];
$nameofreview = $POST['nameofreview1'];
$urlofreview = $POST['urlofreview1'];
$nameofreview2 = $POST['nameofreview2'];
$urlofreview2 = $POST['urlofreview2'];
$nameofreview3 = $POST['nameofreview3'];
$urlofreview3 = $POST['urlofreview3'];
?>
<?
$db="xyz";
$link = mysql_connect("xyz", "xyz", "xyz");
if (! $link)
die("Couldn't connect to MySQL");
mysql_select_db($db , $link)
or die("Couldn't open $db: ".mysql_error());

$query = "UPDATE mainshow WHERE id='$id' SET id='$id' name='$name', theater='$theater', address='$address', city='$city', state='$state', zip='$zip', phone='$phone', ticketlink='$ticketlink', description='$description', reviews='$reviews', ebay='$ebay', epinions='$epinions'";

mysql_query($query);

$query = "UPDATE showreviews SET showid='$id', nameofreview='$nameofreview', urlofreview='$urlofreview'";
$query = "UPDATE showreviews SET showid='$id' nameofreview='$nameofreview2' urlofreview='$urlofreview2'";
$query = "UPDATE showreviews SET showid='$id' nameofreview='$nameofreview3' urlofreview='$urlofreview3'";
mysql_query($query);

printf("Thanks for your submission");

mysql_close($link);
?>

[cgraz]

On your first query, put the WHERE clause at the end

$query = "UPDATE mainshow SET id='$id' name='$name', theater='$theater', address='$address', city='$city', state='$state', zip='$zip', phone='$phone', ticketlink='$ticketlink', description='$description', reviews='$reviews', ebay='$ebay', epinions='$epinions' WHERE id='$id'"; 
   print $query . "<br>"; // printing the query string always helps for problem solving db problems
   mysql_query($query) or die(mysql_error());  // use mysql_error to find any errors

You do realize that in this next portion of code, only the last $query is actually getting executed here. You keep reassigning the value of $query, until
you execute $query (at which time it holds the value of the last one). You need execute each one individually.

---- speaking of code below ---

$query = "UPDATE showreviews SET showid='$id', nameofreview='$nameofreview', urlofreview='$urlofreview'";
$query = "UPDATE showreviews SET showid='$id' nameofreview='$nameofreview2' urlofreview='$urlofreview2'";
$query = "UPDATE showreviews SET showid='$id' nameofreview='$nameofreview3' urlofreview='$urlofreview3'";
mysql_query($query);

Cgraz

[dbaz]

THANK YOU SOOOO MUCH!
-dbaz