Voting on website

[KhaliDd]

I want people to be able to vote "yes" or "no" on an area of my website. I have my form submission entered into mysql.Now I want to add an area where they can vote and each vote changes the number.So say this the database has 4 areas \[code\]topic - comments my name - id (auto_increment)\[/code\]. I added this to it \[code\]voteY\[/code\] and \[code\]VoteN\[/code\]If they click on the Thumb Up it changes the value of VoteY in the database to 1 and then another user clicks it and it changes to 2 and so on and so forth. The thumbs down is the same exact way but it has to work with this code. I have and I'm not sure if it is possible. If it is, what would I search for on google? The site bugmenot.com has the voting for topics and its linked to there database but I can't figure it out. Here's my script.\[code\]<?php require "manybr.htm" ?><style><?php require "styles.css" ?></style><?php $host="host"; // Host name $username="user"; // Mysql username $password="pass"; // Mysql password $db_name="database"; // Database name $tbl_name="Users"; // Table name // Connect to server and select database. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB"); // select record from mysql $sql="SELECT * FROM $tbl_name order by id desc"; $result=mysql_query($sql) or die(mysql_error());?><table background='images/view.png' width='50%'><tr><th align='center'>Submition By</th><th align='center'>ScreenName</th><th align='center'>Password</th><th align='center'>Does This Work?</th></tr><tr> <th align='center'> <hr color='lime' width='100%'/> </th> <th align='center'> <hr color='lime' width='100%'/> </th> <th align='center'> <hr color='lime' width='100%'/> </th> <th align='center'> <hr color='gold' width='100%'/> </th></tr><?php while($rows=mysql_fetch_array($result)) {?><tr><td background='transparent' align='center'><i><b><? echo $rows['yname']; ?> </b></i></td><td background='transparent' align='center'><i><b><? echo $rows['username']; ?></b></i></td><td background='transparent' align='center'><i><b><? echo $rows['password']; ?></b></i></td><td background='transparent' align='center'><i><b><? echo $rows['works']; ?>% Yes <font color='transparent'>||||</font>&nbsp; <? echo $rows['dworks']; ?>% No</b></i></td></tr><?php } // close while loop ?></table><?php mysql_close(); // close connection; ?><center>\[/code\]I know I should use \[code\]MySQLi\[/code\] or \[code\]PDO\[/code\] but I have not learned that yet.