PHP - Option And

Good day all,

I am really in need of some help here with my website. I am new to the php and mysql environs, but an avid supporter and learner.

I have a problem making my drop down 'category' option to work - as in when I select an option from the drop down list, it should pull the data from the mysql database which works magically with the keyword searches, etc...its just the category search not working - below is the coding which I am working with currently:

action=search.php method=get>         Keyword : <input type=text name=k />         Category :                   <select name=b>            <option value=0>All</option>         <?php            $connection = mysql_connect('127.0.0.1', 'vale_view', '8hw9er1' );            if (!$connection)            {               die ("Could not connect to the database: <br />". mysql_error());            }            $db_select=mysql_select_db('vale_view');            if (!$db_select)            {               die ("Could not select the database: <br />". mysql_error());            }                        $query = "SELECT catid,catname FROM categories order by catname";            $result = mysql_query( $query ) or die('die');                        if (!$result)            {               die ("Could not query the database: <br />". mysql_error());            }            while ($result_row = mysql_fetch_row($result)) {               echo "<option value=".$result_row[0].">".$result_row[1]."</option>";            }                        mysql_close($connection);         ?>

 

I have the following which fils a combo box with years from 1950 to 2100. This is the year box for the date of birth.

Year 
<select name="year_select">
<?php
for( $i=1950; $i<=2100; $i++ )
{
echo "<option value=\"{$i}\" class=\"year\">{$i}</option>";
}
?>
</select>

I want it to automatically display the year that is in the database so instead of automatically displaying 1950 i want their birth year displayed which is $tab_info->user_dob_year. How would i go about this? i dont know where to start since im using a for loop to populate it.

