RADIO BUTTOn value not being passed to DB?

[brianb]

In my forms I have a RADIO BUTTON signifying a YES or a NO. Yes is set to Y, and NO is set to N.....but that part of the form isn't being passed into my DB. It's just prints 0's.

Any idea what I'm doing wrong?

Any help would be appreciated!

Thanks

[devarticles]

It would be helpful if you actually posted your code.

[brianb]

Ok!

Here's what my form looks like:

<form action="add.php" method="post" name="">
  <table border="0" cellspacing="0" cellpadding="3" align="center" width="100%">
    <tr> 
      <td> 
        <div align="center">
          <p>
            <input type="hidden" name="ID" value="NULL">
            <input type="hidden" value="0" name="listID">
            <input name="email" size="30" value="E-Mail Address" class=input onFocus="if (this.value == 'E-Mail Address'){this.value = ''}" onBlur="if (this.value == ''){this.value = 'E-Mail Address'}">
          </p>
          <p>
            <input name="name" size="30" value="Name" class=input onFocus="if (this.value == 'E-Mail Address'){this.value = ''}" onBlur="if (this.value == ''){this.value = 'E-Mail Address'}">
          </p>
        </div>
      </td>
    </tr>
    <tr> 
      <td> 
        <p align="center"><span class="small">Would you like more info?<br>
          <input type="radio" name="extra" value="Y" checked>
          Yes 
          <input type="radio" name="extra" value="N">
          No </span></p>
      </td>
    </tr>
    <tr> 
      <td> 
        <div align="center"><span class="small"> 
          <input type="submit" value="Go!" name="submit" >
          </span></div>
      </td>
    </tr>
  </table>
</form>

And then here's what my backend looks like:

$query = "SELECT * FROM Data WHERE email='$email' AND listID='$listID'"; 
$result = mysql_query($query); 
if (mysql_num_rows($result) != 0) { 
 echo "This name has already been entered.";
}
else {

$sql = "INSERT INTO Data VALUES( \"$ID\", \"$name\", \"$email\", \"$extra\", \"$listID\" )"; 

$res = mysql_query( $sql );

echo "Your name has been added!";

mysql_close();
}

[devarticles]

what version of php are you running?

run this to find out

<?php

echo phpinfo();

?>

[brianb]

Hi.

I'm running 4.2.2

[eojlin]

first, i advice you to use single quotes instead of double quotes inside your MySQL queries (though it should work fine on most other queries).
e.g.

$sql = "INSERT INTO Data VALUES( \"$ID\", \"$name\", \"$email\", \"$extra\", \"$listID\" )";
/** make it **/
$sql = "INSERT INTO Data VALUES('$ID', '$name', '$email', '$extra', '$listID' )"; 

then, if this part of your code is inside some PHP code body or subpart such as functions or objects your should declare your POST variables as global...

e.g.

global $extra;
$GLOBALS['extra'];

etc.

btw, better make sure that you're inserting the right number of columns in the right fields in MySQL.
or practice doing this:
INSERT INTO <yourtable> SET id='$ID', name='$name', subscriber='$extra'

😉

[intenz]

Here's how add.php should look like

$query = "SELECT * FROM Data WHERE email='$_POST[email]' AND listID='$_POST[listID]'"; 
$result = mysql_query($query); 
if(mysql_num_rows($result) != 0){ 
 echo "This name has already been entered.";
} else {

$sql = "INSERT INTO Data VALUES('$_POST[ID]', '$_POST[name]', '$_POST[email]', '$_POST[extra]', '$_POST[listID]')"; 

$res = mysql_query($sql);

echo "Your name has been added!";

mysql_close();
}

Good luck

[eojlin]

i got a question for intenz, i haven't used PHP 4.2.2 yet, when using super globals (like $_POST) inside strings shouldn't you place your variables inside curly braces "{}"?

$sql = "INSERT INTO Data VALUES('$_POST[ID]', '$_POST[name]', '$_POST[email]', '$_POST[extra]', '$_POST[listID]')";

/** making it **/

$sql = "INSERT INTO Data VALUES('{$_POST[ID]}', '{$_POST[name]}', '{$_POST[email]}', '{$_POST[extra]}', '{$_POST[listID]}')";

/** or if you don't want to use braces {} **/

$sql = "INSERT INTO Data VALUES('".$_POST[ID]."', '".$_POST[name]."', '".$_POST[email]."', '".$_POST[extra]."', '".$_POST[listID]."')";

just a question!
😃

[intenz]

Well, $POST is an array so the var should be between the [] brackets. E.g. $POST['foo']

Did that answer your question?

[theslinky]

eojlin,

yes, you must use the brackets {}:

example:

$string = "<a href=\"{$_SERVER['PHP_SELF']}\">";

also true for POST:

$string = "$myvar has value {$_POST['myvar']}";

-sridhar