UPDATE statement

[danglauber]

I'm having a problem updating information in my database. Here is my code:

<?php
include ('commonAdmin.php');
htmlheader();
adminhtmlheader();

if(mysql_connect("localhost","","")) echo "DB CONNECTION OPEN<br />\n";
if(mysql_select_db(jwahost_data)) echo "DB SELECTION COMPLETE<br />\n";

$mod_id = $POST[mod_id];
$sort = $POST[sort];
$location = $POST['location'];
$mod_name = $POST['mod_name'];

$query = "UPDATE modules SET mod_id=$mod_id, sort=$sort, location='$location', mod_name='$mod_name'";

$result = mysql_query($query);

if($result) echo "UPDATED!";

else echo "<strong>FAILURE</strong><br />".mysql_errno().": ".mysql_error()."<br />\n";

echo $query;

adminhtmlfooter();
htmlfooter();
?>

Any help would be great!
Dan

[cgraz]

are you trying to update the entire database, or just one record? Make sure to use the WHERE clause if you're only updating one record.

Put single quotes around your variables. use mysql_error() when executing to see if there are any errors. Print your query string ($query) to see if it is being passed the way you want it to.

Cgraz