PHP - How To Insert Data Into A Table From A Dropdown List

Code: [Select]
   $myusername = $_POST['myusername'];
  mysql_query("INSERT INTO logedin ( username ) VALUES ('$myusername')") OR die("Could not send the message: <br>".mysql_error());


wont insert anything no error's given even
just trying to insert username into the the loged in table yes i know i spelt loged in wrong but i did that on the db lol

HI first timer here so please forgive me if this is in the wrong section.

Anyway, here goes.

I have 2 tables

Table 1
Levels
LevelID
LevelName


Table 2
Members
MemberID
FirstName
LastName
Birthdate
LevelID


I have a form that has the LevelID populated from table 1 with a query.  When I enter all my data and hit submit the data gets written to the members table. However, the LevelID is written as 0 for each and everyone record that I have entered. So the question is what am I missing?

As mentioned I am very new at this so any help would be greatly appreciated. Please see below for my code.

Thanks in advance


<?php
require_once 'dblogin1.php';
$db_server = mysql_connect($db_hostname, $db_username, $db_password);
if (!$db_server) die("Unable to connect to MySQL: " . mysql_error());

mysql_select_db($db_database)
or die("Unable to select database: " . mysql_error());
$sql = "SELECT\n"
    . "levels.LevelID,\n"
    . "levels.LevelName\n"
    . "FROM\n"
    . "levels\n";

   $result = mysql_query($sql) or die(mysql_error());

$options="";

while($row = mysql_fetch_array($result)){
   
 $LevelId=$row["LevelID"];
 $LevelName=$row["LevelName"];
 $options.="<OPTION VALUE=\"$LevelID\">".$LevelName.'</option>';
}
?>
<style type="text/css">
<!--
body p {
   color: #F00;
}
-->
</style>



<table width="500" border="1" align="center" cellpadding="0" cellspacing="1" >
<tr>
<td>
<form name="form1" method="post" action="insert_ac.php">
<table width="100%" border="1" cellspacing="1" cellpadding="3">
<tr>
<td colspan="3"><div align="center">
  <p><strong>Myers Player Registration Form</strong></p>
</div></td>
</tr>
<tr>
<td>First Name</td>
<td><div align="center">:</div></td>
<td><input name="firstname" type="text" id="firstname"></td>
</tr>
<tr>
<td>Last Name</td>
<td><div align="center">:</div></td>
<td><input name="lastname" type="text" id="lastname"></td>
</tr>
<tr>
<td>Birthdate (yyyy-mm-dd)</td>
<td><div align="center">:</div></td>
<td><input name="birthdate" type="text" id="birthdate">
</td>
</tr>

<tr>
<td>Level</td>
<td><div align="center">:</div></td>
<td><select name="LevelID">
      <OPTION VALUE="0">Choose
   <?php echo $options?>



    </select></td>
</tr>
</form>
</td>
</tr>
</table>

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=319161.0

Hi guys,
Im making an event booking/reservation site,
I have 5 tables (Malls, Events, Booking, Reservation and Users) which are all connected and doing fine.
I created a function which is this...

function select_all_events_by_mall_id($mall_id)
{

echo "<table id='event_table'>";
echo "<th>Event Name</th>";
echo "<th>Event Location</th>";
echo "<th>Number of Cars</th>";
echo "<th>Description</th>";
echo "<th>Booked</th>";
echo "<th>Reserved</th>";
echo "<th>Reserved Until</th>";
echo "<th>Vacant</th>";
$events_set = select_all_events($mall_id);


while($events = mysql_fetch_array($events_set))
{
echo "<tr>";
echo "<td>" . $events['event_name'] . "</td>";
echo "<td>" . $events['event_location'] . "</td>";
echo "<td>" . $events['number_of_cars'] . "</td>";
echo "<td>" . $events['description'] . "</td>";
// Booked
echo "<td>";
$booked_set = select_all_booking($events['id']);

while($booked = mysql_fetch_array($booked_set))
{

$user_set = select_all_user_booked($booked['users_id']);
while($user = mysql_fetch_array($user_set))
{
echo $user['company'] . ", " . $user['branch'] . "<br />";
}
}

echo "</td>";

// Reserved
echo "<td>";
echo "<ol>";
$reserved_set = select_all_reservation($events['id']);
while($reserved = mysql_fetch_array($reserved_set))
{
if(empty($reserved['events_id']))
{
echo "No Reservation's ";
}
else
{


$reserved_user = select_all_user_reserved($reserved['users_id']);
while($user_set = mysql_fetch_array($reserved_user))
{

echo "<li>" . $user_set['brand'] . ", " . $user_set['branch'] . "</li>";

}

}
}
echo "</ol>";
echo "</td>";

// Expiration Date
echo "<td>";
echo "<ol>";
$reserved_set = select_all_reservation($events['id']);
while($reserved = mysql_fetch_array($reserved_set))
{

$reserved_user = select_all_user_reserved($reserved['users_id']);
while($user_set = mysql_fetch_array($reserved_user))
{

$exp_date = select_all_expiration_date($user_set['id']);
while($date = mysql_fetch_array($exp_date))
{
echo "<li>" . $date['expiration_date'] . "</li>";
}
}


}
echo "</ol>";
echo "</td>";

//Vacant
echo "<td>";
$vacant_set = select_all_booking($events['id']);
$booking_count = mysql_num_rows($vacant_set);
$reserved_count = mysql_num_rows($reserved_set);
$total_count = $booking_count + $reserved_count;
$vacant = $events['number_of_cars'] - $total_count;
if($vacant < 0)
{
echo "This Event is fully booked";
}
else
{
echo $vacant;
}
echo"</td>";


echo "</tr>";
}
echo "</table>";


}

The function starts by receiving an id from picking a mall name from a select tag.
It works fine, it outputs the data on the page like i want it to, but my problem is that i need a way to
add a submit or any button to each generated row that will, when clicked will insert the event id and user id (who clicked it) to my booking/reservation table as a new row.
I tried adding a form inside my function and saving the event id every loop but when i click the submit button i think it doesn't work (or i made a mistake)..
Sorry if my coding sucks, I'm kinda new in php.
Sorry if its kinda confusing my head is spinning right now from thinking this stuff the whole day..
Thanks in advance for any comments and ideas.

Hello there!

I've been banging my head on  this for a while and I just  can't seem to get it to work properly.