I am adding to a shopping cart using sessions, when I add a product with a selected size it echoes the correct size as text but when applying it to my option boxes as selected, it just shows the last item in the select box.
here is the code for the session variables
<?php 
for ($basket_counter=0;$basket_counter<$_SESSION['ses_basket_items'];$basket_counter++) {
   $price=sprintf("%01.2f",$ses_basket_price[$basket_counter]);
    $quantity=$ses_basket_amount[$basket_counter];
$code=$ses_basket_stockcode[$basket_counter];
$itemID=$ses_basket_id[$basket_counter];
    $name=$ses_basket_name[$basket_counter];
$image=$ses_basket_image[$basket_counter];
$size=$ses_basket_size[$basket_counter];
$sizechoice=$ses_basket_sizechoice[$basket_counter];
// create array from sizes and make the option box selections
if ($sizechoice!="" && (!in_array($sizechoice, array('One Size', 'one size', 'free size', 'Free Size', 'Adjustable', 'adjustable')))) { 
// add size trigger
$sizelist="add";
//create the array
$sizepick=explode(",", $sizechoice);
} else { $sizepick=$sizechoice; }
// adjust gst for AU customers
if ($country='AU') { $price=sprintf("%01.2f",($price*1.1));
$unit=sprintf("%01.2f",($price/$quantity));
 }
else
{ $unit=sprintf("%01.2f",($price/$quantity)); }
?>


and this bit inside the same loop displayes the select box for size
<?php if ($sizelist && $sizelist='add') { echo "<select name='size' id='size' style='vertical-align:middle;'>"; foreach($sizepick AS $sizes) { if ($sizes==$size) { echo "<option value='$size' selected='selected'>$size</option>"; } else { echo "<option value='$sizes'>$sizes</option>"; }} echo "</select>"; } else { echo $size; } ?>

appreciate any help on this

ok this works fine and everything but when here when i try to let the admin changes stuff and goes to change the venue a list show appear and it does but when it save it save it as

 RBB FIELD <option value="RED BULL ARENA">RED BULL ARENA</option><option value="RBB FIELD ">RBB FIELD </option><option value="RED BULL ARENA">RED BULL ARENA</option>

why does it do that?? HElp ANYONE

Code
Code: [Select]
<?php 

if (isset($_GET['eid'])){

$newid = $_GET['eid'];

$sqlCommand = "SELECT * FROM events WHERE id='$newid' LIMIT 1"; 
$out = mysql_query($sqlCommand);
$row = mysql_fetch_assoc($out);

  $eventid = $row["id"];
  $eventname = $row["eventname"];
  $eventtype = $row["typeevent"];
  $eventinfo = $row["eventinfo"];
  $date = $row["date"];
  $time = $row["time"];
  $livetickets = $row["sale"];
  $numtickets = $row["numtickets"];
  $pricestudents = $row["studentsprice"];
  $priceseniors = $row["seniorsprice"];
  $priceadults = $row["adultsprice"];
  $venues = $row["venue"];
  $category = $row["category"];
  
$query = mysql_query("SELECT venuename FROM venue");
while ($row = mysql_fetch_array($query)){

$venues .= '<option value="' . $row['venuename'] . '">' . $row['venuename'] . '</option>';
}

$form = "<form action='eevent.php' method='post' enctype='multipart/form-data'>
<table>

<tr>
<td>REQUIRED FIELDS *</td>
<td></td>
</tr>

<tr>
<td>Event Name*</td>
<td><textarea cols='17' rows='1' name='eventname' />$eventname</textarea></td>
</tr>

<tr>
<td>Type of event*</td>
<td><textarea cols='17' rows='1' name='typeevent' />$eventtype</textarea></td>
</tr>

<tr>
<td>Event Inforamtion*</td>
<td><textarea name='eventinfo' cols='40' rows='5'>$eventinfo</textarea></td>
</tr>

<tr>
<td>Date</td>
<td><input type='text' size='10' name='date' value='$date' /></td>
</tr>

<tr>
<td>Time</td>
<td><input type='text' size='10' name='time' value='$time' /></td>
</tr>

<tr>
<td>When tickets go on sale</td>
<td><input type='text' size='10' name='sale' value='$livetickets' /></td>
</tr>

<tr>
<td>Number of Tickets Available </td>
<td><input type='text' size='5' name='numtickets' value='$numtickets' /></td>
</tr>

<tr>
<td><h4>Ticket Prices</h4></td>
</tr>
<tr>
<td>STUDENTS</td>
<td>$<input type='text' size='3' name='studentsprice' value='$pricestudents'/></td>
</tr>
<tr>
<td>SENIORS</td>
<td>$<input type='text'  size='3' name='seniorsprice' value='$priceseniors'/></td>
</tr>
<tr>
<td>ADULTS</td>
<td>$<input type='text' size='3' name='adultsprice' value='$priceadults' /></td>
</tr>
<tr>
<td>SELECT VENUE</td>
<td>
<select name='venue'>
<option value='$venues'>$venues</option>
</select>
</td>
</tr>
<tr>
<td>SELECT CATEGORY</td>
<td>
<select name='category'>
<option value='$category'>$category</option>
<option>FOOTBALL</option>
<option>BASKETBALL</option>
<option>HOCKEY</option>
<option>DRAMA</option>
<option>MUSIC</option>
<option>DANCE</option>
<option>VISUAL ARTS</option>
</select>
</td>
</tr>


<tr>
<td></td>
<td><input type='hidden' name='saveevent' value='$newid'/></td>
<td><input type='submit' name='savechanges' value='Save Changes'/></td>
</tr>
</table>
</form>";
   
echo "$form";  
 
 } 
   
if ($_POST['saveevent']){

  $newid = mysql_real_escape_string($_POST['saveevent']);
  $eventname = mysql_real_escape_string($_POST['eventname']);
  $eventtype = mysql_real_escape_string($_POST['typeevent']);
  $eventinfo = mysql_real_escape_string($_POST['eventinfo']);
  $date = mysql_real_escape_string($_POST['date']);
  $time = mysql_real_escape_string($_POST['time']);
  $livetickets = mysql_real_escape_string($_POST['sale']);
  $numtickets = mysql_real_escape_string($_POST['numtickets']);
  $pricestudents = mysql_real_escape_string($_POST['studentsprice']);
  $priceseniors = mysql_real_escape_string($_POST['seniorsprice']);
  $priceadults = mysql_real_escape_string($_POST['adultsprice']);
  $venues = mysql_real_escape_string($_POST['venue']);
  $categorys = mysql_real_escape_string($_POST['category']);
  
  
$sqlCommand = "UPDATE events SET eventname='$eventname', typeevent='$eventtype', eventinfo='$eventinfo',
date='$date', time='$time', sale='$livetickets', numtickets='$numtickets', studentsprice='$pricestudents',
seniorsprice='$priceseniors', adultsprice='$priceadults', venue='$venues', category='$categorys' WHERE id='$newid'"; 
$out = mysql_query($sqlCommand);

echo "SAVE CHANGES COMPLETED!";

}
 
    
?>

ok so below is the select option for my form i creatig should this select have the name 0f bday form of the three selects so that when i put it into a variable it could just be

$birthday = $_POST = ['bday'];


Code: [Select]
<select class="drop" name="bday">
    <option>Month</option>
<option value="1">January</option>
<option value="2">February</option>
<option value="3">March</option>
<option value="4">April</option>
<option value="5">May</option>
<option value="6">June</option>
<option value="7">July</option>
<option value="8">August</option>
<option value="9">September</option>
<option value="10">October</option>
<option value="11">November</option>
<option value="12">December</option>
</select>
<select class="drop" name="bday">
<option>Day</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
<option value="13">13</option>
<option value="14">14</option>
<option value="15">15</option>
<option value="16">16</option>
<option value="17">17</option>
<option value="18">18</option>
<option value="19">19</option>
<option value="20">20</option>
<option value="21">21</option>
<option value="22">22</option>
<option value="23">23</option>
<option value="24">24</option>
<option value="25">25</option>
<option value="26">26</option>
<option value="27">27</option>
<option value="28">28</option>
<option value="29">29</option>
<option value="30">30</option>
<option value="31">31</option>
</select>
<select class="drop" name="bday">
    <option>Year</option>
    <option value="2011">2011</option>
    <option value="2010">2010</option>
    <option value="2009">2009</option>
    <option value="2008">2008</option>
    <option value="2007">2007</option>
    <option value="2006">2006</option>
    <option value="2005">2005</option>
    <option value="2004">2004</option>
    <option value="2003">2003</option>
    <option value="2002">2002</option>
    <option value="2001">2001</option>
    <option value="2000">2000</option>
    <option value="1999">1999</option>
    <option value="1998">1998</option>
    <option value="1997">1997</option>
    <option value="1996">1996</option>
    <option value="1995">1995</option>
    <option value="1994">1994</option>
    <option value="1993">1993</option>
    <option value="1992">1992</option>
    <option value="1991">1991</option>
    <option value="1990">1990</option>
    <option value="1989">1989</option>
    <option value="1988">1988</option>
    <option value="1987">1987</option>
    <option value="1986">1986</option>
    <option value="1985">1985</option>
    <option value="1984">1984</option>
    <option value="1983">1983</option>
    <option value="1982">1982</option>
    <option value="1981">1981</option>
    <option value="1980">1980</option>
    <option value="1979">1979</option>
    <option value="1978">1978</option>
    <option value="1977">1977</option>
    <option value="1976">1976</option>
    <option value="1975">1975</option>
    <option value="1974">1974</option>
    <option value="1973">1973</option>
    <option value="1972">1972</option>
    <option value="1971">1971</option>
    <option value="1970">1970</option>
    <option value="1969">1969</option>
    <option value="1968">1968</option>
    <option value="1967">1967</option>
    <option value="1966">1966</option>
    <option value="1965">1965</option>
    <option value="1964">1964</option>
    <option value="1963">1963</option>
    <option value="1962">1962</option>
    <option value="1961">1961</option>
    <option value="1960">1960</option>
    <option value="1959">1959</option>
    <option value="1958">1958</option>
    <option value="1957">1957</option>
    <option value="1956">1956</option>
    <option value="1955">1955</option>
    <option value="1954">1954</option>
    <option value="1953">1953</option>
    <option value="1952">1952</option>
    <option value="1951">1951</option>
    <option value="1950">1950</option>
    <option value="1949">1949</option>
    <option value="1948">1948</option>
    <option value="1947">1947</option>
    <option value="1946">1946</option>
    <option value="1945">1945</option>
    <option value="1944">1944</option>
    <option value="1943">1943</option>
    <option value="1942">1942</option>
    <option value="1941">1941</option>
    <option value="1940">1940</option>
    <option value="1939">1939</option>
    <option value="1938">1938</option>
    <option value="1937">1937</option>
    <option value="1936">1936</option>
    <option value="1935">1935</option>
    <option value="1934">1934</option>
    <option value="1933">1933</option>
    <option value="1932">1932</option>
    <option value="1931">1931</option>
    <option value="1930">1930</option>
    <option value="1929">1929</option>
    <option value="1928">1928</option>
    <option value="1927">1927</option>
    <option value="1926">1926</option>
    <option value="1925">1925</option>
    <option value="1924">1924</option>
    <option value="1923">1923</option>
    <option value="1922">1922</option>
    <option value="1921">1921</option>
    <option value="1920">1920</option>
    <option value="1919">1919</option>
    <option value="1918">1918</option>
    <option value="1917">1917</option>
    <option value="1916">1916</option>
    <option value="1915">1915</option>
    <option value="1914">1914</option>
    <option value="1913">1913</option>
    <option value="1912">1912</option>
    <option value="1911">1911</option>
    <option value="1910">1910</option>
    <option value="1909">1909</option>
    <option value="1908">1908</option>
    <option value="1907">1907</option>
    <option value="1906">1906</option>
    <option value="1905">1905</option>
    <option value="1904">1904</option>
    <option value="1903">1903</option>
    <option value="1902">1902</option>
    <option value="1901">1901</option>
    <option value="1900">1900</option>
</select>

Hey guys, i have a small problemo. As you can see i have made an option list from 0 to 3.

How can I put this optionlist in a for loop so I can save some place? I have found an example but I dont know how to integrate it in my php
Example
Code: [Select]
for( $i = 0; $i < 4; $i++ ) {
$optionlist .= "<option value=\"$i\">$i</option>\n";
}
$optionlist .= "</select>\n";

Code: [Select]
        <?php
        $dranken = array("cola", "fanta", "bier", "koffie", "thee");
        $prijzen = array("2", "2", "1.80", "2.20", "2.20");


        $i = 0;

        echo "<table>";

        while ($dranken[$i]) {
            $listnaam = $dranken[$i] . "_aantal";
            $optionlist = "<select name= '$listnaam'><option>0</option><option>1</option><option>2</option><option>3</option></select>";
            
            echo "<tr><td >" . $dranken[$i] . "</td>";
            echo "<td>" . $prijzen[$i] . "</td>";
echo "<td>" . $optionlist . "</td></tr>";

            $i++;
        }

        echo "</table>";
        ?>


thanks

Evening People

I have this drop downbox on a HTML page, it is populated from a PHP page, if the user makes a selection i want that selection to be retained once the page refreshed.

What i have is

while ($row = $db->sql_fetchrow($result))
{
     if(isset($_GET["REGION_FILTER"]) AND $_GET["REGION_FILTER"] = $row['region'] AND strlen($_GET["REGION_FILTER"]) > 0)
     //if($region_filter = $row['region'] AND strlen($region_filter) > 0)
                {
$region_filter_options .= '<option value="' . $row['region'] . '" SELECTED>' . $row['region'] . '</option>';
                }
                else
                {
                $region_filter_options .= '<option value="' . $row['region']. '">' . $row['region'] . '</option>';
                   
                }
               
}

REGION_FILTER is the ID of the option box

The drop down box is populated from the database but i cant seem to get the selected bit working. Can someone help identify what i have done wrong ?

regards

Hi, I am trying to take the concatenated option value from my form and send it via email broken into the individual pieces.  For example, in my code to follow... the ID field is the key field that generates what you see in the drop down list (Date, Site, Price).  What I want to be able to do is separate (or un-concatenate, for lack of a better word) the values $Date, $Site, $Price so when the customer receives the email it reads this way because right now it only gives me the ID field (RID) to send via email...

Date: 5/29-6/3/11
Site: Carterville
Price: $1150.00
....

Any ideas on how to do this?  Here is the code from my form.....

Code: [Select]
<?php

$q=$_GET["q"];

$con = mysql_connect('my-host', 'my_user', 'my_pwd');
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("my_db", $con);

$sql="SELECT *
      FROM daterange
  WHERE DEND > DATE(NOW())
  AND STATUS='A' AND MONTH = '".$q."'
      ORDER BY RID, DATE, SITE";

$result = mysql_query($sql);


// Determine the number of reservation dates
$number = mysql_numrows($result);


// Create drop-down menu of reservation dates
print "<font size=\"3\" face=\"Arial\"><b>Select Your Reservation:</b><br>
<form action=\"resersend.php\" method=\"post\">
<select name=\"RID\">
    <option value=\"\">Choose One</option>";

for ($i=0; $i<$number; $i++) {
     $RID = mysql_result($result,$i,"RID");
     $DATE = mysql_result($result,$i,"DATE");
     $SITE = mysql_result($result,$i, "SITE");
 $PRICE = mysql_result($result,$i, "PRICE");
     print "<option value=\"$RID\">$DATE, $SITE, $PRICE</option>";
}

print "</select><p align=left><label><font size=\"3\" face=\"Arial\">First Name: <input type=\"text\" name=\"FNAME\" size=\"50\" maxlength=\"50\" tabindex=\"1\"<br>";

print "<p align=left><label>Last Name: <input type=\"text\" name=\"LNAME\" size=\"50\" maxlength=\"50\" tabindex=\"2\"<br>";

print "<p align=left><label>Address Line 1: <input type=\"text\" name=\"ADDR1\" size=\"50\" maxlength=\"50\" tabindex=\"3\"<br>";

print "<p align=left><label>Address Line 2: <input type=\"text\" name=\"ADDR2\" size=\"50\" maxlength=\"50\" tabindex=\"4\"<br>";

print "<p align=left><label>City: <input type=\"text\" name=\"CITY\" size=\"50\" maxlength=\"50\" tabindex=\"5\"<br>";

print "<p align=left><label>State (abbrev.): <input type=\"text\" name=\"STATE\" size=\"2\" maxlength=\"2\" tabindex=\"6\"<br>";

print "<p align=left><label>Zip Code: <input type=\"text\" name=\"ZIP\" size=\"5\" maxlength=\"5\" tabindex=\"7\"<br>";

print "<p align=left><label>Contact Phone Number: (<input type=\"text\" name=\"PHONE1\" size=\"3\" maxlength=\"3\" tabindex=\"8\"";
print "<label>)<input type=\"text\" name=\"PHONE2\" size=\"3\" maxlength=\"3\" tabindex=\"9\"";
print "<label>-<input type=\"text\" name=\"PHONE3\" size=\"4\" maxlength=\"4\" tabindex=\"10\"<br>";

print "<p align=left><label>Email: <input type=\"text\" name=\"EMAIL\" size=\"50\" maxlength=\"50\" tabindex=\"11\"<br>";
print "<p align=left><input type=\"submit\" value=\"Book Now!\"
    name=\"submit\">";

print "<input type=\"reset\" value=\"reset\"
    name=\"reset\"></form>";


// Close the database connection
mysql_close($con);
?>

i have a basic html form with a drop down selection box with 2 options ('old' and 'new'). when you click one it swaps them round to you can click the other because it is an onchange event.


<form action="<?php $_SERVER['self']; ?>" method="get">
<select name="Time" onchange="this.form.submit();">
<option  value="New">New</option>
<option  value="Old">Old</option>
</select></form> 

I have a Payment Form that has become rather complex, and I think it's time to hand things off to another page?!

Here is the gist of my form...


Code: [Select]
<?php session_start(); ?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN"
"http://www.w3.org/TR/html4/strict.dtd">
<html>
<head></head>
<body>
<?php
// Initialize variables.

// *********************************************************************
// HANDLE FORM.
// *********************************************************************
if (isset($_POST['submitted'])){
// Initialize Errors Array.
  $errors = array();

// ********************
// CHECK FORM DATA. *
// ********************

// Determine if any errors.
if (empty($errors)){
// *********************************************************************
// PROCESS PAYMENT.
// *********************************************************************

//@@@@@@@@@@@  START AUTHORIZE.NET CODE  @@@@@@@@@@@@@@@@@

// Use HTTP POST to send form data.
curl_setopt($request, CURLOPT_POSTFIELDS, $post_string);

// Print Response Code.
switch($response_array[0]){
case "1":
$responseCode = 'Approved';
break;
case "2":
$responseCode = 'Declined';
break;
case "3":
$responseCode = 'Error  (Please contact Customer Service.)';
break;
case "4":
$responseCode = 'Held for Review  (Please contact Customer Service.)';
break;
}

echo "<br />Response Code: " . $responseCode . "<br />";
//@@@@@@@@@@@  END AUTHORIZE.NET CODE  @@@@@@@@@@@@@@@@@@

// Do not return to Payment Form!!!
exit();
// *********************************************************************
}// End of PROCESS PAYMENT.
}// End of HANDLE FORM.

?>

<!-- @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ -->
<!-- HTML PAYMENT FORM -->
<form id="payment" action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">


</form>
</body>
</html>

In fairness, this actually isn't the entire page - it is just the HTML Form and PHP Handling Script...

The entire page will also have a Header and Footer, and is why I am asking for help.

As my code works no, after the form is submitted, the user sees a white screen with only a Response Message.

How can I redirect the user to another page which has my website's Header and Footer and a more personalized message??

(I could technically echo a boat-load of HTML in the IF-THEN-ELSE after the form is submitted, but that seems excessive.  So a page re-direct seems to make more sense...)

Thanks,


Debbie

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

i have this select box in a form

Code: [Select]
<select name='theoptions' style='color: #000000;text-align:center;background-color:#DEDEDE;border: 1px solid #D99C29;width:163px;padding:5px;' onchange='optionChanged(this);ChgBox(this.value);'>

   <option value='1' >Your comment on</option>
  <option value='3' >Your question on</option>
  <option value='4' >Your expertise on</option>
  <option value='2' >Your image about</option>
  <option value='5' >Your website about</option>
  <option value='0' >Comparison</option>

</select>

on the page where the form directs to i have

  Code: [Select]
$options = $_POST['theoptions'];
I want to get option 5 specificially, how do i do that?

Hello, guys! Just a small first ever thread, where I ask a question where I hope anyone is able to help me out

I am working on a project with a friend of mine for a company. I have a problem with the function on a form.
I wonder; How do i change the option value of a form? Let's say if I choose a category like "Cake", I want the second drop down box to display different brands of cake. But if I choose bicycle for example, I want the option values to be different brands of bicycles. I hope you guys understand what I was trying to say here.
Anyways, here is a sample image where I want this function to occur:

Sample:


Cheers and thanks in advance,
Marius

Hi..

I need to add code to check if the compound that was choose is reach the maximum value then if it is already reach theirs a notification displayed that he already gain the maximum.

the problem is..I don't know how can I check if what the user choose before run the condition.

here is my code:

Code: [Select]
<?php
  $config['BASE_DIR']  = dirname(dirname(__FILE__));   
  $config['BASE_DIR'] = $config['BASE_DIR']. '\MES PROJECT';
   define('SMARTY_DIR', $config['BASE_DIR']. '/INCLUDE/smarty/libs/');


  require(SMARTY_DIR . 'Smarty.class.php');
  $smarty = new Smarty();

  $smarty = new Smarty();
  $smarty->template_dir = $config['BASE_DIR'].  '/smarty/templates';
  $smarty->config_dir   = $config['BASE_DIR'].  '/smarty/config';
  
  $smarty->cache_dir    = $config['BASE_DIR'].  '/INCLUDE/smarty/cache';
  $smarty->compile_dir  = $config['BASE_DIR'].  '/INCLUDE/smarty/templates_c';                                                       

// =================================================================================================================
$con= mysql_connect('localhost', 'root', '');
 if (!$con) {
    echo 'failed'; 
    die();
 }
 
mysql_select_db("mes", $con);
 
$hostAddr = $_SERVER['REMOTE_ADDR'];

 $terminal = $hostAddr; //<-enable this in server
//$terminal = $_POST['doThis'];  //<- disable this in server
$terminal = "192.168.1.101";
switch ($terminal) {
       case "192.168.1.101" : //<< enable this in server
       //case "1" :
       
          $smarty->assign('process', 'Rubber/Chemical Preparation');      
          $smarty->assign('termNo', 'Terminal 1');      
          
          $smarty->assign('text_name1','Compound Code');
          $smarty->assign('text_name2','Lot Traveler ID');
          $smarty->assign('text_name3','Kit Weight ');
          $smarty->assign('text_name4','Operator Code');
          
         [b]  $smarty->assign('compoundIndexValue', array('0',  'P28',  'P30',  'P32',  'P33',  'P35',  'P35M',  'P38',  'P40', 'P41',  'P42',  'P43', 'P46', 'P47', 'PXX', 'P35W'));[/b]           
           $smarty->assign('names', array('<Choose Code>',   'P28',  'P30',  'P32',  'P33',  'P35',  'P35M',  'P38',  'P40', 'P41',  'P42',  'P43', 'P46', 'P47', 'PXX', 'P35W'));

           $smarty->assign('weightIndexValue', array('0',  '60.145', '68.980', '65.381', '69.270', '49.360', '68.610', '54.880', '73.300', '51.973', '52.944', '57.627', '45.997', '69.196', '70.000', '55.000'));
           
           $smarty->assign('kitWeight', array('<Choose Weight>','60.145', '68.980', '65.381', '69.270', '49.360', '68.610', '54.880', '73.300', '51.973', '52.944', '57.627', '45.997', '69.196', '70.000', '55.000'));
       
          //Chemical weighing Process :  Terminal 1
          $smarty->display('header.tpl');  // common Header 
          $smarty->display('box_1.tpl');
          $smarty->display('footer.tpl');
          

       [b] $compound = mysql_real_escape_string($_POST['compoundIndexValue']);
        $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,
                P47, P47_max, P47_min
                FROM parameter_settings";
        $res_pcode = mysql_query($sql, $con);
        
        $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'];
        
           
        $sql = "SELECT PCODE, total FROM kanban_checker WHERE PCODE = '$compound' 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'>notify(P28 gain total maximum)</script>";   
        }
        else {
            echo '';
        }
        
       if($compound == $P30 && $total == $P30_max){
         echo "<script type='text/javascript'>notify(P30 gain total maximum)</script>";      
       }
        else{
        echo '';     
        }
        
        if($compound == $P32 && $total == $P32_max){
         echo "<script type='text/javascript'>notify(P32 gain total maximum)</script>";      
       }
        else{
        echo '';     
        }
        
        if($compound == $P33 && $total == $P33_max){
         echo "<script type='text/javascript'>notify(P33 gain total maximum)</script>";      
       }
        else{
        echo '';     
        }
        
        if($compound == $P35 && $total == $P35_max){
         echo "<script type='text/javascript'>notify(P35 gain total maximum)</script>";      
       }
        else{
        echo '';     
        }
        
        if($compound == $P35M && $total == $P35M_max){
         echo "<script type='text/javascript'>notify(P35M gain total maximum)</script>";      
       }
        else{
        echo '';     
        }
        
        if($compound == $P35W && $total == $P35W_max){
         echo "<script type='text/javascript'>notify(P35W gain total maximum)</script>";      
       }
        else{
        echo '';     
        }
        
        if($compound == $P38 && $total == $P38_max){
         echo "<script type='text/javascript'>notify(P38 gain total maximum)</script>";      
       }
        else{
        echo '';     
        }
        
        if($compound == $P41 && $total == $P41_max){
         echo "<script type='text/javascript'>notify(P41 gain total maximum)</script>";      
       }
        else{
        echo '';     
        }
        
        if($compound == $P42 && $total == $P42_max){
         echo "<script type='text/javascript'>notify(P42 gain total maximum)</script>";      
       }
        else{
        echo '';     
        }
        
        if($compound == $P43 && $total == $P43_max){
         echo "<script type='text/javascript'>notify(P43 gain total maximum)</script>";      
       }
        else{
        echo '';     
        }
        
        if($compound == $P46 && $total == $P46_max){
         echo "<script type='text/javascript'>notify(P46 gain total maximum)</script>";      
       }
        else{
        echo '';     
        }
        
        if($compound == $P47 && $total == $P47_max){
         echo "<script type='text/javascript'>notify(P47 gain total maximum)</script>";      
       }
        else{
        echo '';     
        }[/b]        
       break;
    
       case "192.168.1.102" : //<< enable this in server
       //case "2" :
    
          $smarty->assign('process', 'Compounding Process');
          $smarty->assign('termNo', 'Terminal 2');   
          $smarty->assign('text_name1','Lot Traveler ID');
          $smarty->assign('text_name2','Kit Weight');
          $smarty->assign('text_name3','Machine Code');
          $smarty->assign('text_name4','Operator Code');
   
          $smarty->assign('machineID', array('0', 'B1', 'B2', 'B3', 'K1', 'K2', 'OM1', 'OM2', 'OM3', 'OM4', 'OM5', 'OM6', 'OM7'));
          $smarty->assign('machineIDdisplay', array('<Choose Machine ID>', 'B1', 'B2', 'B3', 'K1', 'K2', 'OM1', 'OM2', 'OM3', 'OM4', 'OM5', 'OM6', 'OM7'));
         
          $smarty->display('header.tpl');  // common Header
          $smarty->display('box_2.tpl');
          $smarty->display('footer.tpl');
       break;
       
       case "192.168.1.103" : //<< enable this in server     
       //case "3" :
          $smarty->assign('process', 'Extrusion Process');
          $smarty->assign('termNo', 'Terminal 3');              
          $smarty->assign('text_name1','Lot Traveler ID');
          $smarty->assign('text_name2','Kit Weight');
          $smarty->assign('text_name3','Machine Code');
          $smarty->assign('text_name4','Operator Code');
         
          $smarty->assign('machineID', array('0', 'E1', 'E2', 'E3', 'E4', 'E5', 'E6'));
          $smarty->assign('machineIDdisplay', array('<Choose Machine ID>', 'E1', 'E2', 'E3', 'E4', 'E5', 'E6'));

          $smarty->display('header.tpl');  // common Header
          $smarty->display('box_2.tpl');
          $smarty->display('footer.tpl');
       break;
    
       case "192.168.1.104" : //<< enable this in server
       //case "4" :
          $smarty->assign('process', 'Half Shell Forming');
          $smarty->assign('termNo', 'Terminal 4');              

          $smarty->assign('text_name1','Lot Traveler ID');

          $smarty->assign('text_nameDG','New Lot ID');
          
          $smarty->assign('text_name2','Machine ID');
          $smarty->assign('text_name3','Output Qty.');
          $smarty->assign('text_name4','Reject Qty.');
          $smarty->assign('text_name5','Operator Code');
          
          $smarty->assign('id', array('0', 'NTG1', 'NTG2', 'NTG3', 'NTG4', 'GTG1', 'SQG1', 'PL1'));
          $smarty->assign('id_name', array('<Choose Machine ID>', 'NTG1', 'NTG2', 'NTG3', 'NTG4', 'GTG1', 'SQG1', 'PL1'));
          
          $smarty->display('header.tpl');  // common Header
          $smarty->display('box_3.tpl');
          $smarty->display('footer.tpl');
       break;
       
       case "192.168.1.105" : //<< enable this in server   
       //case "5" :
          
          $smarty->assign('process', 'Half Shell Deflashing'); //= to be implemented
          $smarty->assign('termNo', 'Terminal 5');              
          $smarty->assign('text_name1','Lot Traveler ID');
          $smarty->assign('text_name2','Machine ID');
          $smarty->assign('text_name3','Output Qty.');
          $smarty->assign('text_name4','Reject Qty.');
          $smarty->assign('text_name5','Operator Code');

$smarty->assign('id',      array('0', 'US DEF.1', 'US DEF.2', 'FRENCH DEF.1', 'FRENCH DEF.2', 'THAILAND DEF.1', 'THAILAND DEF.2', 'HANAU 45 DEF.'));
$smarty->assign('id_name', array('<Choose Machine ID>', 'US DEF.1', 'US DEF.2', 'FRENCH DEF.1', 'FRENCH DEF.2', 'THAILAND DEF.1', 'THAILAND DEF.2', 'HANAU 45 DEF.'));


          $smarty->display('header.tpl');  // common Header
          $smarty->display('box_3.tpl');
          $smarty->display('footer.tpl');
       break;

    
}
?>

