[SOLVED] Radio Group Not Saving Value in DB

[CyberWoolf]

I'm hoping someone can help me out here.  I am stumped.  I cannot get my radio group to save to mysql db.  All the other fields will save fine.  If I enter the value manually in the db, it works but will not save.  It actually clears the info in there  ???

 

FORM

 

switch($sc_address_btn) 
{ 
   case "addy1": $checkaddy1 = "checked"; break; 
   case "addy2": $checkaddy2 = "checked"; break; 
   case "addy3": $checkaddy3 = "checked"; break; 
}

<table width="250" border="0" cellpadding="0" cellspacing="0" class="form">
  <form id="form1" name="form1" action="form.php" method="POST">
    
    <tr>
      <td width="74">Address 1<br />
          <input type="radio" name="sc_address_btn" value="addy1" <?=$checkaddy1 ?> >      </td>
      <td width="176" colspan="2"><textarea name="Address" rows="4" class="single" id="Address">some addy 1</textarea></td>
    </tr>
    <tr>
      <td width="74">Address 2<br />
          <input type="radio" name="sc_address_btn" value="addy2"  <?=$checkaddy1 ?> >      </td>
      <td colspan="2"><textarea name="Address2" rows="4" class="single" id="Address2">addy3</textarea></td>
    </tr>
    <tr>
      <td width="74">Address 3<br />
          <input type="radio" name="sc_address_btn" value="addy3"  <?=$checkaddy1 ?> >      </td>
      <td colspan="2"><textarea name="Address3" rows="4" class="single" id="Address3">addy2</textarea></td>
    </tr>
    
    
    <tr>
      <td width="74"> </td>
      <td colspan="2" align="left" style="margin:10px 0 0 0;"><input style="width:145px;" type="submit" name="submit" id="submit" value="Submit">      </td>
    </tr>
    <tr>
      <td width="74"> </td>
      <td colspan="2"> </td>
    </tr>
  </form>
  </div>
  
</table>

 

PHP

 

My post

 

$sc_address_btn = $_POST["sc_address_btn"];

[gbunny]

Is the value from your form making it to the next page?

Try echoing out the post value for your radio button.

 

If it is please post your insert statement.

[CyberWoolf]

no.. its not taking info from another page.  Just the one page and the form.php file to post the data and send an email.  :-/

 

echo "sc_address_btn = {$_POST['sc_address_btn']}";

 

I tried doing that, but it didn't help.  I tried it at after the submit button and then on the form.php file too

 

Thanks for responding so quick :-)

[gbunny]

do

echo $_POST['sc_address_btn'];

[gbunny]

One other thing I think you need semi colons when you echo the checked variable

 

you have

<?=$checkaddy1 ?>

 

and you should have

<?=$checkaddy1; ?>

 

[CyberWoolf]

Thanks.. I added the semi colons.

 

Where should I add the echo?  Do I replace the current post function with it or just add it in addtion?

[gbunny]

You can just add it in addition to what you have.

That will simply tell you if the value is getting submitted or not.

[CyberWoolf]

Nothing comes up 

[kenrbnsn]

At the start of your processing script add:

<?php
echo '<pre>' . print_r($_POST,true) . '</pre>';
?>

 

This will show what is being passed to the script from the form.

 

I also noticed you're using short tags "<?=" to echo the values, try using "<?php echo" instead.

 

 

Ken

[CyberWoolf]

Well... now I'm even more baffled..

 

This was the result

[sc_address_btn] => addy1

 

Thanks.. I added the echo and stopped using short tags

[CyberWoolf]

Woo!  Solved the problem... it had nothing to do with what was posted.  Stupid typo in the insert command!    :-\

 

Thanks for helping guys :-)  And thanks for being so nice!  Usually they are pretty snippy and mean when you ask questions in forums..