PHP - A Question Regarding <select> And <option> Value.

I'm trying to pass php select option value to another page through url.but it's not working.please help me.   member.php

<?php
mysql_connect("localhost","root","") or die(mysql_error());
mysql_select_db("nordfxlk_member")or die(mysql_error());
$result = mysql_query("SELECT id,ugroup FROM ugroups"); 


?>


<select name='group' id='group' >
<?php 
while ($line = mysql_fetch_array($result)) {
echo '<option value=' . $line['ugroup'] . '>' . $line['ugroup'] . '</option>';


}?>
</select>
<a href="db_sql/add_group.php?ugroup=<?php echo $line['ugroup'] ;?>"> click</a> 

add_group.php    

include('../limoconfig.php');
if(!isset($_SESSION['adminuserid']) )
{
header('Location:../index.php');
}
else
{ 


$ugroup = $_GET['ugroup'];
/*$id = $_GET['id'];*/


$acc_status = "update users set ugroup='".$ugroup."' where id=1931";


echo $acc_status;
$rate = db::getInstance()->exec($acc_status); 


header('Location:../test.php'); 


}
}

I've been using an option that's a state, an example would be South Carolina or North Dekota.
In the url the $_GET var turns it into South+Carolina or North+Dekota.
Is this common and okay across different Browsers? I've tried ie and firefox and the + sign is addded but I was wondering if they're just designed to be as idiot proof as possible.

Thanks

Hey guys there is probably a simple fix to this but i am just not seeing it    ... Im createing a form that has error catching and self submitting valuse. I am trying to use a for loop to create all of the values and if the form is returned with an error then the correct values will still be filled out but i cant seem to get this loop to work. Every time i submit the form it doesnt matter what option i select it always comes back with the last one in the list or 30 in this case.

the problem code is below.. Any help would be appreciated.

Code: [Select]

<?php
for($i=1; $i<=30; $i++){
echo'<option value="'.$i.'"';
if(isset($_POST['petsAge'])== $i){ echo ' selected="selected"';}
echo '>'.$i.'</option>';
}
?>

Hi..

I got problem in logic on my problem in select option.

Here is my scenario.

I have select option which has a compound list:

example:

P28
P30
P32
P33
P35


and I have tables which has a total count of
compound that was already transact.

for example I already transact
10 P28 compound.

it will save in kanban_checker table field Total.

and I have parameter_settings table which has the maximum and minimum per compound:

fields----------data
P28------------P28
P28_max-----10
P28_min------6
P30------------P28
P30_max-----10
P30_min------6
P32------------P28
P32_max-----10
P32_min------6
P33------------P28
P33_max-----10
P33_min------6


now the logic is:

if P28 total = P28_max then notify that he already reach the maximum..it will not produce P28 because he already reach the maximum.

if P28 total = P28_min then produce P28.

same with other compound.

Now, I got a problem in coding and logic, because in the select option I'm not the one who code it.. I just one who need to add the additional function..

here is the code for select option and the function that was created by other,

Code: [Select]
$smarty->assign('text_name1','Compound Code');
 $smarty->assign('compoundIndexValue', array('0',  'P28',  'P30',  'P32',  'P33',  'P35',  'P35M',  'P38',  'P40', 'P41',  'P42',  'P43', 'P46', 'P47', 'PXX', 'P35W'));

 <tr>
            <td class="tdMainText">{$text_name1}</td>
           
            <td> <select class="tdMainElement" id="selCompound"  onchange="isSelected('selCompound','txtLotCode')" onclick="clearNotify()" onblur="this.focus();" onkeypress="return false">{html_options values=$compoundIndexValue output=$names selected="0"} </select> </td>
            </tr>

