Calling This!

[Dethman]

Hello Im trying to Call this:

 	if (isset($_POST['mypath'])) {
  	$choice = $_POST['loyalty_choice'];
	$sql = "UPDATE `user_users` SET `loyalty` = '$choice' WHERE `userid` = '{$user['userid']}'"; 	
		header ('Location: worship.php?str=Your Path Has Been Chosen!');
	}

 

When you use this:

<form name="loyalty" action="" method="post">
            <select name="loyalty_choice">
           	 <option value="0" selected >Choose Your Path</option>
             <option value="1"  >Chaos</option>
             <option value="2"  >Order</option>
             <option value="3"  >Life</option>
             <option value="4"  >Death</option>
            </select>
            <input type="submit" name="mypath" value="Worship This Caste!">
</form>

It dosnt update the SQL DB

[rajivgonsalves]

you forgot mysql_query

 

this

$sql = "UPDATE `user_users` SET `loyalty` = '$choice' WHERE `userid` = '{$user['userid']}'"; 	

 

should be

 

$sql = "UPDATE `user_users` SET `loyalty` = '$choice' WHERE `userid` = '{$user['userid']}'"; 	
mysql_query($sql) or die("Cannot Execute:".mysql_error());