radio button help

[hope]

hi all, hope all be fine and happy

i need to insert the resulting data of the radio button to my data base

my code is:

 <form id="form1" name="form1" method="post" action="register_PMP_Action.php" onsubmit="return validate()">
              <span style="font-size:11.0pt;font-family:&quot;normal Verdana&quot;">Please 
provide us your contact details:</span></b></span></u></p>
<p class="MsoNormal" style="margin-left: 10; margin-top: 0; margin-bottom: 0" dir="ltr" align="left">&nbsp;</p>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="76%" id="AutoNumber1" dir="ltr">
  <tr>
    <td width="16%" dir="ltr" align="left">
    <p style="margin-top: 0; margin-bottom: 0; margin-left:10" dir="ltr"><span style="font-size: 11pt">
    Name *</span></td>
    <td width="84%">
    <p dir="ltr" style="margin-top: 0; margin-bottom: 0; margin-left:10" align="left">
    <span style="font-size: 11pt"><input MAXLENGTH="255" SIZE="30" NAME="cust_name"></span></td>
  </tr>
  <tr>
    <td width="16%" dir="ltr" align="left">
    <p style="margin-top: 0; margin-bottom: 0; margin-left:10" dir="ltr"><span style="font-size: 11pt">
    E-mail address *</span></td>
    <td width="84%">
    <p dir="ltr" style="margin-top: 0; margin-bottom: 0; margin-left:10" align="left">
    <span style="font-size: 11pt">
    <input TYPE="TEXT" MAXLENGTH="255" SIZE="30" NAME="cust_email"></span></td>
  </tr>
  <tr>
    <td width="16%" dir="ltr" align="left">
    <p style="margin-top: 0; margin-bottom: 0; margin-left:10" dir="ltr"><span style="font-size: 11pt">
    Phone </span></td>
    <td width="84%">
    <p dir="ltr" style="margin-top: 0; margin-bottom: 0; margin-left:10" align="left">
    <span style="font-size: 11pt">
    <input TYPE="TEXT" MAXLENGTH="255" SIZE="30" NAME="cust_phone"></span></td>
  </tr>
</table>
<p class="MsoNormal" dir="ltr" style="margin-top: 0; margin-bottom: 0; margin-left:10" align="left">&nbsp;</p>
<p class="MsoNormal" style="margin-left: 10; margin-top: 0; margin-bottom: 0" dir="ltr" align="left">
<u><b><span style="font-size: 11.0pt; font-family: normal Verdana">2. </span>
</b><span dir="LTR"><b>
<span style="font-size:11.0pt;font-family:&quot;normal Verdana&quot;">How you reached us?</span></b></span></u></p>
<p class="MsoNormal" dir="ltr" style="margin-top: 0; margin-bottom: 0; margin-left:10" align="left">
<span style="font-size: 11pt">
<input TYPE="radio" NAME="How_you_reached_us" VALUE="face_book">facebook</span></p>
<p class="MsoNormal" dir="ltr" style="margin-top: 0; margin-bottom: 0; margin-left:10" align="left">
<span style="font-size: 11pt">
<input TYPE="radio" NAME="How_you_reached_us" VALUE="Internet_search">Internet search</span></p>
<p class="MsoNormal" dir="ltr" style="margin-top: 0; margin-bottom: 0; margin-left:10" align="left">
<span style="font-size: 11pt">
<input TYPE="radio" NAME="How_you_reached_us" VALUE="Email_shot">E-mail shot</span></p>
<p class="MsoNormal" dir="ltr" style="margin-top: 0; margin-bottom: 0; margin-left:10" align="left">
<span style="font-size: 11pt">
<input TYPE="radio" NAME="How_you_reached_us" VALUE="net_forums">Forums</span></p>
<p class="MsoNormal" dir="ltr" style="margin-top: 0; margin-bottom: 0; margin-left:10" align="left">
<span style="font-size: 11pt">
<input TYPE="radio" NAME="How_you_reached_us" VALUE="net_friends">Friends</span></p>
<p class="MsoNormal" dir="ltr" style="margin-top: 0; margin-bottom: 0; margin-left:10" align="left">
<span style="font-size: 11pt">
<input TYPE="radio" NAME="How_you_reached_us" VALUE="google_ads">Ads</span></p>
<p class="MsoNormal" dir="ltr" style="margin-top: 0; margin-bottom: 0; margin-left:10" align="left">
<span style="font-size: 11pt">
<input TYPE="radio" NAME="How_you_reached_us" ID="other_How_you_reached_us" value="Others">Other 
(please, mention)
<input MAXLENGTH="255" SIZE="30" onFocus="Javascript:document.myForm.other_How_you_reached_us.checked=true" NAME="How_you_reached_us"></span></p>
<p class="MsoNormal" dir="ltr" style="margin-top: 0; margin-bottom: 0; margin-left:10" align="left">
<b><span style="font-size: 11pt; color: #FF8000">&nbsp;</span></b></p>
 <!-- submit button, function verify need to be called when we press submit button -->

          <div class="buttonSubmit"><input type="submit" value="Submit" onclick="return verify(this);"/>
            </div>
 </form>
         