<script type="text/javascript">
function isSelected(obj1, obj2) {

     if (!document.getElementById(obj1).disabled) {
         document.getElementById(obj1).disabled = true;
     }       
             
     if (document.getElementById('clear').disabled) {
         document.getElementById('clear').disabled = false; //enable it
     }

     if ((document.getElementById('chkDownGrade') != null)) {
        if (!document.getElementById('chkDownGrade').disabled) {     
           document.getElementById('chkDownGrade').disabled = true;
        }
     }
     
     
     if (document.getElementById(obj2).disabled) {
         document.getElementById(obj2).disabled = false;
     }
         document.getElementById(obj2).focus();
         document.getElementById(obj2).focus();
         
     //notify("Gain Maximum Total"); 

}

function disable() {
             if (!document.getElementById('clear').disabled) {
                 document.getElementById('clear').disabled = true;
             }
             else { 
                 document.getElementById('clear').disabled = false;
             }

}

function clearNotify() {
   
   if (document.getElementById('notice') != null) {
      document.getElementsByTagName('body')[0].removeChild(document.getElementById('notice')) //>> clear the box    }
   }
</script>


and here is the code that I tried to add:

Code: [Select]
$compound = mysql_real_escape_string($_POST['compound']);
        $sql = "SELECT
                P28, P28_max, P28_min,
                P30, P30_max, P30_min,
                P32, P32_max, P32_min,
                P33, P33_max, P33_min,
                P35, P35_max, P35_min,
                P35M, P35M_max, P35M_min,
                P35W, P35W_max, P35W_min,
                P38, P38_max, P38_min,
                P41, P41_max, P41_min,
                P42, P42_max, P42_min,
                P43, P43_max, P43_min,
                P46, P46_max, P46_min
                FROM parameter_settings";
        $res_pcode = mysql_query($sql, $con);
       
        while($row = mysql_fetch_assoc($res_pcode)){
            $P28 = $row['P28'];
            $P28_max = $row['P28_max'];
            $P28_min = $row['P28_min'];
       
            $P30 = $row['P30'];
            $P30_max = $row['P30_max'];
            $P30_min = $row['P30_min'];
           
            $P32 = $row['P32'];
            $P32_max = $row['P32_max'];
            $P32_min = $row['P32_min'];
           
            $P33 = $row['P33'];
            $P33_max = $row['P33_max'];
            $P33_min = $row['P33_min'];
           
            $P35 = $row['P35'];
            $P35_max = $row['P35_max'];
            $P35_min = $row['P35_min'];
           
            $P35M = $row['P35M'];
            $P35M_max = $row['P35M_max'];
            $P35M_min = $row['P35M_min'];
           
            $P35W = $row['P35W'];
            $P35W_max = $row['P35W_max'];
            $P35W_min = $row['P35W_min'];
           
            $P38 = $row['P38'];
            $P38_max = $row['P38_max'];
            $P38_min = $row['P38_min'];
           
            $P41 = $row['P41'];
            $P41_max = $row['P41_max'];
            $P41_min = $row['P41_min'];
           
            $P42 = $row['P42'];
            $P42_max = $row['P42_max'];
            $P42_min = $row['P42_min'];
           
            $P43 = $row['P43'];
            $P43_max = $row['P43_max'];
            $P43_min = $row['P43_min'];
           
            $P46 = $row['P46'];
            $P46_max = $row['P46_max'];
            $P46_min = $row['P46_min'];
           
            $P47 = $row['P47'];
            $P47_max = $row['P47_max'];
            $P47_min = $row['P47_min'];
        }
       // $sub_lotcode = substr($lotCode, 9, 4);
           
        $sql = "SELECT PCODE, total FROM kanba_checker WHERE PCODE = '$sub_lotcode' ORDER BY PCODE";
        $res_kanban = mysql_query($sql, $con);
       
        $row_kanban = mysql_fetch_assoc($res_kanban);
       
        $PCODE = $row_kanban['PCODE'];
        $total = $row_kanban['total'];
       
        if($compound = $P28 || $total == $P28_max){
         echo "<script type='text/javascript'>alert(P28 gain total maximum)</script>";   
        }
        else{
           
        } 


but I don't know if my code and my logic is correct.

I think  I did to add function.

But I don't know how..

I hope someone can help me or guide me to solve my problem.

Thank you so much..

HI All,

 

I am creating a dropdown box on an edit user form.  The box is populated from a table ssm_role and relates to the user which is another table.

I am wanting the value of the dropdown to be set as whatever the loaded user has in their database table.

See the images below.

$sql = "SELECT * FROM ssm_role ORDER BY role_name ASC";
if($result = mysqli_query($conn, $sql)){
if (mysqli_num_rows($result)>0){
while ($row = mysqli_fetch_array($result)){
echo "<option value='".$row['role_id']."'>".$row['role_name']."</option>";
}
}
}

This is what i am currently doing to make the dropdown but obviously this isnt even attempting to set the default.

Your help is always appreciated

What I'm wanting to do is pass the $propertyid = "1";  threw my select value as you can see. so it passes variable so to speak.'



Code: [Select]
print "<td>Control:<form action=\"dashboard.php\" method=\"GET\" target=\"_self\">
        <select name=\"control\" onChange=\"this.form.submit()\">
        <option selected></option>
        <option>Take a Payment</option>
        <option>Print Ledger </option>
        <option>-----------------</option>
        <option value=\"comadd?propid=$propertyid\">Add Communication</option>
        <option>----------------</option>
        <option>Modify Property</option>
        <option>Remote Property</option>
        </select></td>";

If I have a variable and a hard coded select dropdown, what is the easiest way to compare the variable with the value and set that particular option's selected attributed to selected?

Hi,

I am trying to create a drop down menu that will select a value that is stored in the database - right now the code creats a dropdown (with nothing selected) - hope someone can help.

in the database, the values are stored as
--null-
Option1
Option2
Option3

my code is
Code: [Select]

$instruction = $_GET['instruction'];

<?php 
<select id="instruction" name="instruction">
<option value="" <?php if (!empty($instruction) && $instruction == '' ) echo 'selected = "selected"'; ?>></option>     
<option value="Option1" <?php if (!empty($instruction) && $instruction == 'Option1')  echo 'selected = "selected"'; ?>>Option1</option>
<option value="Option2" <?php if (!empty($instruction) && $instruction == 'Option2')  echo 'selected = "selected"'; ?>>Option2</option>
<option value="Option3" <?php if (!empty($instruction) && $instruction == 'Option3')  echo 'selected = "selected"'; ?>>Option3</option>
</select>
<?

Hi,

I am doing an EDIT user page and would like to check records with a dropdown and then set as selected, please help!


<select name="BrokerID" class="small-input">

<option value="Please select an option">Please select a Broker</option> 

<?php 

while($row2 = mysql_fetch_array($broker))

{

echo '<option name="BrokerID" value="'.$row2['BrokerID'].'">'.$row2['BrokerName'].'</option>';

}

?>

</select>

This is more of a Paypal question, but I'm using php on the listener and hopefully someone has run into this problem.  I'm having trouble finding the correct POST name to use to get the OPTION SELECT for the item on my listener page.

I tried:

$option = $_POST['os0'];

But, I'm not getting anything using that. I've also tried os0_x, on0, and on0_x.

This is what I'm posting to Paypal:

<input type="hidden" name="on0" value="Term">
<select name="os0">
<option value="1 Year">1 Year</option>
<option value="3 Years">3 Years</option>
<option value="5 Years">5 Years</option>
</select>

 

Edited November 3, 2019 by jakebur01

Hello guys
I've hit a problem whicle trying to validate my form.
I have 3 drop down boxes where the user chooses from three options. But I can't seem to figure out how to set the validation so the user does not select the same option in each drop down. Can anyone help me solve this please. Thank you.
<p><b>Course Choice 1</b>
<select name="course1">
        <option value="0"></option>
        <option value="Business computer Systems">Business computer Systems</option>
<option value="Business computer Science">Business computer Science</option>
<option value="Business computer Science (Games)">Business computer Science (Games)</option>
<option value="Business Information Systems">Business Information Systems</option>
<option value="Digital Media Development">Digital Media Development</option>
<option value="Digital Media">Digital Media</option>
</select></p>

<p><b>Course Choice 2</b>
<select name="course2">
        <option value="Leave Blank">Leave Blank</option>
        <option value="Business computer Systems">Business computer Systems</option>
<option value="Business computer Science">Business computer Science</option>
<option value="Business computer Science (Games)">Business computer Science (Games)</option>
<option value="Business Information Systems">Business Information Systems</option>
<option value="Digital Media Development">Digital Media Development</option>
<option value="Digital Media">Digital Media</option>
</select></p>

<p><b>Course Choice 3</b>
<select name="course3">
        <option value="Leave Blank">Leave Blank</option>
        <option value="Business computer Systems">Business computer Systems</option>
<option value="Business computer Science">Business computer Science</option>
<option value="Business computer Science (Games)">Business computer Science (Games)</option>
<option value="Business Information Systems">Business Information Systems</option>
<option value="Digital Media Development">Digital Media Development</option>
<option value="Digital Media">Digital Media</option>
</select></p>

<div align="centre"><input type="submit" name="submit" value="send request" /></div>

 //Validate course choice 1
if (!empty($_REQUEST['course1'])) {
   $course1 = $_REQUEST['course1'];
} else {
   $course1 = NULL;
   echo '<p><font color="red">Please enter your first choice</font></p>';
}

//Validate course choice 2
if (!empty($_REQUEST['course2'])) {
   $course2 = $_REQUEST['course2'];
} else {
   $course2 = NULL;
   echo '<p><font color="red">Please enter your second choice</font></p>';
}

//Validate course choice 3
if (!empty($_REQUEST['course3'])) {
   $course3 = $_REQUEST['course3'];
} else {
   $course3 = NULL;
   echo '<p><font color="red">Please enter your third choice</font></p>';
}

//If everything is ok, print the message
if ($name && $email && $course1 && $course2 && $course3) {
echo "<p>Thank you, <b>$name</b>, You have chosen the following courses for information:<br /><br />
     <b>$course1</b><br />
 <b>$course2</b><br />
 <b>$course3</b></p>
 <p>We will reply to you at <i>$email</i>.</p>\n";
 
} else { // One form element was not filled out properly
echo '<p><font color="red">Please go back and fill out the form again.</font></p>';
}

Hi..

I need to save data from a while loop and data from select option, Now I encountered that using my query I only save is the last part of my while loop and also the data that I choose in select option did not save.

here is my code:

Code: [Select]
<?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');

$sr_date = $_POST['sr_date'];
$sr_number = $_POST['sr_number'];
$Items = $_POST['Items'];
$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', '$Items', '$SubItems', '$ItemCode', '$DemandedQty', '$UoM', '$Class', '$Description',
'$BINLocation', '$RequestedBy', '$ApprovedBy', '$ReceivedBy', '$IssuedBy')
ON DUPLICATE KEY UPDATE
sr_date = '$sr_date', sr_number = '$sr_number', Items = '$Items', SubItems = '$SubItems', ItemCode = '$ItemCode', DemandedQty = '$DemandedQty',
UoM = '$UoM', Class = '$Class', Description = '$Description', BINLocation = '$BINLocation', RequestedBy = '$RequestedBy',
ApprovedBy = '$ApprovedBy', ReceivedBy = '$ReceivedBy', IssuedBy = '$IssuedBy'";

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

        $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;
        } 
        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>
