What is wrong with this code?

[atokatim]

<?
$mid = $POST['mid'];
$img = $POST['imagekey'];
$songname = $POST['songname'];
$bandname = $POST['bandname'];
$image_result = mysql_query("SELECT songname,bandname FROM images WHERE image_id = '$img'", $db);
$image = mysql_fetch_object($image_result);

$sql = "UPDATE images SET songname = $songname WHERE image_id = '$img' AND mid = '$mid'";

$result = mysql_query($sql);

$sql = "UPDATE images SET bandname = $bandname WHERE image_id = '$img' AND mid = '$mid'";

$result = mysql_query($sql);

?>

for some reason, this does not update anything....... As you can see, i am not that good in MySql at all.....but i try!!!

[toplay]

If you display the MySQL errors, then it would help you figure out the problem. Example:

$result = mysql_query($sql) or die("SQL: $sql <br>Error: " . mysql_error());

But off hand, I would say it's the fact you don't have single quotes around $songname and $bandname in your UPDATE.

Good luck.

🙂

[atokatim]

That worked!! I knew it had to be something simple. I appreciate that!

Tim

http://www.Mp3Profiles.com