I have a dropdown menu which selects information from table1 using a select statement (this table is called 'lid'). It selects the firstname, lastname and member id from this table and shows it in the dropdown menu. I'm glad I got that part working but the hard thing is inserting the data that the user selects into another table.  So when you select the id member from this dropdown menu it only inserts a blank row into table2 (which is called 'teamlid'). Can you guys help me? How can I insert the id member into my table2? What am I doing wrong here?

Thanks a million! This is my first post so if I'm doing anything wrong, let me know and I'll fix it asap!

My code:

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Boast & Drive</title>
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.css">
    <style type="text/css">
        .wrapper{
            width: 650px;
            margin: 0 auto;
        }
        .page-header h2{
            margin-top: 0;
        }
        table tr td:last-child a{
            margin-right: 15px;
        }
    </style>
</head>
<body>
        <div class="container-fluid">
            <div class="row">
                <div class="col-md-12">
                    <div class="page-header clearfix">
                        <h2 class="pull-left">Teamleden</h2>
                        <div class="btn-toolbar">
                        <a href="read.php" class="btn btn-primary btn-lg pull-right">Terug</a>
                        </div>
                    </div>
                    
                    <?php
                    mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
                    error_reporting(E_ALL);

                    //Verbinding maken met de database
                    require_once "login.php";

                    $sql = "SELECT tl.teamnaam,
                                   tl.tl_ID,
                                   tl.lidnummer,
                                   l.voornaam,
                                   l.achternaam
                            
                            FROM   teamlid tl
                            
                            JOIN    lid l   ON tl.lidnummer = l.lidnummer
                            
                            ORDER BY tl.teamnaam;";  
                    
                    if($result = mysqli_query($conn, $sql)) {
                        if(mysqli_num_rows($result) > 0) {
                            echo "<table class='table table-bordered table-striped'>";
                                echo "<thead>";
                                    echo "<tr>";
                                        echo "<th>Teamnaam</th>";
                                        echo "<th>Tl_ID</th>";
                                        echo "<th>Lidnummer</th>";
                                        echo "<th>Voornaam</th>";
                                        echo "<th>Achternaam</th>";
                                    echo "</tr>";
                                echo "</thead>";
                                echo "<tbody>";
                                while($row = mysqli_fetch_array($result)){
                                    echo "<tr>";
                                        echo "<td>" . $row['teamnaam'] . "</td>";
                                        echo "<td>" . $row['tl_ID'] . "</td>";
                                        echo "<td>" . $row['lidnummer'] . "</td>";
                                        echo "<td>" . $row['voornaam'] . "</td>";
                                        echo "<td>" . $row['achternaam'] . "</td>";
                                        echo "<td>";
                                            echo "<a href='update.php?id=". $row['lidnummer'] ."' title='Gegevens wijzigen' data-															toggle='tooltip'><span class='glyphicon glyphicon-pencil'></span></a>";
                                            echo "<a href='delete.php?id=". $row['lidnummer'] ."' title='Lid verwijderen' data-																toggle='tooltip'><span class='glyphicon glyphicon-trash'></span></a>";
                                        echo "</td>";                                        
                                    echo "</tr>";
                                }
                                echo "</tbody>";
                            echo "</table>";

                            mysqli_free_result($result);
                        } else{
                            echo "<p class='lead'><em>Er zijn geen gegevens om weer te geven.</em></p>";
                        }
                    } else{
                        echo "De volgende fout is gevonden:  " . mysqli_error($conn);
                    }
                    
                    ?>

                    
                    <form name="dropdown" method="post">
                     <div class="page-header clearfix">
                        <h2 class="pull-left">Teamlid toevoegen</h2>
                    </div>           
                    <p>Selecteer hieronder met behulp van het dropdown menu een lid welke je aan bovenstaand team wilt toevoegen</p>
                        
                    <div class="container-fluid">
                        <div class="row">

                        <?php
                        // Variabelen aanmaken en tonen met lege waardes
                        $teamnaam = $lidnummer = '';

                        // Code voor dropdown. Selecteert voornaam, achternaam en lidnummer van tabel lid)
                        $sql = "SELECT voornaam, achternaam, lidnummer FROM lid ORDER BY achternaam";
                        $result = mysqli_query($conn, $sql);

                        echo "<select id='teamLid' name='teamLid'>";
                            echo "<option>--Selecteer Lid--</option>";
                        while ($row = mysqli_fetch_array($result)) {
                            echo "<option value='" . $row['lid'] . "'>" . $row['voornaam'] . "  " . $row['achternaam'] . " " . $row['lidnummer'] . "</option>";
                        }
                        echo "</select>";
                        
                        if 
                        (isset($_POST["id"]) && !empty($_POST["id"])) {
                            $id = $_POST["teamLid"];

                            $stmt = $conn->prepare("INSERT INTO teamlid (teamnaam, lidnummer) VALUES (?,?)");
                            $stmt->bind_param('si', $param_teamnaam, $param_lidnummer);
                            $param_teamnaam         = $teamnaam;
                            $param_lidnummer        = $lidnummer;
                            $stmt->execute();

                        }
                        // Verbinding sluiten
                        mysqli_close($conn);
                        ?>
                            <div>
                                <input type="hidden" name="id" value="<?php echo $id; ?>" />
                                <input type="submit" name="submit" class="btn btn-primary" value="Toevoegen">
                            </div>
                        </div>
                    </div>
                </form>
            </div>  
        </div>
</body>
</html>

 

Hello guys, im using this code atm and it's working, but the new rows created are put in the end of the table. I want them to stack up from the beginning pushing older rows down. What should i do to make that work?


<?php
$con = mysql_connect("localhost","*****","*******");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("ananaz_se", $con);

