 |  |  |  |  |  |  |  |
storing the selected value of a drop-down list
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
Thread Solved |
•
•
Join Date: Oct 2007
Posts: 260
Reputation: 
Solved Threads: 2
Posting Whiz in Training
What I'd like to do is store the "selected" value of the drop down box in a DB. At the moment the selected value for the drop down list is pulled from the DB. Now what I want to happen is if I don't want to change that specific option from the drop-down list then the variable gets put back into the DB. At the moment if I don't select anything then my the value that is put back into the DB is 0.
My code is as follows:
The drop-down list
And this is the php that updates the DB
Any help would be greatly appreciated.
P.S. If I haven't explained myself well enough then here's an example situation:
I select 05 from startDay and hit submit. The page refreshes and 5 is displayed in the startDay drop-down list. Now I don't want to change startDay but I want to change other fields in the form so I do so and hit submit. What I have changed gets sent to the DB and 0 gets sent to the DB for startDay. What should be happening is it should be sending 5 to the DB.
My code is as follows:
The drop-down list
php Syntax (Toggle Plain Text)
And this is the php that updates the DB
php Syntax (Toggle Plain Text)
Any help would be greatly appreciated.
P.S. If I haven't explained myself well enough then here's an example situation:
I select 05 from startDay and hit submit. The page refreshes and 5 is displayed in the startDay drop-down list. Now I don't want to change startDay but I want to change other fields in the form so I do so and hit submit. What I have changed gets sent to the DB and 0 gets sent to the DB for startDay. What should be happening is it should be sending 5 to the DB.
Last edited by Venom Rush; Nov 13th, 2007 at 4:55 am.
The first problem I can see if the options have no values, so there for they can not post anything?
Not sure if that will sort it but worth a try
•
•
•
•
<option value="4">4</option>
•
•
Join Date: Oct 2007
Posts: 260
Reputation:
Solved Threads: 2
Posting Whiz in Training
•
•
•
•
Originally Posted by ezb 
The first problem I can see if the options have no values, so there for they can not post anything?
Not sure if that will sort it but worth a try
My problem is that <option selected='selected'>$row[0]</option> isn't being posted to the DB. And adding a value to it doesn't help. 0 still gets processed.
•
•
Join Date: Oct 2007
Posts: 260
Reputation:
Solved Threads: 2
Posting Whiz in Training
I've come up with an idea. What I could do is use an if statement in the code that posts the variales to the DB. Something along the lines of the following:
I know this won't work. I have no idea how to point to the form using php as I'm somewhat new to it.
Could anyone help me with this please.
php Syntax (Toggle Plain Text)
I know this won't work. I have no idea how to point to the form using php as I'm somewhat new to it.
Could anyone help me with this please.
•
•
Join Date: Aug 2007
Posts: 52
Reputation:
Solved Threads: 5
Junior Poster in Training
I have built a dynamic select box for something like this.
Here I populate the select options with information from a table:
(I also created the "sticky" to hold the users input upon error checking
Then all I do is place the value in the insert statement
Here I populate the select options with information from a table:
(I also created the "sticky" to hold the users input upon error checking
<?php
$result = mysql_query("SELECT * FROM facilities ORDER BY Street1 ASC") or
die(mysql_error());
$sticky= '';
if (isset($_POST['facility']))
$sticky = ($_POST['facility']);
$pulldown1 = '<select name="facility">';
$pulldown1 .= '<option></option>';
while($row = mysql_fetch_array($result))
{
if($row['FacilitiesID'] == $sticky) {
$pulldown1 .= "<option selected value=\"{$row['FacilitiesID']}\">
{$row['Street1']} -
{$row['City']} -
{$row['Name']}
</option>\n";
} else {
$pulldown1 .= "<option value=\"{$row['FacilitiesID']}\">
{$row['Street1']} -
{$row['City']} -
{$row['Name']}
</option>\n";
}
}
$pulldown1 .= '</select>';
echo $pulldown1;
?>
Then all I do is place the value in the insert statement
I keep hitting "escape", but I'm still here!!!!
:}
:}
•
•
Join Date: Oct 2007
Posts: 260
Reputation:
Solved Threads: 2
Posting Whiz in Training
Thanks for your response JeniF.
Managed to sort my problem out with the following code:
Managed to sort my problem out with the following code:
php Syntax (Toggle Plain Text)
i know this thread if quite old, but i just wanted to say thanks for lingering web pages, i almost tore my hair out trying to figure this out and literally just as I was about to call it a day, found quite the easy solution, so thanks JeniF and Venom Rush and Daniweb. i created an account just for this today. THANKS!
•
•
Join Date: Oct 2007
Posts: 260
Reputation:
Solved Threads: 2
Posting Whiz in Training
•
•
•
•
Originally Posted by mad0
i know this thread if quite old, but i just wanted to say thanks for lingering web pages, i almost tore my hair out trying to figure this out and literally just as I was about to call it a day, found quite the easy solution, so thanks JeniF and Venom Rush and Daniweb. i created an account just for this today. THANKS!
This user has a spatula. We don't know why, but we are afraid.
 |
Similar Threads
- drop down list selected index change doesn't work in mozilla (ASP.NET)
- drop down list question. (ASP.NET)
- Populate One Drop Down List From Another (ASP.NET)
- Populating a Drop-down List (PHP)
- view employee info for the employee selected from the drop down list (PHP)
- Data Binding to a Drop Down List? (ASP.NET)
- Passing a drop down list item's value (HTML and CSS)
- Blank drop list (PHP)
Other Threads in the PHP Forum
- Previous Thread: MySQL - Some Records Not Deleting
- Next Thread: php httprequest class and session
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Latest PHP Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
# 5.2.10 ajax apache api array beginner binary broken cakephp checkbox class clean clients cms code cron curl database date display dissertation dynamic echo echo$_get[x]changingitintovariable... email error file files folder form forms function functions google href htaccess html image images include insert integration ip java javascript joomla ldap legislation limit link local login loop mail memberships menu mlm multiple multipletables mysql mysqlquery oop open paypal pdf persist php problem query radio random recursion regex remote rss script search server sessions sms soap sockets source space spam sql syntax system table tutorial update upload url validator variable video web xml youtube