and the action code is:

<?php
	$cust_name=$_POST['cust_name'];

$cust_email=$_POST['cust_email'];

$cust_phone=$_POST['cust_phone'];

$face_book=$_POST['face_book'];

$Internet_search=$_POST['Internet_search'];

$Email_shot=$_POST['Email_shot'];

$net_forums=$_POST['net_forums'];

$net_friends=$_POST['net_friends'];

$google_ads=$_POST['google_ads'];

$Others=$_POST['Others'];
?>
<?php


$string = "INSERT INTO user (name,email,phone,facebook,Internetsearch,Emailshot,netforums,netfriends,googleads,others) VALUES ('".$cust_name."','".$cust_email."','".$cust_phone."','".$face_book."','".$Internet_search."','".$Email_shot."','".$net_forums."','".$net_friends."','".$google_ads."','".$Others."')";

the problem is it inserts the name, email and phone in my database and didn't insert the results of choosing from the radio button items.

[bradgrafelman]

What have you tried? The PHP code above doesn't reference the radio element at all, so of course the chosen value doesn't get inserted anywhere.

Also note that user-supplied data should never be placed directly into a SQL query, else your code will be vulnerable to SQL injection attacks and/or just plain SQL errors. Instead, you must first sanitize the data with a function such as [man]mysql_real_escape_string/man (for string data).

[Weedpacket]

Radio buttons, like all other form elements, are referred to by their name, not their various values.

And in your database, why would you need a separate column for each possible value, when only one of them at a time will mean anything?

[hope]

i did what u told me.i created 1 column in my database called: How you reached us.

but now it doesn't insert any thing on my database at all.

here is my code:

<div class="form">
<table border="0" align="right" cellpadding="10">
<tr>
<td><div class="joinUs">
<p>Register Now</p>

<!-- ** Validation Fields Script Start ***-->

<script language="JavaScript">
<!-- Hide from older browsers
function checkform()
{
String.prototype.trim = function() {
return this.replace(/^{\s+|\s+$/g,"");}
}

if (document.myForm.Name.value.trim()=="" || document.myForm.Name.value.trim().length<=5)
{
alert('Please fill the Name field - with more than 5 letters');
document.myForm.Name.value=""
document.myForm.Name.focus()
return false;
}

}
//-->
</script>

<!-- ** Validation Fields Script End ****-->

        <form id="form1" name="form1" method="post" action="register_PMP_Action.php" onsubmit="return validate()">
          <span style="font-size:11.0pt;font-family:&quot;normal Verdana&quot;">Please 