$sql="INSERT INTO stuff (adult, namn, url)
VALUES
('$_POST[adult]','$_POST[namn]','$_POST[url]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "1 row added";

mysql_close($con)
?>

I have tried several attempts and can get data to select and using echo display it, however, I need to take this data and insert it into the database in a separate table.   I have the following which does hafl the job, can I get some pointers on the rest.  I have looked everywhere and not found a solution, at all.


// Selects the data I need
<?php
mysql_connect("PRIVATE INFO","PRIVATE INFO","PRIVATE INFO") or
    die("Could not connect: " . mysql_error());

mysql_select_db("wpdb");

$result = mysql_query("SELECT ID FROM wp_posts

WHERE post_title LIKE '%future%'
AND post_status = 'publish'
OR post_title LIKE '%option%'
AND post_content LIKE '%fundamental%'
AND post_status = 'publish'

   ORDER BY post_date DESC");

while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{   echo $row['ID'];
   echo "<br />";};

?>



Thought maybe something like the following would work, but am at a loss:
INSERT INTO wp_term_relationships (object_id, term_taxonomy_id, term_order)
       SELECT ID FROM wp_posts

            WHERE post_title LIKE '%future%'
            AND post_status = 'publish'
            OR post_title LIKE '%option%'
            AND post_content LIKE '%fundamental%'
            AND post_status = 'publish'

            ORDER BY post_date DESC

            while ($row = mysql_fetch_array($result, MYSQL_ASSOC))

VALUES
($row['ID'], '25', '0')

Hi guys, im inserting data into the table using drop-down list & multi select list,well it works very well. but i need to make sure i should not insert same StudentID & CourseID twice. here my code for you could anyone tell me pls where should i write code to check existing data?
<?php
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }


  mysql_select_db("uni", $con)or trigger_error('MySQL error: ' . mysql_error());
$result  = mysql_query("SELECT * FROM student") or trigger_error('MySQL error: ' . mysql_error());


echo '<select name="sid">';

while($row = mysql_fetch_array($result))
{

    echo '<option value="' . $row['StudentID'] . '">' . $row['StudentName'] . '</option>';
}

echo '</select>';

// ----------------

?>
</div>
<div class="style41" id="Layer7">

<?php
$result  = mysql_query("SELECT * FROM course") or trigger_error('MySQL error: ' . mysql_error());


echo '<select name ="cid[]" multiple="multiple" size="10">';

while($row = mysql_fetch_array($result))
{
    echo '<option value="' . $row['CourseID'] . '">' . $row['CourseName'] . '</option>';
}

echo '</select>';
mysql_close($con);
?>


------------------------------------
<?php

$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
 
  mysql_select_db("uni", $con)or trigger_error('MySQL error: ' . mysql_error());
   
 if (!empty($_POST['sid']) && !empty($_POST['cid'])) 
{
    $ct = 0;
    $student = $_POST['sid'];
    foreach ($_POST['cid'] as $key => $course)
    {
     $sql = "INSERT INTO take (StudentID, CourseID) VALUES('".mysql_real_escape_string($student)."',
 '".mysql_real_escape_string($course)."')";
     $query = mysql_query($sql) or trigger_error('MySQL error: ' . mysql_error());
     if (mysql_affected_rows() > 0){$ct++;}
     }
    echo $ct . ' rows added.';
 }  

mysql_close($con);

?>

Hi,
Hope somebody can help me because I am relatively new to PHP and I am currently unsure how to implement the following:

Let's assume I have a table like this id_number, name, data1, data2. When displayed on HTML page:
Column id_number should be hidden.
Column name is a link. When you click on this column then value stored in id_number should be used in a query to database. Result should be displayed below the link on the same page. When clicked again data should hide.

I have some idea how to toggle visibility with a simple javascript function. How do i populate the table with hidden data and then extract it later on?

Any help or suggestions are appreciated. Thanks.

I'm creating a report page and can't figure out how to retrieve multiple rows from a table and display them in html. There are 5 data elements in each row and I'm thinking that using a form in the html might be the best way as I'm totally ignorant about tables in html. I'm a newbie to php and can't figure out how to accomplish this. Here's the code that I have so far:

<?php
$filename = NULL;
session_start();
// start of script every time.

//  setup a path for all of your canned php scripts
$php_scripts = '../php/'; // a folder above the web accessible tree
//  load the pdo connection module  
require $php_scripts . 'PDO_Connection_Select.php';

//*******************************
//   Begin the script here
// Connect to the database

