Voting System On MySql update will not work

[BabulerMn]

Ok so what I have done is made a script to show database and included a voting system that SHOULD update the works, \[code\]dworks\[/code\] in mysql database if someone clicks works it changes the value of works from say 3 to 4 and 4 to 5 if clicked once more same thing for the \[code\]dworks\[/code\] part but it doesn't update the database please help me :Following is my Code : \[code\] <?php require "manybr.htm" ?> <style> body { background-image:url('images/bg.png'); } </style> <?php $host="Host"; // Host name $username="Username"; // Mysql username $password="password"; // Mysql password $db_name="Database Name"; // Database name $tbl_name="tylted"; // 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); ?> <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><th align='center'>Vote</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> <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 background='transpatent' align='center'><i><b> <?php $host="host"; // Host name $username="Username"; // Mysql username $password="password"; // Mysql password $db_name="Database Name"; // Database name $tbl_name="tylted"; // Table name if ( isset( $_POST['works'] ) ) { // query YES +1 //UPDATE tylted SET works = works + 1 $sql="UPDATE `Database Name`.`Username` SET `works` = `works` + 1 WHERE `tylted`.`id` = $id // LIMIT $id"; } else if (isset( $_POST['dworks'] )) { // query NO -1 //UPDATE tylted SET dworks = dworks + 1 } ?> <form method='POST'> <input type='submit' value='http://stackoverflow.com/questions/14049601/works' name='works'> <input type='submit' value='http://stackoverflow.com/questions/14049601/dworks' name='dworks'> </form> <form method='POST'> <input type='submit' value='http://stackoverflow.com/questions/14049601/works' name='works'> <input type='submit' value='http://stackoverflow.com/questions/14049601/no works' name='dworks'> </form> </td> </tr> <?php // close while loop } ?> </table> <?php // close connection; mysql_close(); ?> <center>\[/code\]im trying to get the\[code\] <?php$host="host"; // Host name $username="Username"; // Mysql username $password="password"; // Mysql password $db_name="Database Name"; // Database name $tbl_name="tylted"; // Table name if ( isset( $_POST['works'] ) ){ // query YES +1 //UPDATE tylted SET works = works + 1 $sql="UPDATE `Database Name`.`Username` SET `works` = `works` + 1 WHERE `tylted`.`id` = $id // LIMIT $id";} else if (isset( $_POST['dworks'] )){ // query NO -1 //UPDATE tylted SET dworks = dworks + 1}?><form method='POST'><input type='submit' value='http://stackoverflow.com/questions/14049601/works' name='works'><input type='submit' value='http://stackoverflow.com/questions/14049601/dworks' name='dworks'></form>\[/code\]part to work like a voting poll and each click on WORKS button updates the database 'tylted' so say the vote is 5% WORKS and 2% DOSENT WORK on the button WORKS if its clicked it changes 5 to 6 and clicked once more 6 to 7 and same thing with the other button.Say this is how it looks :\[code\] Does It Work? | VOTE 9% Yes 2% No | {WORKS} {DOSENT WORK}\[/code\]when {WORKS} is clicked it changes it to \[code\] Does It Work? | VOTE 10% Yes 2% No | {WORKS} {DOSENT WORK}\[/code\]and when {DOSENT WORK} is clicked it changes to \[code\] Does It Work? | VOTE 10% Yes 3% No | {WORKS} [DOSENT WORK}\[/code\]so on and so forth do you kinda get it? I understand what he is trying to do but I am not sure how to?