Updating last item in a database

[klavis]

Hi I am trying to do something i thought would be simple....to update the most recent item that was added to a database..
I used this line of code:
$sql = "UPDATE requests SET roomNum = $roomNum WHERE index = Max(index)";

Is there something I am doing wrong here..no data is added at all...

Thanks,
Keith

[PHPThorsten]

put the value into single quotes

$sql = "UPDATE requests SET roomNum = '$roomNum' WHERE index = Max(index)";

[klavis]

Still doesnt seem to work...here the whold code block..

<?php
if ($roomNum <> 0) {
@ $db = mysql_pconnect("acidburn.rit.edu", "gcr-klavis", "govrel");
if (!$db) {
echo "Error: Could not connect to database.";
exit;
}

		mysql_select_db("gcr-specialEvents");
		$sql = "UPDATE requests SET roomNum = '$roomNum' WHERE index = Max(index)";;
		$result = mysql_query($sql);
		}
?>

Basically this is a part of is a mutlipage form...and i want to add data to the same row that the last page added to.....maybe theres a completely different and better way to do this but this is what i thought would work...

[crowezr]

What type of error are you getting? Is it SQL or PHP? Based on your entire block of code, the only thing I see is the result line. Since you are only updating, you don't need to set $result equal to anything. You can just do this instead:

mysql_query($sql);

You also have two semi-colons after your query line.