<style type="text/css">
#ddcolortabs{
margin-left: 2px;
padding: 0;
width: 100%;
background: transparent;
voice-family: "\"}\"";
voice-family: inherit;
padding-left: 2px;
}

#ddcolortabs ul{
font: bold 12px Arial, Verdana, sans-serif;
margin:0;
padding:0;
list-style:none;
}

#ddcolortabs li{
display:inline;
margin:0 2px 0 0;
padding:0;
text-transform:uppercase;
}


#ddcolortabs a{
float:left;
color: white;
background: #8cb85c url(layout_image/color_tabs_left.gif) no-repeat left top;
margin:2px 2px 0 0;
padding:0px 0 1px 3px;
text-decoration:none;
letter-spacing: 1px;
}

#ddcolortabs a span{
float:right;
display:block;
/*background: transparent url(layout_image/color_tabs_right.gif) no-repeat right top;*/
padding:6px 9px 2px 6px;
}

#ddcolortabs a span{
float:none;
}


#ddcolortabs a:hover{
background-color: #678b3f;
}

#ddcolortabs a:hover span{
background-color: #678b3f ;
}

#ddcolortabs #current a, #ddcolortabs #current span{ /*currently selected tab*/
background-color: #678b3f;
}
</style>
<style type="text/css">
#ddcolortabs1{
position: relative;
top: 10px;
margin-left: 2px;
padding: 0;
width: 100%;
background: transparent;
voice-family: "\"}\"";
voice-family: inherit;
padding-left: 2px;
}