if (!$con = PDOConnect("foxclone")):
{
    echo "Failed to connect to database" ;
    exit;
}
else:
{
    $sql = 'SELECT COUNT(IP_ADDRESS) FROM download WHERE FILENAME IS NOT NULL'; 

    $sql1 = 'Update  download t2, ip_lookup t1 set t2.country = t1.country, t2.area = t1.area, t2.city = t1.city where ((t2.IP_ADDRESS) = (t1.start_ip) OR (t2.IP_ADDRESS) > (t1.start_ip)) AND ((t2.IP_ADDRESS) = (t1.end_ip) OR (t2.IP_ADDRESS) < (t1.end_ip)) AND (t2.FILENAME is not null and t2.country is null)';

    $sql2 = 'SELECT (IP_ADDRESS, FILENAME, country, area, city) from download where FILENAME is not null';

// Update the table
    $stmt = $con->prepare($sql1);
    $stmt->execute();  

// Get count of rows to be displayed in table
    $stmt = $con->prepare($sql);
    $stmt->execute() ;
    $cnt = $stmt->fetch(PDO::FETCH_NUM);

// retrieve one row at a time
    $i = 1;
    while($i <= $cnt){
      $stmt = $con->prepare($sql2);
      $row->execute(array(''));  // Do I need an array here?
// from here on, I'm lost

    $i++;

I'd appreciate any guidance you can provide or understandable tutorials you can point me to.

Larry     

I am not sure if the title is correct; I tried my best. I'm a PHP/MySQL beginner and I really need some help. I have a small script that I am using for sending SMS. I recently added a phonebook. The problem with the phonebook right now is that it's available to all users, i.e. they can all update and delete all rows. What I would like to do is make it so that each user can update and delete only their own contacts. I have a table call contacts. Inside that table there is first name, last name, company and phonenumber. How can I accomplish this with PHP & MySQL?

CREATE TABLE IF NOT EXISTS `contacts` (
`contact_id` int(10) NOT NULL AUTO_INCREMENT,
`firstname` varchar(255) NOT NULL,
`lastname` varchar(255) NOT NULL,
`company` varchar(255) NOT NULL,
`cell_no` text NOT NULL,
PRIMARY KEY (`contact_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

CREATE TABLE IF NOT EXISTS `users` (
`user_id` int(11) NOT NULL AUTO_INCREMENT,
`users_name` varchar(30) NOT NULL,
`uname` varchar(30) NOT NULL,
`u_pass` varchar(60) NOT NULL,
`utype` varchar(30) NOT NULL,
`timezone` varchar(30) NOT NULL,
`uapi_user` varchar(30) NOT NULL,
`uapi_pass` varchar(60) NOT NULL,
PRIMARY KEY (`user_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;

<?php
if (isset($_POST['submit'])){
    //form has been submitted1
    $firstname  = trim($_POST['firstname']);
    $lastname   = trim($_POST['lastname']);
    $company    = trim($_POST['company']);
    $cellno = trim($_POST['cell_no']);

    if($firstname == ''){
        echo '<div class="alert alert-danger">First Name is not Valid!</div>';
        exit;
    }elseif($lastname == ''){   
        echo '<div class="alert alert-danger">Last Name is not Valid!</div>';
        exit;
    }elseif($company == ''){    
        echo '<div class="alert alert-danger">Company is not Valid!</div>';
        exit;
    }elseif($cellno == ''){ 
        echo '<div class="alert alert-danger">Cellphone Number is not Valid!</div>';
        exit;

    }else{

        $query = "Select cell_no from contacts where cell_no = '".$cellno."' ";
        $result = mysql_query($query);
        if (!mysql_num_rows($result)) {

        $sql = "INSERT INTO contacts(firstname, lastname, company, cell_no)
                            values('{$firstname}','{$lastname}', '{$company}', '{$cellno}')";
        $result = mysql_query($sql);
        confirm_query($result);

        //echo '<div class="alert alert-success">Successfully added.</div>';
        //exit;
        ?>
                    <script type="text/javascript">
            window.location = "contact_list.php";
        </script>
    <?php
    }
    else{

        echo '<div class="alert alert-danger">Username. already exist!.</div>';
        echo '<p><a href="new_contact.php" class="btn btn-success"> Back </a></p>';
        exit;

    }}

}else{
    $firstname  = "";
    $lastname   = "";
    $company    = "";
    $cellno = "";
}

?>

Hi Team,

I have a php page where I have taken the same userid and linked in the next page and also used show/hide function.

I am able to see that the userid is linking but when i submit the data is not getting insert and also no error

Please help

below is the Tower.php file.

Code: [Select]
<!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=iso-8859-1" />
<title>BHP2</title>
<style type="text/css">
<!--
#Layer1 {
position:absolute;
width:1005px;
height:578px;
z-index:1;
left: 157px;
top: 1px;
background-color: #993399;
}
#Layer2 {
position:absolute;
width:939px;
height:114px;
z-index:1;
left: 35px;
top: 35px;
}
#Layer3 {
position:absolute;
width:451px;
height:169px;
z-index:2;
left: 270px;
top: 296px;
}
#Layer4 {
position:absolute;
width:608px;
height:68px;
z-index:2;
left: 273px;
top: 10px;
}
#Layer5 {
position:absolute;
left:82px;
top:188px;
width:973px;
height:52px;
z-index:2;
}
#Layer6 {
position:absolute;
width:243px;
height:106px;
z-index:2;
left: 68px;
top: 43px;
}
.style1 {
font-size: xx-large;
font-style: italic;
}
.style2 {font-size: 52px}
#Layer7 {
position:absolute;
width:824px;
height:271px;
z-index:2;
left: 44px;
top: 237px;
}
.style4 {
font-size: xx-large;
font-style: italic;
font-weight: bold;
color: #FF9933;
}
#Layer8 {
position:absolute;
width:800px;
height:139px;
z-index:2;
left: 31px;
top: 67px;
}
#Layer9 {
position:absolute;
width:610px;
height:30px;
z-index:2;
left: 34px;
top: 70px;
}
#Layer10 {
position:absolute;
width:611px;
height:25px;
z-index:2;
left: 33px;
top: 110px;
}
#Layer11 {
position:absolute;
width:614px;
height:30px;
z-index:2;
left: 33px;
top: 152px;
}
#Layer12 {
position:absolute;
width:615px;
height:29px;
z-index:2;
left: 32px;
top: 193px;
}
#Layer13 {
position:absolute;
width:187px;
height:35px;
z-index:2;
left: 318px;
top: 239px;
}
-->
</style>
</head>

<body>

<div id="Layer1">
<form id="form5" name="form5" method="link" action="Insert.php">
  <div id="Layer2">
    <div id="Layer6"><img src="AZimages/BHP-Billiton-logo.jpg" width="235" height="65" alt="BHP" /></div>
    <h1 align="center">&nbsp;</h1>
    <div class="style1" id="Layer4">     
      <h1 align="center" class="style2">BHP DATA TRACKER </h1>
    </div>
  </div>
  <div id="Layer7">
    <div align="center"><span class="style4">SELECT THE TOWER BELOW </span>
      <div id="Layer13">
       
  <input type="hidden" name="empid" value="<?php echo $_GET['id']; ?>" size="20">
          <input type="hidden" name="date" value="<?php echo date("Y-m-d H:i:s"); ?>" >
       <input type="submit" name="B1" value="Start !" />
     
      </div>
      <div id="Layer12">
        <div align="left">
         
            <input name="rad1" type="radio" value="RF" id="rad1"  />
            <label >RF</label>
         
        </div>
      </div>
      <div id="Layer11">
        <div align="left">
           <input name="rad1" type="radio" value="ISAP" id="rad1" />
            <label >ISAP</label>
         
        </div>
      </div>
      <div id="Layer10">
        <div align="left">
            <input name="rad1" type="radio" value="GSD" id="rad1" checked="checked" />
            <label >GSD</label>
         
        </div>
      </div>
      <div id="Layer9">
        <div align="left">
            <input name="rad1" type="radio" id="rad1" value="CSD"  />
            <label>CSD</label>
          </p>
        </div>
      </div>
      <br />
    </div>
  </div>
 </form>
</div>
</body>
</html>


Below is the insert.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">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>BHP DATA SUMBIT</title>
<?php
include ("count.php");
?>

