updating a value in a column

[Brad]

Im trying to automate a poll on my site and have the results posted on a page. I have the values returning from the database but I can't seem to be able to increment the value when the vote button is pressed. What am I doing wrong in this?!
Poll---------------------
<form name="uselesspoll" action="updatepoll.php" method="get">

	Street: <input type="radio" name="poll" value="0"><br>
	Vert: <input type="radio" name="poll" value="1"><br>
	<input type="submit" value="Vote!">

updatepoll.php--------------------------------
<?
//database name and stuff

if (!$db)
{
echo "Cannot connect to database!";
}

		if ($poll == "0")
		{
		mysql_select_db("somedb_adrenaline-magazine_com");
		$query = "Update Poll_adrenaline-magazine_com Set Street = 'sum(Street) + 1'";
		$result = mysql_query($query);
		if ($result)
		echo "Vote entered, <a href='uselesspoll.php'>Click here</a> to go back";

		}
		elseif ($poll == "1")
		{
		mysql_select_db("somedb_adrenaline-magazine_com");
		$query = "Update Poll_adrenaline-magazine_com Set Ramp = 'sum(Ramp) + 1'";
		$result = mysql_query($query);
		if ($result)
		echo "Vote entered, <a href='uselesspoll.php'>Click here</a> to go back";
		}
		elseif ($poll == "")
		{
		Echo "Vote failed,  <a href='uselesspoll.php'>Click here</a> to go back";
		}
	?>	

Any thoughts, I'm really confused!

[jpmoriarty]

i dont get why you're using sum(variable)? surely youve got one field that counts the number of votes? in that case, you just have to add 1 to it to count the vote. You'd only use sum() if you wanted to sum all the values in that table. and you cant add anything to sum() since sum() would be the sum of the other values in the table - it's an automatically calculated value:

value 1: 2
value 2: 3
value 3: 7
sum() = 12

what would sum()+1 mean in this case? the sum of the numbers is still 12

all you need is a table with one field in it. if they vote for it, then add one to it.

job done.

[Brad]

I figured out another way to do it. It totals and displays the total rows in the table and when you vote it adds a row. This works for the time being. Thanks for the help!