#ddcolortabs1 ul{
font: bold 12px Arial, Verdana, sans-serif;
margin:0;
padding:0;
list-style:none;
}

#ddcolortabs1 li{
display:inline;
margin:0 2px 0 0;
padding:0;
text-transform:uppercase;
}


#ddcolortabs1 a{
float:left;
color: white;
background: #8cb85c url(layout_image/color_tabs_left.gif) no-repeat left top;
margin:2px 2px 0 0;
padding:0px 0 1px 3px;
text-decoration:none;
letter-spacing: 1px;
}

#ddcolortabs1 a span{
float:right;
display:block;
/*background: transparent url(layout_image/color_tabs_right.gif) no-repeat right top;*/
padding:6px 9px 2px 6px;
}

#ddcolortabs1 a span{
float:none;
}


#ddcolortabs1 a:hover{
background-color: #678b3f;
}

#ddcolortabs1 a:hover span{
background-color: #678b3f ;
}

#ddcolortabs1 #current a, #ddcolortabs1 #current span{ /*currently selected tab*/
background-color: #678b3f;
}
</style>

<style>
#SR_date{
    position: relative;
    font-family: Arial, Helvetica, sans-serif;
    font-size: .9em;
    margin-left: 10px;
    width: auto;
    height: auto;
    float: left;
    top : 10px;
   
}
#SR_number{
    position: relative;
    font-family: Arial, Helvetica, sans-serif;
    font-size: .9em;
    margin-left: 270px;
    width: auto;
    height: auto;
    float: left;
    top : 10px;
   
}
table {         
    margin: 10px;
    font-family: Arial, Helvetica, sans-serif; 
    font-size: .9em;
    border: 1px solid #DDD;
    width: auto;
}