<?php
if(isset($_GET['action']))
{
$action = $_GET['action'];
if ($action = 'yes')
{
include ("Connection.php");
$PName = $_POST['rad11'];
$Date = date("Y-m-d H:i:s");
$empidno = $_POST['idd'];
$qsdate = $_POST['testinput'];
$cb1 = $_POST['chkbox1'];
$cb2 = $_POST['chkbox2'];
$cb3 = $_POST['chkbox3'];
$cb4 = $_POST['chkbox4'];
$cb5 = $_POST['chkbox5'];
$Com = $_POST['textfield2'];
$dd1 = $_POST['textfield'];
$dd2 = $_POST['select'];
$dd3 = $_POST['select2'];
$dd4 = $_POST['textfield4'];
$dd5 = $_POST['textfield3'];
$dd6 = $_POST['select3'];
$sev = $_POST['radio1'];
$olddate = $_POST['odate'];
$pname = $_POST['radiobutton'];

$query="INSERT INTO bhp ticketinformation (`userid`, 
`processname`, 
`begindate`, 
`dateposted`, 
`CALL`, 
`EMAIL`, 
`NEW`, 
`EXISTING`, 
`Piroty`, 
`MTICKET`, 
`Services`, 
`group1`,
`group2`, 
`Icall`, 
`Tcreatedtime`, 
`comment`) 
VALUES ( '$empidno' , '$pname' , '$olddate' ,  '$Date' ,  '$cb1' , '$cb2' , '$cb3' , '$cb4' , '$sev' , '$dd1' , '$dd2' , '$dd3' , '$dd4' , '$dd5' , '$dd6' , '$Com')";
mysql_query($query);
Header('location:tower.php?id=' . $empidno);
}
}
?>
<head>
<style type="text/css">
<!--
#Layer1 {
position:absolute;
width:1023px;
height:592px;
z-index:1;
left: 167px;
top: 2px;
background-color: #993399;
}
#Layer2 {
position:absolute;
width:939px;
height:114px;
z-index:1;
left: 59px;
top: 3px;
}
#Layer3 {
position:absolute;
width:451px;
height:169px;
z-index:2;
left: 270px;
top: 296px;
}
#Layer4 {
position:absolute;
width:608px;
height:68px;
z-index:2;
left: 273px;
top: 10px;
}
#Layer5 {
position:absolute;
left:82px;
top:188px;
width:973px;
height:52px;
z-index:2;
}
#Layer6 {
position:absolute;
width:238px;
height:69px;
z-index:2;
left: 68px;
top: 43px;
}
.style1 {
font-size: xx-large;
font-style: italic;
}
.style2 {font-size: 52px}
#Layer7 {
position:absolute;
width:979px;
height:209px;
z-index:2;
left: 32px;
top: 181px;
}
#Layer8 {
position:absolute;
width:194px;
height:36px;
z-index:1;
left: 25px;
top: 15px;
}
#Layer9 {
position:absolute;
width:178px;
height:37px;
z-index:2;
left: 249px;
top: 13px;
}
#Layer10 {
position:absolute;
width:193px;
height:34px;
z-index:3;
left: 443px;
top: 13px;
}
#Layer11 {
position:absolute;
width:204px;
height:32px;
z-index:4;
left: 670px;
top: 15px;
}
#Layer12 {
position:absolute;
width:195px;
height:40px;
z-index:5;
left: 28px;
top: 73px;
}
#Layer13 {
position:absolute;
width:182px;
height:38px;
z-index:6;
left: 250px;
top: 76px;
}
#Layer14 {
position:absolute;
width:197px;
height:36px;
z-index:7;
left: 446px;
top: 77px;
}
#Layer15 {
position:absolute;
width:214px;
height:35px;
z-index:8;
left: 670px;
top: 77px;
}
#Layer16 {
position:absolute;
width:315px;
height:45px;
z-index:9;
left: 16px;
top: 144px;
}
#Layer17 {
position:absolute;
width:343px;
height:43px;
z-index:10;
left: 339px;
top: 145px;
}
#Layer18 {
position:absolute;
width:258px;
height:48px;
z-index:11;
left: 708px;
top: 146px;
}
#Layer19 {
position:absolute;
width:321px;
height:60px;
z-index:3;
left: 59px;
top: 419px;
}
#Layer20 {
position:absolute;
width:197px;
height:41px;
z-index:1;
left: 27px;
top: 6px;
}
#Layer21 {
position:absolute;
width:193px;
height:36px;
z-index:2;
left: 249px;
top: 7px;
}
#Layer22 {
position:absolute;
width:207px;
height:38px;
z-index:3;
left: 453px;
top: 7px;
}
#Layer23 {
position:absolute;
width:237px;
height:36px;
z-index:4;
left: 677px;
top: 9px;
}
#Layer24 {
position:absolute;
width:245px;
height:45px;
z-index:5;
left: 399px;
top: 2px;
}
#Layer25 {
position:absolute;
width:99px;
height:31px;
z-index:6;
left: 288px;
top: 121px;
}
#Layer26 {
position:absolute;
width:87px;
height:29px;
z-index:7;
left: 439px;
top: 123px;
}
-->
</style>

<script language="JavaScript" >
function showInfo()
{
var elem = document.getElementById('verify');
if(document.testform.select3.value == "verify" || document.testform.select3.value == "verify1" )
{
elem.style.display="inline";
}
else
{
elem.style.display="none";
}
}
</script>

<script language="JavaScript">

function validator()
{
if(document.testform.Checkbox1.checked == false &&
document.testform.Checkbox2.checked == false &&
document.testform.Checkbox3.checked == false &&
document.testform.Checkbox4.checked == false)
{
alert ('You did not choose any of the checkboxes!');
return false;
}
if (document.testform.textfield.value =="")
  {
  alert("Enter Max Ticket No");
  return false;
  }
if (document.testform.select.value == "" || document.testform.select.value == "SELECT SERVICE DROP DOWN")
{
alert ('Select the SELECT SERVICE DROP DOWN');
return false;
}
if (document.testform.select2.value == "" || document.testform.select2.value == "SELECT RG GROUP")
{
alert ('SELECT RG GROUP');
return false;
}
if (document.testform.select3.value == "" || document.testform.select3.value == "SELECT GROUPS")
{
alert ('SELECT GROUPS');
return false;
}
if (document.testform.textfield2.value =="")
  {
  alert("Comments Feild is Empty.If there are no Comment then type NA(Not Applicable)");
  return false;
  }
if (document.testform.Checkbox1.checked == false)
document.getElementById("chkbox1").value = "";
else
document.getElementById("chkbox1").value = "EMAIL";
if (document.testform.Checkbox2.checked == false)
document.getElementById("chkbox2").value = "";
else
document.getElementById("chkbox2").value = "NEW";
if (document.testform.Checkbox3.checked == false)
document.getElementById("chkbox3").value = "";
else
document.getElementById("chkbox3").value = "EXISTING";
if (document.testform.Checkbox4.checked == false)
document.getElementById("chkbox4").value = "";
else
document.getElementById("chkbox4").value = "CALL";
alert('Record has been posted in the portal');
}
</script>
</head>

