Radio button data failing to be inserted into MySQL.

I have an urgent question please if any one could answer me now coz my representetion for my project is tommorrow.

this my code

Expand|Select|Wrap|Line Numbers

 
<html> 

<head> 

<title>Register</title> 

<script type="text/Javascript"> 

function DisableSelect() {
 
document.form.rd1[0].disabled = false;

document.form.rd1[1].disabled = false;

document.form.rd1[2].disabled = true;

document.form.rd1[3].disabled = true;

document.form.rd1[4].disabled = true;
 
} 

function EnableSelect() { 
 
document.form.rd1[0].disabled = true;

document.form.rd1[1].disabled = true;

document.form.rd1[2].disabled = false;

document.form.rd1[3].disabled = false;

document.form.rd1[4].disabled = false;
 
}
 
</script> 

</head> 
 
<body> 

<form name="form" method="post" action="Register.php"> 

<table border="1" align="center" length=90% width=50%><Caption><h2>Registration</h2></caption>

<tr>

<td align="center">

<input type="radio" name="rb" ID="Radio1" VALUE="Radio1" onblur="DisableSelect()">Bac 1&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp 

<input type="radio" name="rb" ID="Radio2" VALUE="Radio2" onblur="EnableSelect()">Bac 2

</td>

</tr>

<tr>

<td align="center"><input type=radio value=1  name=rd1 id=1>Sientifique&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp 

<input type=radio value=2 name=rd1 id=2>Littéraire <br>
 
<input type=radio value=3 name=rd1 id=3>ES<br>

<input type=radio value=4 name=rd1 id=4>Science De La vie&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp&nbsp 

<input type=radio value=5 name=rd1 id=5>Science General<br>

</td>

</tr>

<tr>

<td align=middle>

  <input type="submit" name="submit" value="S'Inscrire">
 
<input type="reset" name="reset" value="Effacer" align="right"></td></tr>
 
</table>

</form> 

</body> 

</html>

and this is the code of php inorder to insert the information to the table(data base)
but the information within the radio is not working

Expand|Select|Wrap|Line Numbers

 
<?php session_start(); 

include("entete.html");
 
mysql_connect("localhost","root","") or die("Failed to open connection to MySQL server".mysql_error());

$con=mysql_select_db("ecole") or die("Failed to select the database".mysql_error());
 
$us=session_name();
 
$sql= mysql_query("SELECT ID_etu FROM etudiante WHERE userName_etu='$us'");

$user=$_GET["userNom"];
 
$branche=$_POST["rb"];

$spec=$_POST["rd1"];
 
$result=mysql_query("INSERT INTO etudiante ('branche','Specialite') VALUES('$branche', '$spec') where ID_etu='$idetu' ");

if($result)

{

    echo("correct");

}

else

{

    echo("false".mysql_error());

}
 
?>

please any help
Thanks

Sep 30 '10 #1

Subscribe Post Reply

1512

kovik

1,044

Expert 1GB

Please don't hijack other people's threads.
"It's not working" isn't nearly enough information to expect a response more detailed than this one.

Do some debugging, find out where the error was, and then let us know what you are getting as output versus what you want to get as output.

Sep 30 '10 #2

Atli

5,058

Expert 4TB

First thing you should do when a SQL query is not working as it should be, is to print the query and see what is wrong with it.

Expand|Select|Wrap|Line Numbers

 <?php

// Build the query

$sql = "INSERT INTO whatever ...";
 
// Execute the query

$res = mysql_query($sql);
 
// Check if the worked. If not, dump the query to the output.

if(!$res) {

    // Trigger an error, and pass the query along.

    // This would not be shown on properly configured

    // production servers, but will on development servers.

    trigger_error("SQL Query failed: $sql", E_USER_ERROR);

    exit; // Not needed atm, but why risk it :)

}

else {

    // Do stuff with the data, or whatever.

}

?>

Oct 1 '10 #3

by: David | last post by:

Hi, May I know how to create data dynamically in a combo box after clicking on a radio button ? Data are retrieved using a store procedure from a SQL Server. For example : Click Radio Button...

ASP / Active Server Pages

Deselect a Radio Button at Lotus Note

by: Orchid | last post by:

I have 2 fields with Radio button Data Type, and both fields with more than one options. On Field1, I want the user to select option1, then Field2 is shown and able to select. If the user selects...

Microsoft Access / VBA

How to make only one radio button selectable in Datalist?

by: David Hearn | last post by:

I have a datalist that I have inserted a radio button into. The datalist populates with a list of items and each one has a radio button next to it. I need to use the radio button to allow the user...

ASP.NET

Radio Button and focus

by: Stuart | last post by:

I have a page where I utilise the left and right cursor keys to change an image, also on this page is a groups of radio buttons, unfortunately when a radio button is clicked the focus for the...

Javascript

Javascript and asp radio button array

by: kenny8787 | last post by:

Hi, can anyone help here? I have the following code generated from a database, I want to have javascript calculate the costs of the selected items using radio buttons, subtotal the costs and...

Javascript

input through radio button in php

by: sanjay123456 | last post by:

Dear Sir If i am working on sql.php and i am taking radio button forr option of question the i donot understand that when a user click any radio button then how i compre to answer ...

PHP

php and Javascript call to change radio button

by: IchBin | last post by:

I am trying to set the state of a radio button. I do not see what I am doing wrong. Sorry, I am new at this.. I need another set of eyes to look at this snip of code. I am trying to set the radio...

Javascript

How to insert radio button data into mysql

by: pavithraj | last post by:

i m getting error. its not at all inserting into database.showing error like as below Notice: Undefined index: franchise_hours in...

PHP

How to save radio button data in a database and extract it?

by: Remco | last post by:

Hello, I'm designing a simple website for my football team where we can tell each other if we're able to play next weekend. For this website I designed a page with radio buttons with the...

PHP

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Radio button data failing to be inserted into MySQL.

Similar topics