th {
    font-family: Arial, Helvetica, sans-serif;
    font-size: .7em;
    background: #694;
    color: #FFF;
    padding: 2px 6px;
    border-collapse: separate;
    border: 1px solid #000;
}   

td {
    font-family: Arial, Helvetica, sans-serif;
    font-size: .7em;
    border: 1px solid #DDD;
    text-align: left;
}

#RequestedBy{
    position: relative;
    font-family: Arial, Helvetica, sans-serif;
    font-size: .8em;
    margin-left: 10px;
    width: auto;
    height: auto;
    float: left;
    top : 10px;
}

#ApprovedBy{
    position: relative;
    font-family: Arial, Helvetica, sans-serif;
    font-size: .8em;
    margin-left: 15px;
    width: auto;
    height: auto;
    float: left;
    top : 10px;
}

#ReceivedBy{
    position: relative;
    font-family: Arial, Helvetica, sans-serif;
    font-size: .8em;
    margin-left: 15px;
    width: auto;
    height: auto;
    float: left;
    top : 10px;
}
#IssuedBy{
    position: relative;
    font-family: Arial, Helvetica, sans-serif;
    font-size: .8em;
    margin-left: 15px;
    width: auto;
    height: auto;
    float: left;
    top : 10px;
    margin-right: 120px;
}
#save_btn{
    position: relative;;
    font-family: Arial, Helvetica, sans-serif;
    font-size: .8em;
    margin-left: 10px;
    top: 10px;
}
</style>

