PHP - Need Help With Form Select (drop Down Box)

I am using jquery .change function to perform an operation when a month is selected from a drop down menu. The change works but I am unable to update the value of the drop down menu with the updated month. My drop down shows the starting value as default even on change. Can anyone help. Following is the code snippet that does change and then the drop down menu form.

Code: [Select]
$("#monthName").change(function()
{
alert($("#monthName").val());
if ($("#post").val() == 1)
{
$("#monthselect").submit();
}
});
Code: [Select]
                   <form id="monthselect" action="<?=$_SERVER['PHP_SELF']?>" method="get">
                        <input id="post" type="hidden" name="post" value="1">
                        <label>SELECT MONTH</label>
                        <select id="monthName" name="monthName">
                                                     
                                <option value="January">January</option>
                                <option value="February">February</option>
                                <option value="March">March</option>
                                <option value="April">April</option>
                                <option value="May">May</option>
                                <option value="June">June</option>
                                <option value="July">July</option>
                                <option value="August">August</option>
                                <option value="September">September</option>
                                <option value="October">October</option>
                                <option value="November">November</option>
                                <option value="December">December</option>

                        </select>
                    </form>
Even after the change, January shows up by default even if I select say June or July. I tried something like following but did not work.

Code: [Select]
$("#monthName option[value=" + $("#monthName").val() +"]").attr("selected","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>
<?

the same page?

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 there,
i am relatively new to php, mysql, css etc but learning fast.
My problem is such;
i have a php file which is doing a SELECT mysql_query, WHILE results to strings, then ECHO the resulting rows to produce a list  formatted using  <table> and finally this <table> is inside a <form> which will POST the  changes back to the specific database.tble.row.

I wish to have a drop down menu within the <form><table> which will be populated from a separate database.table.

I have accomplished the drop down menu outside the <?php ?> tags inside  <form><table> which POSTS to a php file but my problem is to add the populating drop down menu inside <?php ?> an already ECHOing resulting rows from the sql query.

 i.e <?php blurb and stuff ?>
<form><table><tr><td>
<select name etc>
<?php
$result = mysql_query("SELECT * FROM tbl WHERE string = tble.rw ORDER BY column");
while($row=mysql_fetch_array($result)){
echo "<OPTION VALUE=".$row['column'].">".$row['column']."</OPTION>";
}
?>
</select> WORKS!!!!

but placing this inside

<?php $x =mysql_query[select] while {strings = conditions; echo ("<form><table><tr><td>
insert populated drop menu here
</td> etc ");
echo"";}?>

doesnt work and just leaves the select drop menu blank

Hoep you understand my problem.
I do not think i can attached the population WHILE loop to a string and just insert the string to the form but maybe i am wrong.

thanks in advance and if you go tthis far reading you must be on lots and lots of coffee

zark

I am trying to update a mysql table called AvItems with the value 'Torso' in the Equip "section?" I have been through the forums and cannot see anything to match.
I dont mind if the page looses the onsubmit() and has a button instead.
Though I would like to update the database and link back to the same page: There is a display that shows the item that is currently equiped, I have put this in to show it works, or doesn't as the case may be.
Hope I got the code /code right this time.

many thanks in advance

Andy Curtis

Code: [Select]
create table Items(
ItemID integer unsigned auto_increment primary key,
ItemName varchar(20) not null,
Type varchar(10),
UsedOn varchar(10),
);

create table AvItems(
AvItemID integer unsigned auto_increment primary key,
AvID integer unsigned,
ItemID integer unsigned,
Equip varchar(8));


<?php

$username="root";
$password="MyPassword";
$database="MyDataBase";
$AvName = "AndyJCurtis";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$AvAccR = mysql_query( " SELECT AvID FROM AvAcc WHERE AvName = '$AvName' " );
$AvID = mysql_result($AvAccR, 0, 'AvID');
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$Torso = mysql_query(" select ItemName from AvItems, Items where AvItems.itemID = Items.itemID AND AvItems.AvID = '$AvID' AND UsedON = 'Body' ");
$TorsoE = mysql_query(" select ItemName from AvItems, Items where AvItems.itemID = Items.itemID AND AvItems.AvID = '$AvID' And UsedON = 'Body' AND Equip = 'Body' ");
if(mysql_num_rows($TorsoE) != 0)
{
$TorsoItem = mysql_result($TorsoE ,0,"ItemName");
//mysql_close();
?>

<title></title>
<head></head>
<body>
<form action="http://localhost/CI/Equip2.php" method="post">

<table border=1>
<tbody>
<tr>
<td>Torso<BR>
<?PHP
echo "$TorsoItem <BR>";
?>
<select name="Torso" onchange="submit();" value =" Update">
<?PHP
while($TorsoRow = mysql_fetch_array($Torso))
{
echo "<option value=\"".$TorsoRow['ItemName']."\">".$TorsoRow['ItemName']."\n </option>";
}
?>
</select>
</td>
</tr>

////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
<?php
if($_POST['Torso'] == 'Update')
{
mysql_query("update AvItems set Equip = '' where Equip='Torso'") or die("cant update unequip"); 
mysql_query("update AvItems set Equip = 'Torso' where ItemID='{$_POST['ItemName']}'") or die("cant update equip"); 
}
?>
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

</tbody>
</table>
</.form>
</body>
</html>

I am simply trying to insert a value generated from an array in a while loop, but it seems the value is not global and I can't pass it as I like. I did some research on this, but could not find an answer that solved my issue...

Here is my select box code which is working perfect:

<select name="city">
<?php
$sql = "SELECT id, city_name FROM cities ".
"ORDER BY city_name";
$results_set = (mysqli_query($cxn, $sql)) or die("Was not able to produce the result set!");
while($row = mysqli_fetch_array($results_set)) {
echo "<option value=$row[id]>$row[city_name]</option>";
}
?>
</select>

Are any variables defined in a while loop global to the while loop only?

Here is my SQL which you can see my $row[id] being passed thru field city_id... The value is being generated as supposed to based on value like: value="1", value="2" etc.. for the select options for each city name. So the values are there... But I CANNOT get that numerical id to pass to the database when submitting my form.

Any ideas for a workaround to get this value passing as normal?

if (isset($_POST['addPosting'])) {
      $query = "INSERT INTO Postings (id, city_id, title, description) VALUES
('','$row[id]','$_POST[title]','$_POST[description]')";

Hello,

I have the following function

function make_agent_drop($dropname,$parent=''){

$agents = mysql_query("SELECT * FROM ad_category WHERE cat_status='1'  AND parent_id='".(is_numeric($parent)?$parent:"0")."'") or die(mysql_error());

$anum = mysql_num_rows($agents);

if($anum>0){

$agentdrop='<select style="width:150px; height:20px; margin-left:100px; font-size:11px;" name="'.$dropname.'" id="'.$dropname.'" class="text" '.(is_numeric($parent)?'':'onchange="update_subcatdrop($(this).val());').'">

<option value="0">Select a Category</option>';

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

$agentdrop.='<option value="'.$row['cat_id'].'">'.$row['cat_name'].'</option>';

}

$agentdrop.='</select>';

}else{

$agentdrop= 'No '.(is_numeric($parent)?'Sub':'').'Categories Found.';

} 

return $agentdrop;

 

;
}


I creates a drop down from database cats and sub cats..  I am trying to figure out how to add a submit button to dynamically appear when it displays the sub category...

Thanks!
Dan

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...

Hi I have tried the mysql forum but have had no joy with an answer to my problem so wondered if php would be better.

I want my users to be able to select from 5 different drop down lists where they can chose any combination from 1 up to all 5,  I have attached the front end.  These lists are being populated from mysql tables.

Code for the drop down lists is as follows
Code: [Select]
  <form action="horse-events-devon.php?url_countyid=<?php echo  urlencode ($url_countyid ['url_countyid'])  ; ?>&go" method="POST">
    <table id="searchtable">
      <tr>
        <th>Find By Discipline</th>
        <th>Find By Venue</th>
        <th>Find By Championship</th>
        <th>Find By Organiser</th>
        <th>Equine Association</th>
        <th>Submit Your Selections</th>
        </tr>
      <tr>
        <td><select name="dis_id">
                                    <?php 
                                        $upcomingdis = upcomingdis($url_countyid);
                                        $upcoming_dis_bycounty = mysql_fetch_assoc ($upcomingdis);
                                    ?>
                                    <?php 
                                    do { 
       ?>   <option value="<?php echo $upcoming_dis_bycounty ['dis_id']; ?>" >
<?php echo $upcoming_dis_bycounty ['dis_description']; ?></option>
<?php 
                                    } while ($upcoming_dis_bycounty = mysql_fetch_assoc ($upcomingdis)); 
                                    ?></select></td>
        <td><select name="ven_id">
                                    <?php 
                                        $upvenbycounty_set = upcoming_venevents_bycounty($url_countyid);
                                        $upcoming_ven_bycounty = mysql_fetch_assoc ($upvenbycounty_set);
                                    ?>
                                    <?php 
                                    do { 
       ?>   <option value="<?php echo $upcoming_ven_bycounty ['ven_id']; ?>" >
<?php echo $upcoming_ven_bycounty ['ven_name']; ?></option>
<?php 
                                    } while ($upcoming_ven_bycounty = mysql_fetch_assoc ($upvenbycounty_set)); 
                                    ?></select></td>
        <td><select name="champ_id">
                                    <?php 
                                        $championship_set = findchampionships();
                                        $champlist = mysql_fetch_assoc ($championship_set);
                                    ?>
                                    <?php 
do { 
?>   <option value="<?php echo $champlist ['champ_id']; ?>" >
<?php echo $champlist ['champ_description']; ?></option>
<?php 
} while ($champlist = mysql_fetch_assoc ($championship_set)); 
?></select></td>
        <td>
        <select name="org_id">
                        <?php 
                            $uporgbycounty_set = upcoming_organevents_bycounty($url_countyid);
                            $upcoming_org_bycounty = mysql_fetch_assoc ($uporgbycounty_set);
                        ?>
                        <?php 
                        do { 
                        ?>   <option value="<?php echo $upcoming_org_bycounty ['org_id']; ?>" ><?php echo $upcoming_org_bycounty ['org_name']; ?></option>
                        <?php 
                        } while ($upcoming_org_bycounty = mysql_fetch_assoc ($uporgbycounty_set)); 
                        ?></select>
       
        </td>
        <td><select name="ass_id">
                                    <?php
                                        $upassbycounty_set = upcoming_assevents_bycounty($url_countyid);
                                        $upcoming_assbycounty = mysql_fetch_assoc ($upassbycounty_set);
                                    ?>
                                    <?php 
                                    do { 
                                    ?>   <option value="<?php echo $upcoming_assbycounty ['ass_id']; ?>" >
<?php echo $upcoming_assbycounty ['ass_description']; ?></option>
                                    <?php 
                                    } while ($upcoming_assbycounty = mysql_fetch_assoc ($upassbycounty_set)); 
                                    ?></select></td>
      <td><input name="submit" type="submit" /><input name="countyid" type="hidden" value="<?php echo $url_countyid ['url_countyid']; ?>" /></td>
        </tr>
      </table>
  </form>
My search processing is as follows

Code: [Select]
  <?php
if (isset($_POST['submit'])){
if (isset($_GET['go'])){
$countyid = $_POST['countyid'];
$ven_id = $_POST['ven_id'];
$dis_id = $_POST['dis_id'];
$champ_id = $_POST['champ_id'];
$org_id = $_POST['org_id'];
$event_id = $row['event_id'];

$sql = "SELECT DATE_FORMAT (events.startdate, '%a, %d, %b') 
   AS stdate, events.event_id, events.title, events.ven_id, events.org_id,
   venue.county_id, venue.ven_id, eventdisciplines.event_id, eventdisciplines.dis_id, county.county_id, discipline.dis_id \n"
. "FROM events \n"
. "LEFT OUTER JOIN eventdisciplines \n"
. "ON events.event_id = eventdisciplines.event_id \n"
. "LEFT OUTER JOIN discipline \n"
. "ON eventdisciplines.dis_id = discipline.dis_id \n"
. "LEFT OUTER JOIN venue \n"
. "ON events.ven_id = venue.ven_id \n"
. "LEFT OUTER JOIN county \n"
. "ON venue.county_id = county.county_id \n"
. "WHERE events.ven_id = ({$ven_id} OR events.org_id = {$org_id})\n"
. "AND events.startdate > NOW()\n"
. "AND venue.county_id = {$countyid}  \n"
. "ORDER BY startdate ASC";

$result = mysql_query ($sql, $connection);
?>
How am I best to do this please?  my OR within the mysql does not work, should I not be doing this with php in the search processing?  someones help would really be appreciated, just to point me in the right direction.

[attachment deleted by admin]

Hello, first time poster..  I've looked the web over for a long time and can't figure this one out.

- Below is basic code that successfully checks MySQL for a match and displays result.  I was debugging and forced the "height" and "width" to be 24 and 36 to make sure that wasn't the problem.  That's good.. 
- I'd like to give the user ability to select width and height from a form.. and have it do an onchange this.form.submit so the form can be changing as fields are altered (thus the onchange interaction)
- In a normal coding environment I've done this numerous times with no "Page cannot be displayed" problems.  It would simply change one select-option value at a time til they get down the form and click submit...  but in WordPress I'm having trouble making even ONE single onchange work!
- I've implemented the plugins they offer which allows you to "copy+paste" your php code directly into their wysiwyg editor.  That works with basic tests like my first bullet point above.
- I've copied and pasted the wordpress url (including the little ?page_id=123) into the form "action" url... that didn't work...  tried forcing it into an <option value=""> tag.. didn't work.  I'm just not sure. 

I've obviously put xx's in place of private info..

Why does this form give me Page Cannot Be Displayed in WordPress every time?  It won't do anything no matter how simple.. using onchange..

Code..

$con = mysql_connect("xxxx.xxxxxxx.com","xxxxxx","xxxxx");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("xxxxxx", $con);
$myprodwidth=24;
$myprodheight=36;
$result = mysql_query("SELECT * FROM product_sizes WHERE prodwidth='$myprodwidth' and prodheight='$myprodheight'");
while($row = mysql_fetch_array($result))
  {
  echo $row['prodprice'];
  }
mysql_close($con);


<form method="post" action="">
<select name="myheight" onchange="this.form.submit();">
<option selected="selected" value="">select height</option>
<option value="xxxxxxxxx.com/wordpress/?page_id=199&height=36">36</option>
<option value="xxxxxxxxx.com/wordpress/?page_id=199&height=36">48</option>
</select>

Hi i am trying to change the query to sort by desc or asc I am using the switch method but the form is not calling the switch statment can someone help me out please?

this is the swicth script
Code: [Select]
switch ($sortby) {
    case "ASC":
        $args = array(
's' => $_GET['s'],
'post_type' => 'deals',
'orderby' => 'title',
'order' => 'ASC',
'paged' => get_query_var('paged')
);
    break;
    case "DESC":
                $args = array(
's' => $_GET['s'],
'post_type' => 'deals',
'orderby' => 'title',
'order' => 'DESC',
'paged' => get_query_var('paged')
);
        break;
}This is the form
Code: [Select]
<form name="myForm">
             <select id="sortby" >
                 <option value="ASC">ASC</option>
                 <option value="DESC">DESC</option>
            </select>
         </form>
I intend to use a onchange so that when depending on the option they select it will change the order?

Hello all , here is another problem of my project.

I need to create a textarea , drop down list and submit button .

At first , I can type whatever I want in the textarea , but for certain part I can just choose the word I want from drop down list and click submit , then the word will appear in the textarea as my next word .

But I have no idea how to make this works , is there any simple example for this function ?
Thanks for any help provided .

Hi, sorry for being a newbie, but I need help setting up a dynamic form.  The form will be a reservation type form.  I have a single table, which I will post below.  What I am looking to do is choose a month from a select box and then have it populate another select box with the available dates.

Here is my table info from mysql...
Code: [Select]
CREATE TABLE `daterange` (
  `RID` int(5) NOT NULL auto_increment,
  `DEND` date NOT NULL,
  `MONTH` varchar(50) NOT NULL,
  `DATE` varchar(50) NOT NULL,
  `SITE` varchar(50) NOT NULL,
  `PRICE` varchar(10) NOT NULL,
  `STATUS` varchar(1) NOT NULL default 'A',
  `FNAME` varchar(50) NOT NULL,
  `LNAME` varchar(50) NOT NULL,
  `ADDR1` varchar(50) NOT NULL,
  `ADDR2` varchar(50) NOT NULL,
  `CITY` varchar(50) NOT NULL,
  `STATE` varchar(2) NOT NULL,
  `ZIP` varchar(5) NOT NULL,
  `PHONE1` varchar(3) NOT NULL,
  `PHONE2` varchar(3) NOT NULL,
  `PHONE3` varchar(4) NOT NULL,
  `EMAIL` varchar(50) NOT NULL,
  PRIMARY KEY  (`RID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=83 ;
Here is a sample mysql dump...
Code: [Select]
INSERT INTO `daterange` VALUES(1, '2011-05-15', 'May 2011', '5/15-5/22/11', 'Carterville Pond/Adirondack', '$2625.00', 'N', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `daterange` VALUES(2, '2011-05-22', 'May 2011', '5/22-5/29/11', 'Carterville Pond/Adirondack', '$2625.00', 'A', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
INSERT INTO `daterange` VALUES(3, '2011-05-29', 'May 2011', '5/29-6/5/11', 'Carterville Pond/Adirondack', '$2625.00', 'A', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
Finally, here is a php form that I started to develop but it only has a single select box, which works but I wanted another select box that will filter the list down a little...
Code: [Select]
<?
// script to display all the Available Reservations in the daterange table

// connection information
$hostName = "my_host";
$userName = "my_user";
$password = "my_pass";
$dbName = "my_db";

// make connection to database
mysql_connect($hostName, $userName, $password) or die("Unable to connect to host $hostName");

mysql_select_db($dbName) or die("Unable to select database $dbName");

// Select all the fields in all the records of the daterange table
$query = "SELECT *
          FROM daterange
  WHERE DEND > DATE(NOW())
  AND STATUS='A'
          ORDER BY RID, DATE, SITE";
 
$result = mysql_query($query);

// 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 Reservation Date:</b>
<form action=\"test.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><label>Payment Method: <select name=\"PM\">
    <option value=\"\">Choose One</option>
<option value=\"Visa\">Visa</option>
<option value=\"Mastercard\">Mastercard</option>
<option value=\"Discover\">Discover</option>";

print "</select><p align=left><label>Credit Card Number: <input type=\"text\" name=\"C1\" size=\"4\" maxlength=\"4\" tabindex=\"12\"";
print "<label> <input type=\"text\" name=\"C2\" size=\"4\" maxlength=\"4\" tabindex=\"13\"";
print "<label> <input type=\"text\" name=\"C3\" size=\"4\" maxlength=\"4\" tabindex=\"14\"";
print "<label> <input type=\"text\" name=\"C4\" size=\"4\" maxlength=\"4\" tabindex=\"15\"<br>";

print "<p align=left><label>Expiration Month: <select name=\"EXM\">
    <option value=\"\">Choose One</option>
<option value=\"January\">January</option>
<option value=\"February\">February</option>
<option value=\"March\">March</option>
<option value=\"April\">April</option>
<option value=\"May\">May</option>
<option value=\"June\">June</option>
<option value=\"July\">July</option>
<option value=\"August\">August</option>
<option value=\"September\">September</option>
<option value=\"October\">October</option>
<option value=\"November\">November</option>
<option value=\"December\">December</option>";

print "</select><p align=left><label> Expiration Year: <select name=\"EXY\">
    <option value=\"\">Choose One</option>
<option value=\"2011\">2011</option>
<option value=\"2012\">2012</option>
<option value=\"2013\">2013</option>
<option value=\"2014\">2014</option>
<option value=\"2015\">2015</option>
<option value=\"2016\">2016</option>
<option value=\"2017\">2017</option>
<option value=\"2018\">2018</option>
<option value=\"2019\">2019</option>
<option value=\"2020\">2020</option>";

print "</select><p align=left><label>Security Code (3 or 4 digits): <input type=\"text\" name=\"CSC\" size=\"4\" maxlength=\"4\" tabindex=\"16\"<br>";


print "<p align=left><input type=\"submit\" value=\"Book Now!\"
    name=\"submit\"></form>";

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


// Close the database connection
mysql_close();

?>
Sorry this is so long, any help would be appreciated......

-Bob

Hello everyone and thank you for taking the time to read this. I am very new to coding and I am helping a friend with a website. I'm trying to create a form with a <select> dropdown and filling the options with items from a database, there are very man items so I'm not sure 100% how to go about this, I have some code but I know it's wrong I'm just looking for a nudge in the right direction, any help is appreciated the code can be found below:


Code: [Select]
<div style="float:left;">
                                            <select>
                                            $team = $sql->query("SELECT * FROM teams WHERE arenaid ='$platid'");
                                                <option value="<?echo $teams>"></option>
                                            </select>
                                        </div>

Again, thank you for taking the time to read this and thank you also for any help you can provide.