<body>
<div id="Layer1">
  <div id="Layer2">
    <div id="Layer6"><img src="AZimages/BHP-Billiton-logo.jpg" width="235" height="67" alt="BHP" /></div>
    <h1 align="center">&nbsp;</h1>
    <div class="style1" id="Layer4">     
      <h1 align="center" class="style2">BHP DATA TRACKER </h1>
    </div>
  </div>
  <div id="Layer7">

         <form method="POST" action="Insert.php?action=yes&&id=<?php echo $_GET['empid']; ?>" name="testform" onSubmit="return validator();">

    <div id="Layer8">
     
          <input type="checkbox" id="Checkbox4" name="checkbox4" value="CALL" />
          CALL</label>
     
    </div>
    <div id="Layer9">
   
        <label>
          <input type="checkbox" id="Checkbox1" name="checkbox1" value="EMAIL" />
          EMAIL</label>
   
    </div>
    <div id="Layer10">
 
        <label>
          <input type="checkbox" id="Checkbox2" name="checkbox2" value="NEW" />
          NEW</label>
     
    </div>
    <div id="Layer11">

        <label>
          <input type="checkbox" id="Checkbox3" name="checkbox3" value="EXISTING" />
          EXISTING</label>
 
    </div>
    <div id="Layer12">
   
        <label>
          <input name="radio1" type="radio" id="radio1" value="P1" checked="checked" />
          P1</label>
 
    </div>
    <div id="Layer13">
     
        <label>
          <input name="radio1" type="radio" id="radio1" value="P2" />
          P2</label>
     
    </div>
    <div id="Layer14">
 
        <label>
          <input name="radio1" type="radio" id="radio1" value="P3" />
          P3</label>
   
    </div>
    <div id="Layer15">
     
        <label>
          <input name="radio1" type="radio" id="radio1" value="P4" />
          P4</label>
     
    </div>
    <div id="Layer16">
 
        <label>MAXIMUM TICKET
          <input type="text" name="textfield" />
        </label>
     
    </div>
    <div id="Layer17">

        <label>SERVICE DROP DOWN
          <select name="select" style="width: 162px; height: 23px">
            <option>SELECT SERVICE DROP DOWN</option>
            <option>OTHER(FW)</option>
            <option>1 MESSAGE</option>
            <option>1 MOBILITY</option>
            <option>1 VOICE</option>
            <option>1 SAP</option>
            <option>1 PORTAL</option>
            <option>1 COLLAB</option>
            <option>1 GSAP</option>
            <option>1 SECURITY</option>
            <option>1 WAN</option>
            <option>S DOMAIN</option>
            <option>1 AUTH</option>
            <option>1 DOCM</option>
            <option>1 REMOTE</option>
          </select>
        </label>
     
    </div>
    <div id="Layer18">
     
        <label>RG GROUP
          <select name="select2" style="width: 162px; height: 23px">
            <option>SELECT RG GROUP</option>
            <option>I-AM-AU-AM-HWT</option>
            <option>I-EUS-IN-CSC-DSK-CSD</option>
            <option>I-EUS-IN-CSC-DSK-GSD</option>
            <option>I-EUS-GB-DCS-BHPVICFW</option>
            <option>I-ITS-AU-HW</option>
            <option>I-SRM-AU-IAM-LAMU</option>
            <option>I-ITS-AU-SW</option>
            <option>C-BHP-AU-CSC-LSD-NONBRG</option>
            <option>C-BHP-AU-ACN-AQM</option>
          </select>
        </label>
     
    </div>
  </div>
  <div id="Layer19">
 
   <label>SELECT GROUPS
          <select name="select3"  onchange="showInfo()" style="width: 162px; height: 23px">
            <option value="none" >SELECT GROUPS</option>
<option value="verify">TP</option>
            <option value="verify1">OA</option>
            <option>OC</option>
            <option>OTHERS</option>
      </select>
    </label>
    <div id="verify" style="display:none;">

<br/><br/>
<label>INCOMING CALL/EMAIL TIME
          <input type="text" name="textfield4" />
      </label>
<br/><br/>
<label>MAXIMO TICKET CREATED TIME
          <input type="text" name="textfield3" />
      </label>
</div>

    <div id="Layer24">
   
        <label>COMMENTS
          <input type="text" name="textfield2" />
        </label>
     
  </div>
    <div id="Layer26">
   
        <input name="Reset" type="reset" id="Reset" value="Reset" />
     
  </div>
    <div id="Layer25">
        <input type="submit" name="Submit" value="Submit" />
<input type="hidden" name="chkbox1" id="chkbox1" />
    <input type="hidden" name="chkbox2" id="chkbox2" />
    <input type="hidden" name="chkbox3" id="chkbox3" />
    <input type="hidden" name="chkbox4" id="chkbox4" />
<input type="hidden" name="chkbox5" id="chkbox5" />
<input type="hidden" name="rad11" id="rad11" value="<?php echo $_GET['rad1']; ?>" />
     <input type="hidden" name="idd" id="idd" value="<?php echo $_GET['empid']; ?>" />
<input type="hidden" name="odate" id="odate" value="<?php echo $_GET['date']; ?>" />
  </form>
 
</div>
</div>
</div>
</body>
</html>


THANKS IN ADVANCED

Hi..

Sorry, if I need to repost my problem in while loop. cause until now I can't resolve my problem in saving all data from while loop.

I have this code StockRequisition.php where FORM was displayed.

<?php                                                                          
   error_reporting(0);
   date_default_timezone_set("Asia/Singapore"); //set the time zone  
$con = mysql_connect('localhost', 'root','');

if (!$con) {
    echo 'failed';
    die();
}

mysql_select_db("mes", $con);
$sr_date =date('Y-m-d H:i:s');

        $sql = "SELECT sr_number FROM stock_requisition ORDER BY sr_date DESC LIMIT 1";
        $result = mysql_query($sql, $con);
        
        if (!$result) {
            echo 'failed'; 
            die();
        }
        $total = mysql_num_rows($result);
        if ($total <= 0) {
            $currentSRNum = 1;
            $currentYear  = (int)(date('y'));
            $currentMonth = (int)(date('m'));
            $currentDay = (int)(date('d'));

            $currentSRYMD = substr($row['sr_number'], 0, 6);
            $currentYMD = date("ymd");
            if ($currentYMD > $currentSRYMD) 
            {  
                $currentSRNum = 1;
            } 
            else 
            {  
                $currentSRNum += 1;
            }        
            
        } 
        else {
//------------------------------------------------------------------------------------------------------------------
            // Stock Number iteration.... 
            $row = mysql_fetch_assoc($result);
            
            $currentSRNum = (int)(substr($row['sr_number'],0,3));
            
            $currentSRYear  = (int)(substr($row['sr_number'],2,2));
            $currentSRMonth = (int)(substr($row['sr_number'],0,2));
            $currentSRNum = (int)(substr($row['sr_number'],6,4));
            $currentYear  = (int)(date('y'));
            $currentMonth = (int)(date('m'));
            $currentDay = (int)(date('d'));

            $currentSRYMD = substr($row['sr_number'], 0, 6);
            $currentYMD = date("ymd");
            if ($currentYMD > $currentSRYMD) 
            {  
                $currentSRNum = 1;
            } 
            else 
            {  
                $currentSRNum += 1;
            }                                           
        }