My only purpose is to avoid adding data so i need to prompt if he already reach the maximum per compound.


Thank you so much

i have a dropdown menu that displays the options i have in a database.  i have this all working in mysqli as i didnt write this part on another website. but i am struggling to convert it back to mysql.

the original code is:

$query = "SELECT gallery_type_id, gallery_type_desc FROM gallery_type ORDER BY gallery_type_id";

/* run the query */
$result = $dbLink->query($query);

/* load the query's results into an array */
$i=1;
while($row=$result->fetch_assoc()){
$galleryTypes[$i] = $row;
$i++;
}  
$num_results = $result->num_rows;


<select name="gallery_type" id="gallery_type">
<option>Please Select an Album
<?php
for($i = 1; $i < $num_results+1; $i++) {
echo "<option value=\"" . $galleryTypes[$i]['gallery_type_id'] . "\">";
echo $galleryTypes[$i]['gallery_type_desc'];
echo "</option>\n";
}
?>

the code i have got so far:

$query1 = "SELECT id, question FROM securtiyq ORDER BY id";

/* run the query */
$result= mysql_query($query1); 
$row = mysql_fetch_array($result);

/* load the query's results into an array */
$i=1;
while ($row = mysql_fetch_assoc($result)) {
$galleryTypes[$i] = $row;
$i++;
}  

$num_results = mysql_num_rows($result);


<select name="gallery_type" id="gallery_type">
<option>Please Select A Security Question
<?php
for($i = 1; $i < $num_results+1; $i++) {
echo "<option value=\"" . $galleryTypes[$i]['id'] . "\">";
echo $galleryTypes[$i]['question'];
echo "</option>\n";
}
?>
</option>
</select>



the only problem is nothing from the database is displayed in the dropdown box. could someone point out where im going wrong

thanks in advance