[RESOLVED] value not updating using radio button

[FantasyLink]

form page:

<form action="process.php" method="POST">
<input type="hidden" id="task" name="task" value="">
<table width="300" cellpadding="0" cellspacing="0" border="0">
<tr>
    <td class="text"> <?=$value3?>:</td>
    <td><INPUT TYPE="RADIO" NAME="conference1" VALUE="$value3">  </td>
</tr>
<tr bgcolor="#cccccc">
    <td class="text"> <?=$value6?>:</td>
    <td><INPUT TYPE="RADIO" NAME="conference1" VALUE="<$value6">  </td>
</tr>
<tr>
    <td> </td>
</tr>
<tr>
    <td class="text"> <?=$value5?>:</td>
    <td><INPUT TYPE="RADIO" NAME="conference2" VALUE="<?=$value5?>">  </td>
</tr>
<tr bgcolor="#cccccc">
    <td class="text"> <?=$value4?>:</td>
    <td><INPUT TYPE="RADIO" NAME="conference2" VALUE="<?=$value4?>">  </td>
</tr>
</table>
<br>
<input type="submit" name="Submit" value="SUBMIT"></form>

process.php

\\ update conference1
if (conference1 == "$value6"){
   $sql ="UPDATE league SET conference1='$value6'";
   $result = mysql_query($sql);
   if(!$result){
      echo "Error inserting your information into MySQL' mysql_error()";
   } else{
   if (conference1 == "$value3"){
   $sql ="UPDATE league SET conference1='$value3'";
   $result = mysql_query($sql);
   if(!$result){
      echo "Error inserting your information into MySQL' mysql_error()";
   }
}
}
}
\\ update conference2
if (conference1 == "$value6"){
   $sql ="UPDATE league SET conference1='$value6'";
   $result = mysql_query($sql);
   if(!$result){
      echo "Error inserting your information into MySQL' mysql_error()";
   } else{
   if (conference1 == "$value3"){
   $sql ="UPDATE league SET conference1='$value3'";
   $result = mysql_query($sql);
   if(!$result){
      echo "Error inserting your information into MySQL' mysql_error()";
   }
}
}
}
\\ all is good, output the result
echo '<center><br><span class="text">Success! Result has been updated!</span></br></center>';
include 'endb.php';
?>

Problem: I am getting "Success! Result has been updated!" but I am not getting change in the database. I think my value is wrong or mysql is not accepting dollar sign as value? I want to insert $value# in the database as it is, and my database column is set as varchar and null.

Or am I missing something else?

[msk_1980]

all these:
<tr>
<td class="text"> <?=$value3?>:</td>
<td><INPUT TYPE="RADIO" NAME="conference1" VALUE="$value3"> </td>
</tr>

should be changed to:

<tr>
<td class="text"> <?=$value3?>:</td>
<td><INPUT TYPE="RADIO" NAME="conference1" VALUE="<?php echo $value3; ?>"> </td>
</tr>

where are you getting the values of $value3.
I would recommand using the <?php ?> rather than short version of <? ?>.

Other thing you can do would be to check if some radio button is checked or not.

if ( isset( conference1 ) )
{
//do your stuff here
}
else
{
//display error message
}

One more thing:

\\ update conference1
if (conference1 == "$value6"){
   $sql ="UPDATE league SET conference1='$value6'";
   $result = mysql_query($sql);
   if(!$result){
      echo "Error inserting your information into MySQL' mysql_error()";
   } else{
   if (conference1 == "$value3"){
   $sql ="UPDATE league SET conference1='$value3'";
   $result = mysql_query($sql);
   if(!$result){
      echo "Error inserting your information into MySQL' mysql_error()";
   }
}
}
}

the if else conditions are wrongly coded.

\\ update conference1
if (conference1 == "$value6")
    {
         $sql ="UPDATE league SET conference1='$value6'";
        $result = mysql_query($sql);
         if(!$result)
              {
               echo "Error inserting your information into MySQL' mysql_error()";
               }
     }
 else
    {
     if (conference1 == "$value3")
           {
           $sql ="UPDATE league SET conference1='$value3'";
           $result = mysql_query($sql);
           if(!$result){
                   echo "Error inserting your information into MySQL' mysql_error()";
             }
       }
  }

the better you organize your code the easy is it to find errors .

[FantasyLink]

msk_1980,

Thank for the reply, but it didn't really help because your code produced same result. Maybe it is a unorthodox code that distrub you so much that you mean to say my code was wrote sloppy instead of "wrong"? You asked where I am getting my value? From a SELECT command on top of the page, which is not shown here. Then I assigned result to $value# making it easier to use than $row['$value#'];

As I mentioned in my first post, I am not getting value updated into the database, which remain unanswered.

So next time, I will be sure to organize my code more neatly so it will read easily for you fellas.

[msk_1980]

Try to print the value of conference1 and conference2 to give an idea of what values are being passed from the form. Can you post the previous code too, the one of SELECT statement.

Try to trace out which if condition is being executed.