<script type="text/javascript">
function save_sr(){
    var sr_date = document.getElementById("sr_date").value;
    var sr_number = document.getElementById("sr_number").value;
    var Items = document.getElementById("Items").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+"&Items="+Items+
    "&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 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='$row[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 SubItems, ItemCode, UoM, Class, Description, BINLocation FROM bom_subitems WHERE Items = '$row[Items]' ORDER BY Items"or die(mysql_error());

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

    echo "<tr>
        <td style='border: none;'>&nbsp;</td>
        <td style='border: none;'>&nbsp;<input type='text' name='SubItems' value='$row_sub[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='$row_sub[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='$row_sub[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='$row_sub[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='$row_sub[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='$row_sub[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>

<div id='RequestedBy'>
<label>Requested By:</label>
<select name="Requested_By">
<option name='None'>Select</option>
<option name='AAAAAAAAA'>AAAAAAAAA</option>
<option name='BBBBBBBBB'>BBBBBBBBB</option>
<option name='CCCCCCCCCC'>CCCCCCCCCC</option>
</select>
</div>

<div id='ApprovedBy'>
<label>Approved By:</label>
<select name="Approved_By">
<option name='None'>Select</option>
<option name='AAAAAAAAA'>AAAAAAAAA</option>
<option name='BBBBBBBBB'>BBBBBBBBB</option>
<option name='CCCCCCCCCC'>CCCCCCCCCC</option>
</select>
</div>

<div id='ReceivedBy'>
<label>Received By:</label>
<select name="Received_By">
<option name='None'>Select</option>
<option name='AAAAAAAAA'>AAAAAAAAA</option>
<option name='BBBBBBBB'>BBBBBBBB</option>
<option name='CCCCCCCC'>CCCCCCCC</option>
</select>
</div>

<div id='IssuedBy'>
<label>Issued By:</label>
<select name="Issued BY">
<option name='None'>Select</option>
<option name='AAAAAAAAA'>AAAAAAAAA</option>
<option name='BBBBBBBB'>BBBBBBBB</option>
<option name='CCCCCCCC'>CCCCCCCC</option>
</select>
</div>

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


I also I attach the display data.

Thank you

Hi,   I am looking for a tutorial or code sample I can use to learn MySQLi pagination with an option to select items per page, like the attached screenshort.   Any help is grately appreciated.   Regards.   joseph Attached Files  table-pagination.jpg   32.87KB   0 downloads

Hi,  I'm a php newbie, with some mysql experience. I have a mysql database as follows:
Database=watch, Table=events - fields id, reportno, sdate, comments

What I need is:
1. A dropdown list to display reportno from mysql database.
2. Depending on which reportno I choose, I'd like to open a popup(or separate) page to display the stored information.

Tks in advance for any help

I have a search function in php where the text characters are matched to characters in a tables field--- works perfectly....
I need to make the input box have a droplist of words from database, this is also easy for me to do. the problem here is there is no definitive value! the options list always outputs a blank in the url---

its supposed to search a matching value and then output the matching value to url...

Here is the droplist code:


            $output['RATESTITLE']='<input class="inputbox" type="text" size="24px" name="ratestitle" value="'.$sch->filter['ratestitle'].'"  onfocus="if (this.value ==\''.$output['LANGUAGE_SEARCH_RATESTITLE'].'\') {this.value = \'\'}" />';

this outputs a input text box--- i want to have a droplist of options to populate this text box...
If you must know this is the third day im at it...