ABOUT INSERTING DATA USING RADIO BUTTONS

[giba]

Hi, Freak Addicted!

 

I have a form to input data into my database, and recently wanted to add a radio button to improve service, but now I can't add anything to my database.

 

(I'd like to make clear that other variables used before were working fine.

 

I am trying to use these radio buttons to insert yes/no to a new field of my database (client):

 

                      Client:<input name="client" type="radio" value="yes" />

                      Non-client:<input name="client" type="radio" value="no" />

                   

And I have this code into my insertion page: (I summarized taking away other fields keeping just the new one here)

 

<?php

mysql_connect($conn);

$cliente=$_POST['client'];

mysql_select_db($database) or die( "Your are not connected to database!");

$query = "INSERT INTO form VALUE ('$client')";

mysql_close();

?>

 

I read a lot of explanations about this but none helped!

 

Please, someone could help me!?

[pikemsu28]

just looking at your code you have a spelling mistake where youre posting to your variable

$cliente = $_POST['client'];

should be

$client = $_POST['client'];

[giba]

Sorry and thanks! That's because I had to translate this to you help me (I'm brazilian client=cliente)

 

[boo_lolly]

are you sure you've setup the right connection to the database? try adding 'OR die(mysql_error())' to the end of your query to see if your problem stems from a connection first.

[giba]

No, It's correctly set and working!

[giba]

Thanks, I solved it. I was with PhpMyAdmin running and testing my script, I don't know why but after I closed it worked!

 

SOLVED

[craygo]

Might be working but unless the form table has only one field in it, this line is wrong

 

$query = "INSERT INTO form VALUE ('$client')";

 

The query will insert that into the first field of the table. Possibly going into the wrong field

 

use this

$query = "INSERT INTO form (`fieldname`) VALUES ('$client')";

 

change fieldname to the field you want to insert it into

 

Ray