Update Query Problem

[mpugh]

I just can't figure out how to fix this problem. I've checked that the $blockid is getting passed correctly and that all the other variables are too but the query doesn't update the table. Can you help?

$query = "UPDATE blocks SET name='$name',content='$content',side='$side',pos='$pos' WHERE id='$blockid'";
$result=mysql_query($query);

Here is the full code:

If ($func=="editblock") {

$query = "SELECT * FROM blocks WHERE id='$blockid'";
$result=mysql_query($query);
$data = mysql_fetch_array($result);
$name = $data['name'];
$content = $data['content'];
$side = $data['side'];
$pos = $data['pos'];

?>

<table width="100%" border="0" cellspacing="1" cellpadding="0" bgcolor="FF0000"><tr><td>
<table width="100%" border="0" cellspacing="1" cellpadding="8" bgcolor="#F9F9F9"><tr><td>
<DIV ALIGN="center"><font class="pn-title">Blocks Administration</font></DIV>
</td></tr></table>
</td></tr></table><br>

<table width="100%" border="0" cellspacing="1" cellpadding="0" bgcolor="FF0000"><tr><td>
<table width="100%" border="0" cellspacing="1" cellpadding="8" bgcolor="#F9F9F9"><tr><FORM ACTION="admin.php?module=blocks&func=saveblock&blockid=<?php echo $blockid ?>" METHOD="POST"><td align=center>
<TABLE WIDTH=100%><TR><TD WIDTH=33% ALIGN=center><font class="pn-title">Name:</font><br><input type="text" name="name" value="<?php echo $name ?>"></TD><TD WIDTH=33% ALIGN=center><font class="pn-title">Side:</font><br>
<select name="side">
<?php
If ($side=="left") {
?>
<option value="left" SELECTED>Left
<option value="right">Right
<?php
} else {
?>
<option value="left">Left
<option value="right" SELECTED>Right
<?php
}
?>
</select></TD><TD WIDTH=34% ALIGN=CENTER>
<font class="pn-title">Pos:</font><br>
<input type="text" name="pos" value="<?php echo $pos ?>" size=10></TD></TR></TABLE><BR><BR>
<textarea rows=20 name="content" style="width:100%"><?php echo $content ?></textarea><br><br>
<input type="submit" value="Save Changes">
</td></FORM></tr></table>
</td></tr></table><br>

<?php

}

If ($func=="saveblock") {

$query = "UPDATE blocks SET name='$name',content='$content',side='$side',pos='$pos' WHERE id='$blockid'";
$result=mysql_query($query);

}

[LordShryku]

You need some basic debugging. Echo the query to the screen and use mysql_error() to trap the error message.

[YappyDog]

Have you checked to make sure you have anything in the $func variable? My guess is you are never executing the update statement.

I agree with LordShryku though, put in some debug code and echo out some values along the way so that you can tell exactly what's going on.