PHP - How To Show Selected Result From Db On Dropdown?

I must be missing something simple. I've got this little script that pulls rows from the database to populate a dropdown. If one of them matches a predetermined variable, then I want it to show selected. It's... almost working.

The dropdown prints, and shows the options. But the selected item shows separate, printed just below the dropdown?

Here's what I've got:

Code: [Select]
<?php
$quer3=mysql_query("SELECT discount_id, discount_name,discount_amount FROM tbl_discount order by discount_amount");
echo "&nbsp; &nbsp; <select name='discount_id'><option value=''>Select</option>";
while($row = mysql_fetch_array($quer3)) { 
if($row[discount_id]==$discount_id){echo "<option selected value='".$row[discount_id]."'>".$row[discount_name]."&nbsp; / &nbsp; $".$row[discount_amount]."</option>";}
else{echo  "<option value='$row[discount_id]'>$row[discount_amount]</option>";}
echo "</select>";
} ?>

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

mysql_select_db("ckeditor",$con);
?>
---------------------------------------------------------
add.php
<?php
include("mysql.php");


if(isset($_POST["button2"]))
{
$sql="INSERT INTO cktext (section)
VALUES
('$_POST[select2]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }

?>

-----------------------------------------------------------------
home.php

<form id="form1" name="form1" method="post" action="add.php">
<tr>
    <td>Section:</td>
    <td><select name="select2" id="select2">
     <option selected="selected" value="MALE">Male</option>
  <option selected="" value="FEMAIL">FEMAIL</option>
    </select></td>
  </tr>
<input type="submit" name="button2" id="button2" value="Upload" />
  </form>

In DATABASE :- cktext table attribute "section" is varchar type.

BUT IT RETURN ME BLANK OUTPUT.

I'm just attempting to learn how PHP handles things and I can't quite wrap my head around how to apply Selected to the final Option and show the Traits for the Character based on the Selected Option.

I understand this might need POST, if it does, I would appreciate a bit of help on how I would set this up as POST since I didn't think a drop down required a submit button.

Code: [Select]
$character= array (array(Name=>"Barry","Class"=>"Fighter",Level=>1,Str=>10,Dex=>10,"Int"=>10),array(Name=>"Lindehar","Class"=>"Ranger",Level=>1,Str=>10,Dex=>10,"Int"=>10),array(Name=>"Verelden","Class"=>"Mage",Level=>1,Str=>10,Dex=>10,"Int"=>10));

print "Select a Character:<br /><select>";
foreach($character as $array_num)
{
foreach($array_num as $char_trait=>$trait_value)
{
if($char_trait==Name)
{
$selected_value="";
$generated_chars="<option selected=".$selected_value." value='".$char_trait."'>".$char_trait.": ".$trait_value."</option>";
print $generated_chars;
if($selected_value=/".$char_trait.": Barry"/")
{
foreach($char_trait=="Barry")
{
print "<h4>".$char_trait.": ".$trait_value."</h4>";
}
}
}


}
}
print "</select><p />";

i skipped solving this the other day with an easier way but now i am stuck with this stumble again in another area and i have no way out....
so here it goes,
i have an ajax dropdown box...i need to get the value that is selected by the user when it is clicked and then pass this value to a new pop window by appending to its url....any suggestions?

i have the following code:
<td width='100px'>Suppliers
                <select name="supplier">
                    <?php
                       $catcher_id = $service->getCatcherId();
                       $supplier_names = LpmAdnetworkPeer::getByName($catcher_id);
                       foreach($supplier_names as $row)
                       {
                           ?>
                           <option><?php echo $row->getName();
                           ?></option>
                    <?php     
                       }
                    ?>
                </select>
                </td>   

then on the same form i have a submit button that takes me to the next form..the problem now is how can i access the ID of the item seleted in the dropdown on the NEXT form please?
i can get the name from the list by $_POST['supplier'] on the next form
thanks

Yesterday, I created a topic about how I could update records and I managed to achieve that successfully.

Now I have another dilemma.

When I have a specific record I want to update, I want to change a category ID of an product (e.g. change it from 1 to 2) but how do I go about doing this?

Here is my code thus far:

Code: [Select]
<?php

require_once ('./includes/config.inc.php');

require_once (MYSQL);

$id=$_GET['prodID'];

$results = mysqli_query($dbc, "SELECT * FROM product WHERE prodID=".$_GET['prodID']."");
$row = mysqli_fetch_assoc($results);

?>
<form action="" method='POST'>
Product ID: <input type="text" value="<?php echo $row['prodID'];?>" name="prodID" /> <br />
Product: <input type="text" value="<?php echo $row['product'] ;?>" name="product" /> <br />
Product Description: <input type="text" value="<?php echo $row['prod_descr'] ;?>" name="prod_descr" /> <br />
Category:
<select name="category">
<option value="<?php echo $row['catID'];?>"></option>
</select>
Price: <input type="text" value="<?php echo $row['price'] ;?>" name="price" /> <br />
In Stock: <input type="text" value="<?php echo $row['stock'] ;?>" name="stock" /> <br />
<br /><input type="submit" value="save" name="save">
</form>

<?php

if(isset($_POST['save']))
 {
    $id = $_POST['prodID'];
    $product = $_POST['product'];
$descr = $_POST['prod_descr'];
$price = $_POST['price'];
$stock = $_POST['stock'];

// Update data
    $update = mysqli_query($dbc, "UPDATE product SET product='$product', prod_descr='$descr', price='$price', stock='$stock' WHERE prodID=".$_GET['prodID']."");
header( 'Location: update_save.php' ) ;
}
?>

Hey Everyone...

First off, I am only a young web developer and i'm working on a school project and am making a text-based game online...

Now what i'm having trouble with...

I want a drop-down list that has a list of characters classes
Clubber
Mixer
Sauceror
Tamer

And I want whatever is selected to be placed into the database along with the username/password (THIS ALL WORKS FINE JUST NOT THE DROP DOWN LIST)

All help appreciated

I'm new to this form and php/mysql so sorry if this isn't the right place to post this.


This is what is in the first dropdown box.
Code: [Select]

$selValues['john'] = "a, b, c, d, e";

These are the different lists I want it to put in the second drop down box depending on what they choose in the first.
Code: [Select]
$selValues['list1']= " a1, a2, a3, a4, a5";
$selValues['list2']= " b1, b2, b3, b4, b5";

This is how I made an attempt to make it work before posting here. Along with plently of other ways.
Code: [Select]
if ($selValues['john']=a)
{
     $chan_input = selectBuilder($selValues['$list1'] };
else if ($selValues['john']=b)
 {
     $chan_input = selectBuilder($selValues['$list2'] };

Basicly how I need it to work is there are two drop down boxes. First they will chose between a,b,c,d,e. If they chose a then on the second drop down box I only want them to be able to select a1,a2,a3,a4,a5.

Hi all,

I am trying to make a members details section that can be updated.

I want to be able to "SELECT * FROM users WHERE email='$email'" and then show the values that can be changed in a html drop down box with the selection that was made when the user registered already selected="selected";

You will be able to see what I am attempting to do below.


<?php

$sql = "SELECT manufacturer FROM table1 WHERE email=$'email'";
$result = mysqli_query($cxn,$sql);
$row = mysqli_fetch_assoc($result);

foreach manufacturer in table1 { 
      if table1.manufacturer = table2.manufacturer {
               echo '<option name="manufacturer" selected="selected" value"$row['manufacturer']"</option>';
     }
     else {
              echo '<option name="manufacturer" value"$row['manufacturer']"</option>';
     }
}
?>

hi i am using yahoo api search i put a paragraph in a text area explode with ".Dot " and than serah each sentance one by one in yahoo api. Problem is i want when its get all sentancce in one site its give me result one time but my code give result as foreach loop end if it explode 5 time it give me same result 5 time but i want only one time

some one help me


$queryz=$_REQUEST['query'];
$queryz1=explode('.',$queryz);
foreach ($queryz1 as $k=>$v){
$q = build_query($v);
//exit();
performTask($q);

}



// To cache, we save the result xml to a filename that is a
// hash of the query string.  Note the use of tempnam() and
// rename() to make sure the file is created atomically.
function performTask($q=""){
$cache_file = '/tmp/yws_'.md5('http://search.yahooapis.com/WebSearchService/V1/webSearch'.$q);
if(file_exists($cache_file) && filemtime($cache_file) > (time()-7200)) {
  $raw = file_get_contents($cache_file);
} else {
  $raw = file_get_contents('http://search.yahooapis.com/WebSearchService/V1/webSearch'.$q);
  
  $tmpf = tempnam('/tmp','YWS');
  file_put_contents($tmpf, $raw);
  @rename($tmpf, $cache_file); 
}

$xml = simplexml_load_string($raw);
// Load up the root element attributes
foreach($xml->attributes() as $name=>$attr) $res[$name]=$attr;

$first = $res['firstResultPosition'];
$last = $first + $res['totalResultsReturned']-1;
echo "<p>Matched ${res[totalResultsAvailable]}, showing $first to $last</p>\n";
if(!empty($res['ResultSetMapUrl'])) {
  echo "<p>Result Set Map: <a href=\"${res[ResultSetMapUrl]}\">${res[ResultSetMapUrl]}</a></p>\n";
}
$stored="";
for($i=0; $i<$res['totalResultsReturned']; $i++) {
  
  
  foreach($xml->Result[$i] as $key=>$value) {


if(stristr($key,'ClickUrl')){
if(strpos($stored,$value)){
continue;
}
}  

if(stristr($key,'Title')) echo "<a href=\"$value\">$value</a> <br /> \n";
if(stristr($key,'ClickUrl')){echo "Url: <a href=\"$value\">$value</a> <br /> \n"; $stored.=$value;}
if(stristr($key,'Summary')) echo "$value <br /> \n";
if(stristr($key,'ModificationDate')) echo "Update: $value From Yahoo <br /> \n";
 

  }
  echo "<hr />\n";
}
next_prev($res, $first, $last);

}
done();
?>

if the session is true $_SESSION['frommonth'] i want it to show the selected session

Code: [Select]
<select name="from_month" id="from_month">
<option value="<?php echo $_SESSION['frommonth'];?>" selected="selected">mm</dd>
<?for ($i=1;$i<=12;$i++):?>
<option value="<?=$i?>"><?=$months[$i]?></dd>
<?endfor;?>
</select>
how could i do this?

I have a form gathering data from the database. There is one field 'country' which is a combo box. The combo box is populated from the countries table which joins the customers table to provide the country specific to the customer. I'm trying to have the combo box display the country associated with the customer. I think I'm close in my code, but unsure. This is a playground to so I can implement on our other site. 

<?php
require_once('database.php');
$sql2 = "SELECT * From countries
";
$countries = $db->query($sql2);

if(isset($_GET['customerID'])) {
    $customerID = filter_input(INPUT_GET, 'customerID', FILTER_SANITIZE_NUMBER_INT);
    $sql = "SELECT * FROM customers  WHERE customerID =$customerID ";
//$sql2 = "SELECT * From countries
//INNER JOIN customers ON countries.countryCode=customers.countryCode
//WHERE customers.customerID = $customerID";
    $stmt = $db->query($sql);
}
if(isset($_GET['customerID'])){
    $customerID = filter_input(INPUT_GET, 'customerID', FILTER_SANITIZE_NUMBER_INT);
    $countryQuery = "
    {$sql2} INNER JOIN customers ON countries.countryCode = customers.countryCode WHERE customers.customerID = $customerID";

    $countriesQuery = $db->prepare($countryQuery);
    $countriesQuery->execute(['customerID' => $_GET['customerID']]);

    $selectedCountry = $countriesQuery->fetch(PDO::FETCH_ASSOC);

    var_dump($selectedCountry);

}

?>



<!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">

<!-- the head section -->
<head>
    <title>My Guitar Shop</title>
    <link rel="stylesheet" type="text/css" href="main.css" />
</head>

<!-- the body section -->
<body>
<div id="page">

    <div id="header">
        <h1>SportsPro Technical Support</h1>
        <p>Sports management software for the sports enthusiast.</p></h1>
    </div>

    <div id="main">

        <h1>View/Update Customer</h1>

        <form action="update.php" method="get" >
        <?php




        ?>
        <div id="content">
            <!-- display a table of products -->
            <h2>Customers</h2>
            <form  name="customerInfo">
               <?php foreach ($stmt as $cust) { ?>
                <div>
                    <label>First Name</label>
            <input type="text" name="name" class ="form-control" value ="<?php echo $cust['firstName']; ?>">
            </div><br>
                <div>
                    <label>Last Name</label>
                    <input type="text" name="name" class ="form-control" value ="<?php echo $cust['lastName']; ?>">
                </div><br>
            <div>
            <label>Address</label>
            <input type="text" name="address" class ="form-control" value ="<?php echo $cust['address']; ?>">
                </div><br>
                <div>
                    <label>City</label>
            <input type="text" name="city" class ="form-control" value ="<?php echo $cust['city']; ?>">
                </div><br>
                <div>
                    <label>State</label>
            <input type="text" name="state" class ="form-control" value ="<?php echo $cust['state']; ?>">
                </div><br>
                <form action="update.php" method="get">
                    <select name="country">
                        <option value=""></option>
                        <?php
                        foreach ($countries->fetchAll() as $country): ?>
                            <option value="<?php echo $country['customerID']; ?>
                          <?php echo isset($customerID) == $selectedCountry['customerID'] ? ' selected':''?>
                            "><?php echo $country['countryName']; ?></option>

                        <?php endforeach;?>

                    </select>


                </form>
                </div>



                <br>
                <div>
                    <label>Country Code</label>
            <input type="text" name="countryCode" class ="form-control" value ="<?php echo $cust['countryCode']; ?>">
                </div><br>
                <div>
                    <label>Zip Code</label>
            <input type="text" name="postalCode" class ="form-control" value ="<?php echo $cust['postalCode']; ?>">
                </div><br>
                <div>
                    <label>Email </label>
            <input type="text" name="email" class ="form-control" value ="<?php echo $cust['email']; ?>">
                </div><br>
                <div>
                    <label>Phone Number </label>
            <input type="text" name="phone" class ="form-control" value ="<?php echo $cust['phone']; ?>">
                </div><br>
                <div>
                    <label>Password </label>
            <input type="text" name="password" class ="form-control" value ="<?php echo $cust['password']; ?>">
                </div><br>
                <div>

                <?php    }

                                ?>


        </div>

    </div>
            <form action="UpdateCustomer.php" method="get">
                <input   type="submit" name="data" value="Update_Data"></input>
            </form>
    <div id="footer">
        <p>
            © <?php echo date("Y"); ?> SportsPro, Inc.
        </p>
    </div>

</div><!-- end page -->
</body>
</html>

 

This topic has been moved to Ajax Help.

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

I have found postings close, but not close enough to find my error.
I am looking up data from a MySql table and putting it in a dropdown box on a form. I can select the item, but apparently not really. I am not able to echo it, or post it to a record.
I'm sure I am missing something simple, but...
Code attached if anyone can show me the errors of my ways.
Thank you.