provide us your contact details:</span></b></span></u></p>
<p class="MsoNormal" style="margin-left: 10; margin-top: 0; margin-bottom: 0" dir="ltr" align="left">&nbsp;</p>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="76%" id="AutoNumber1" dir="ltr">
<tr>
<td width="16%" dir="ltr" align="left">
<p style="margin-top: 0; margin-bottom: 0; margin-left:10" dir="ltr"><span style="font-size: 11pt">
Name </span></td>
<td width="84%">
<p dir="ltr" style="margin-top: 0; margin-bottom: 0; margin-left:10" align="left">
<span style="font-size: 11pt"><input MAXLENGTH="255" SIZE="30" NAME="cust_name"></span></td>
</tr>
<tr>
<td width="16%" dir="ltr" align="left">
<p style="margin-top: 0; margin-bottom: 0; margin-left:10" dir="ltr"><span style="font-size: 11pt">
E-mail address </span></td>
<td width="84%">
<p dir="ltr" style="margin-top: 0; margin-bottom: 0; margin-left:10" align="left">
<span style="font-size: 11pt">
<input TYPE="TEXT" MAXLENGTH="255" SIZE="30" NAME="cust_email"></span></td>
</tr>
<tr>
<td width="16%" dir="ltr" align="left">
<p style="margin-top: 0; margin-bottom: 0; margin-left:10" dir="ltr"><span style="font-size: 11pt">
Phone </span></td>
<td width="84%">
<p dir="ltr" style="margin-top: 0; margin-bottom: 0; margin-left:10" align="left">
<span style="font-size: 11pt">
<input TYPE="TEXT" MAXLENGTH="255" SIZE="30" NAME="cust_phone"></span></td>
</tr>
</table>
<p class="MsoNormal" dir="ltr" style="margin-top: 0; margin-bottom: 0; margin-left:10" align="left">&nbsp;</p>
<p class="MsoNormal" style="margin-left: 10; margin-top: 0; margin-bottom: 0" dir="ltr" align="left">
<u><b><span style="font-size: 11.0pt; font-family: normal Verdana">2. </span>
</b><span dir="LTR"><b>
<span style="font-size:11.0pt;font-family:&quot;normal Verdana&quot;">How you reached us?</span></b></span></u></p>
<p class="MsoNormal" dir="ltr" style="margin-top: 0; margin-bottom: 0; margin-left:10" align="left">
<span style="font-size: 11pt">
<input TYPE="radio" NAME="How_you_reached_us" VALUE="face_book">facebook</span></p>
<p class="MsoNormal" dir="ltr" style="margin-top: 0; margin-bottom: 0; margin-left:10" align="left">
<span style="font-size: 11pt">
<input TYPE="radio" NAME="How_you_reached_us" VALUE="Internet_search">Internet search</span></p>
<p class="MsoNormal" dir="ltr" style="margin-top: 0; margin-bottom: 0; margin-left:10" align="left">
<span style="font-size: 11pt">
<input TYPE="radio" NAME="How_you_reached_us" VALUE="Email_shot">E-mail shot</span></p>
<p class="MsoNormal" dir="ltr" style="margin-top: 0; margin-bottom: 0; margin-left:10" align="left">
<span style="font-size: 11pt">
<input TYPE="radio" NAME="How_you_reached_us" VALUE="net_forums">Forums</span></p>
<p class="MsoNormal" dir="ltr" style="margin-top: 0; margin-bottom: 0; margin-left:10" align="left">
<span style="font-size: 11pt">
<input TYPE="radio" NAME="How_you_reached_us" VALUE="net_friends">Friends</span></p>
<p class="MsoNormal" dir="ltr" style="margin-top: 0; margin-bottom: 0; margin-left:10" align="left">
<span style="font-size: 11pt">
<input TYPE="radio" NAME="How_you_reached_us" VALUE="google_ads">Ads</span></p>
<p class="MsoNormal" dir="ltr" style="margin-top: 0; margin-bottom: 0; margin-left:10" align="left">
<span style="font-size: 11pt">
<input TYPE="radio" NAME="How_you_reached_us" ID="other_How_you_reached_us" value="Others">Other
(please, mention)
<input MAXLENGTH="255" SIZE="30" onFocus="Javascript:document.myForm.other_How_you_reached_us.checked=true" NAME="How_you_reached_us"></span></p>
<p class="MsoNormal" dir="ltr" style="margin-top: 0; margin-bottom: 0; margin-left:10" align="left">
<b><span style="font-size: 11pt; color: #FF8000">&nbsp;</span></b></p>
<!-- submit button, function verify need to be called when we press submit button -->

          <div class="buttonSubmit"><input type="submit" value="Submit" onclick="return verify(this);"/>
            </div>

               </form>

and my action code is:

<?php
require_once 'configl.php';
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>register_PMP_Action</title>
</head>

<body>


<?php
	$cust_name=$_POST['cust_name'];

$cust_email=$_POST['cust_email'];

$cust_phone=$_POST['cust_phone'];

$How_you_reached_us=$_POST['How_you_reached_us'];

?>
<?php


$string = "INSERT INTO user (name,email,phone,How you reached us) VALUES ('$cust_name','$cust_email','$cust_phone','$How_you_reached_us')";


mysql_query($string,$connection);
mysql_close();

echo "<div id=\"shift\">";
	echo "<center><h1>You Have Been <br/>";
	echo "Added Succesfully To Our DataBase";
	echo "<script>
		<!--
		timeout = '1000'; // milliseconds/1000th of a sec
		window.onload = setTimeout(myRedirect, timeout); // ensure we load the whole page

		function myRedirect() {

		window.location = \"index.asp\";
		}
		//-->
		</script>"	;		
	echo "</h1>";
?>

now the result is: he gives me the msg you have been added Succesfully to our database.

then when i check my Database i found nothing at all. 🙁

[bradgrafelman]

If the column in the MySQL table is really called How you reached us, you either need to a) think of a better column name (keep it short; spaces, punctuation, etc. should be avoided), or b) surround the column name in backticks so that MySQL realizes that entire string is a single identifier.

[hope]

@: thanks alot 🙂

but when i enter my data it doesn't save the choosed radio button i checked, it only leave it blank not null

i need it to type on of my choices: facebook or email or......
🙁

[hope]

ohhh, no one can help me?!!!