//------------------------------------------------------------------------------------------------------------------         
        $yearMonth = date('ymd');    
        $currentSR = $currentYMD . sprintf("%04d", $currentSRNum);   
?>
<html>
<title>Stock Requisition</title>
<head>
<link rel="stylesheet" type="text/css" href="kanban.css">

<script type="text/javascript">
function save_sr(){
    var sr_date = document.getElementById("sr_date").value;
    var sr_number = document.getElementById("sr_number").value;
    var Items1 = document.getElementById("Items1").value;
    var SubItems = document.getElementById("SubItems").value;
    var ItemCode = document.getElementById("ItemCode").value;
    var DemandedQty = document.getElementById("DemandedQty").value;
    var UoM = document.getElementById("UoM").value;
    var Class = document.getElementById("Class").value;
    var Description = document.getElementById("Description").value;
    var BINLocation = document.getElementById("BINLocation").value;
    var RequestedBy = document.getElementById("RequestedBy").value;
    var ApprovedBy = document.getElementById("ApprovedBy").value;
    var ReceivedBy = document.getElementById("ReceivedBy").value;
    var IssuedBy = document.getElementById("IssuedBy").value;
    
    document.stock_requisition.action="StockRequisitionSave.php?sr_date="+sr_date+"&sr_number="+sr_number+"&Items1="+Items1+
    "&SubItems="+SubItems+"&ItemCode="+ItemCode+"&DemandedQty="+DemandedQty+"&UoM="+UoM+"&Class="+Class+"&Description="+
    Description+"&BINLocation="+BINLocation+"&RequestedBy="+RequestedBy+"&ApprovedBy="+ApprovedBy+"&ReceivedBy="+ReceivedBy+
    "&IssuedBy="+IssuedBy;
    document.stock_requisition.submit();
    alert("Stock Requisition data save.");
    window.location = "StockRequisition.php";
}
</script>
</head>
<body>
<form name="stock_requisition" action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<div id="ddcolortabs">
<ul>
<li> <a href="ParameterSettings.php" title="Parameter Settings"><span>Parameter Settings</span></a></li>
<li style="margin-left: 1px"><a href="kanban_report.php" title="WIP Report"><span>Wip Report</span></a></li>
<li><a href="fsn.php" title="Finished Stock Note"><span>WMS FG</span></a></li>
<li id="current"><a href="StockRequisition.php" title="WMS RM"><span>WMS RM</span></a></li>

</ul>
</div>

<div id="ddcolortabs1">
<ul>
<li><a href="ReceivingMaterials.php" title="Receiving Materials"><span>Receiving Materials</span></a></li>
<li><a href="Shelving.php" title="Shelving"><span>Shelving</span></a></li>
<li id="current"><a href="StockRequisition.php" title="Stock Requisition"><span>Stock Requisition</span></a></li>
</ul>
</div>

<div id="SR_date">
<label>Date :</label>
<input type="text" name="sr_date" value="<?php echo $sr_date; ?>" size="16" readonly="readonly" style="border: none;">    
</div>
<div id="SR_number">
<label>SR# :</label>
<input type="text" name="sr_number" value="<?php echo $currentSR; ?>" size="10" readonly="readonly" style="font-weight: bold; border: none;">
<br/> 
</div> 
   <div>
<table>
<thead>
<th>Items</th>
<th>Sub Items</th>
<th>Item Code</th>
<th>Demanded Qty</th>
<th>UoM</th>
<th>Class</th>
<th>Description</th>
<th>BIN Location</th>
</thead>
<?php
$sql = "SELECT DISTINCT Items FROM bom_subitems ORDER BY Items";
$res_bom = mysql_query($sql, $con);

while($row = mysql_fetch_assoc($res_bom)){
    
    $Items = $row['Items'];
echo "<tr>
        <td style='border: none;font-weight: bold;'>&nbsp;<input type='name' value='$Items' name='Items' id='Items' readonly = 'readonly' style = 'border:none;width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='5'></td>
        </tr>";       
     
$sql = "SELECT Items, SubItems, ItemCode, UoM, Class, Description, BINLocation FROM bom_subitems WHERE Items = '$Items' ORDER BY Items"or die(mysql_error());

$res_sub = mysql_query($sql, $con);  
 
 while($row_sub = mysql_fetch_assoc($res_sub)){

     $Items1 = $row_sub['Items'];
     $SubItems = $row_sub['SubItems'];
     $ItemCode = $row_sub['ItemCode'];
     $UoM = $row_sub['UoM'];
     $Class = $row_sub['Class'];
     $Description = $row_sub['Description'];
     $BINLocation = $row_sub['BINLocation'];         
     
    echo "<tr>
        <td style='border: none;'>&nbsp;<input type='hidden' value='$Items1' id='Items1' name='Items1'></td>
        <td style='border: none;'>&nbsp;<input type='text' name='SubItems' value='$SubItems' id='SubItems' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>
        <td style='border: none;'>&nbsp;<input type='text' name='ItemCode' value='$ItemCode' id='ItemCode' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>
        <td style='border: none;'><center><input type='text' name='DemandedQty' id='DemandedQty' value='' size='7'></center></td>
        <td style='border: none;' size='3'>&nbsp;<input type='text' name='UoM' value='$UoM' id='UoM' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='3'></td>
        <td style='border: none;'>&nbsp;<input type='text' name='Class' value='$Class' id='Class' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>
        <td style='border: none;'>&nbsp;<input type='text' name='Description' value='$Description' id='Description' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>
        <td style='border: none;'>&nbsp;<input type='text' name='BINLocation' value='$BINLocation' id='BINLocation' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='10'></td>     
        </tr>";
}
}   
   
               
?>
</table>
</div>
<?php
   $RequestedBy = array('AAA', 'BBB', 'CCC', 'DDD');
   
   $ApprovedBy = array('EEE', 'FFF', 'GGG', 'HHH');
   
   $ReceivedBy = array('III', 'JJJ', 'KKK', 'LLL');
   
   $IssuedBy = array('MMM', 'NNN', 'OOO', 'PPP'); 

