More update troubles

[Anonymous]

$sql = "UPDATE `shows` SET `date` = '$date', `bands` = 'bands', `venue` = 'venue', `other` = 'other' WHERE `date` = '$date'";
$result = mysql_query($sql) or die(mysql_error());

This is not working, I have pretty much the same code working in another page, I think maybe it could be to do with MySql 4, as I haven't run the script to set the priveleges correct (as I dont know how) but I have it working on another page. My insert code isn't working either, but delete is.

 

[Anonymous]

$sql = "UPDATE `shows` SET date= '$date', bands=$bands, venue= '$venue', other='$other' WHERE `date` = '$date'"; 
$result = mysql_query($sql) or die(mysql_error());

try that. You were missing a lot of $ signs.

Andrew