?>

 <div id='Requested_By'>
<label>Requested By:</label>
 <select name="RequestedBy">
 <option value="Select">Select</option>
 <option value="AAA" <?php if($_POST['RequestedBy'] == 'AAA') echo "selected='selected'"; ?>>AAA</option>
  <option value="BBB" <?php if($_POST['RequestedBy'] == 'BBB') echo "selected='selected'"; ?>>BBB</option>
 <option value="CCC" <?php if($_POST['RequestedBy'] == 'CCC') echo "selected='selected'"; ?>>CCC</option>
  <option value="DDD" <?php if($_POST['RequestedBy'] == 'DDD') echo "selected='selected'"; ?>>DDD</option>
 </select>
</div>

<div id='Approved_By'>
<label>Approved By:</label>
<select name="ApprovedBy">
<option name='Select'>Select</option>
<option value="EEE" <?php if($_POST['ApprovedBy'] == 'EEE') echo "selected='selected'"; ?>>EEE</option>
  <option value="FFF" <?php if($_POST['ApprovedBy'] == 'FFF') echo "selected='selected'"; ?>>FFF</option>
 <option value="GGG" <?php if($_POST['ApprovedBy'] == 'GGG') echo "selected='selected'"; ?>>GGG</option>
  <option value="HHH" <?php if($_POST['ApprovedBy'] == 'HHH') echo "selected='selected'"; ?>>HHH</option>
</select>
</div>

<div id='Received_By'>
<label>Issued By:</label>
<select name="IssuedBy">
<option name='Select'>Select</option>
<option value="III" <?php if($_POST['ReceivedBy'] == 'III') echo "selected='selected'"; ?>>III</option>
  <option value="JJJ" <?php if($_POST['ReceivedBy'] == 'JJJ') echo "selected='selected'"; ?>>JJJ</option>
 <option value="KKK" <?php if($_POST['ReceivedBy'] == 'KKK') echo "selected='selected'"; ?>>KKK</option>
  <option value="LLL" <?php if($_POST['ReceivedBy'] == 'LLL') echo "selected='selected'"; ?>>LLL</option>

</select>
</div>

<div id='Issued_By'>
<label>Received By:</label>
<select name="ReceivedBy">
<option name='Select'>Select</option>
<option value="MMM" <?php if($_POST['IssuedBy'] == 'MMM') echo "selected='selected'"; ?>>MMM</option>
  <option value="NNN" <?php if($_POST['IssuedBy'] == 'NNN') echo "selected='selected'"; ?>>NNN</option>
 <option value="OOO" <?php if($_POST['IssuedBy'] == 'OOO') echo "selected='selected'"; ?>>OOO</option>
  <option value="PPP" <?php if($_POST['IssuedBy'] == 'PPP') echo "selected='selected'"; ?>>PPP</option>

</select>
</div>

<div id="save_btn">
<input type="button" name="button" value="save" onClick="save_sr()">
</div>
</form>
</body>
</html>



and here is StockRequisitionSave.php
code for saving data to database :


<?php                                                                          
   error_reporting(0);
   date_default_timezone_set("Asia/Singapore"); //set the time zone  
$con = mysql_connect('localhost', 'root','');

if (!$con) {
    echo 'failed';
    die();
}

mysql_select_db("mes", $con);
$sr_date = $_POST['sr_date'];
$sr_number = $_POST['sr_number'];
$Items1 = $_POST['Items1'];
$SubItems = $_POST['SubItems'];
$ItemCode = $_POST['ItemCode'];
$DemandedQty = $_POST['DemandedQty'];
$UoM = $_POST['UoM'];
$Class = $_POST['Class'];
$Description = $_POST['Description'];
$BINLocation = $_POST['BINLocation'];
$RequestedBy = $_POST['RequestedBy'];
$ApprovedBy = $_POST['ApprovedBy'];
$ReceivedBy = $_POST['ReceivedBy'];
$IssuedBy = $_POST['IssuedBy'];

$sql = "INSERT INTO stock_requisition
(sr_date, sr_number, Items, SubItems, ItemCode, DemandedQty, UoM, Class, Description, BINLocation, RequestedBy,
ApprovedBy, ReceivedBy, IssuedBy)
VALUES
('$sr_date', '$sr_number', '$Items1', '$SubItems', '$ItemCode', '$DemandedQty', '$UoM', '$Class', '$Description',
'$BINLocation', '$RequestedBy', '$ApprovedBy', '$ReceivedBy', '$IssuedBy')
";  

$result = mysql_query($sql, $con);            
?>


the problem is only the last data was save.

I will attach my form.

I hope somebody can help me..
I really don't know how can I save all data from form into my database.

Thank you so much for your understanding and help.

Hi,

I am trying to call the data from Mysql but I am getting an empty drop down list, this is the code:


mysql:

Code: [Select]
create table years
(  yearID integer auto_increment,
   year varchar(30),
   primary key (yearID)
);

insert into years (yearID, year) values ('1', '2007-2008');
insert into years (yearID, year) values ('2', '2008-2009');
insert into years (yearID, year) values ('3', '2009-2010');
insert into years (yearID, year) values ('4', '2010-2011');
insert into years (yearID, year) values ('5', '2011-2012');
insert into years (yearID, year) values ('6', '2012-2013');

PHP:

Code: [Select]
<?php require_once('../Connections/connection.php'); ?>
<?php
 
$result = @mysql_query( "select yearID, year, from sss.years");

print "<p>Select a year:\n";
print "<select name=\"yearID\">\n";
while ($row = mysql_fetch_assoc($result)){
$yearID = $row[ 'yearID' ];
$year = $row[ 'year' ];
print "<option value=$yearID>$year\n";
}
print "</select>\n";
print "</p>\n";
?>

Thank you!

I'm pulling data from an xml file and I'm getting a lot of duplicates. How can I remove the duplicates from the query?

Code: [Select]
foreach($xml->category->subcategory as $category){
echo $category[id];
}//end foreach