DropDown Liste Eintrag dynamisch vorselektieren

Haraldos · 2005-11-14 10:47:40

Haraldos
Member
Offline

Herkunft: Aachen
Registrierungsdatum: 2005-10-09
Beiträge: 43

Thema: DropDown Liste Eintrag dynamisch vorselektieren

Hallo,
ich häng grad fest ode rbesser: ich häng mal wieder

Ein Formular besitzt unter anderem eine Drop Down Liste. Im Falle einer fehlenden Eingabe wird der User direkt wieder auf das Formular geleitet. Dabei sollen alle gemachten Eingaben behalten werden. Das funktioniert bei Textfeldern einwandfrei, habe nur keine Idee wie ich das bei der Drop Down Liste machen soll:

<?php
$sqlabfrage = "SELECT cat_name FROM glp_cat ORDER BY cat_name ASC";
$ergebnis1 = mysql_query($sqlabfrage);

echo"<select name=\"cat1\">";
while($cat1 = mysql_fetch_array($ergebnis1))
                      {
                      echo "<option>".$cat1['cat_name']."</option>";
                      }
echo"</select>";
?>

Habe mich mal auf den wesentlichen Teil beschränkt. Jemand ne Idee?

Danke und Gruß!

Tobi · 2005-11-14 11:29:10

Tobi
Member
Offline

Herkunft: Samos, Greece
Registrierungsdatum: 2005-09-11
Beiträge: 396

Re: DropDown Liste Eintrag dynamisch vorselektieren

Dazu solltest Du das Selectmenu in einer Variablen speichern.
Wenn eine Formulareingabe fehlschlaegt, kannst Du dann den entsprechenden Eintrag ersetzen
Etwa so:

while($cat1 = mysql_fetch_array($ergebnis1))
                      {
                      $selecter .= "<option>".$cat1['cat_name']."</option>\n";
                      }
$selecter = ereg_replace("<option>" . $_REQUEST['BLAH'], "<option selected>" . $_REQUEST['BLAH'], $selecter);

und dann im HTML

<select name="BLAH"><? echo $selecter ?></select>

Wenn nun jemand zurueckgeworfen wird, existiert ja seine EIngabe von "BLAH" im $_REQUEST Array, und der Eintrag wird ersetzt.

Gaaanz einfach

Haraldos · 2005-11-15 02:59:17

Haraldos
Member
Offline

Herkunft: Aachen
Registrierungsdatum: 2005-10-09
Beiträge: 43

Re: DropDown Liste Eintrag dynamisch vorselektieren

hmm, meinem Verständnis nach sollte ich so aber nur noch eine Angabe in der DropDown Liste haben weil die Ausgabe der options nicht in der while Schleife steht...

Hab es aber noch nicht probiert, werde das später trotzdem mal testen

Tobi · 2005-11-15 05:58:29

Tobi
Member
Offline

Herkunft: Samos, Greece
Registrierungsdatum: 2005-09-11
Beiträge: 396

Re: DropDown Liste Eintrag dynamisch vorselektieren

Doch, die Options werden in der while-Schleife per
$selecter .= angehaengt und zum Schluss wird ein vorhandener Uebergabewert auf default gesetzt.
Ich mach das immer so.

Haraldos · 2005-11-15 15:39:16

Haraldos
Member
Offline

Herkunft: Aachen
Registrierungsdatum: 2005-10-09
Beiträge: 43

Re: DropDown Liste Eintrag dynamisch vorselektieren

Stimmt, geht
Ich hab zwar noch immer keine rechte Ahnung wieso, aber das bekomme ich auch noch raus...

Danke!

abendrise · 2011-05-17 10:00:21

abendrise
New member
Offline

Registrierungsdatum: 2011-05-17
Beiträge: 5

Re: DropDown Liste Eintrag dynamisch vorselektieren

also der code sieht jetzt so aus und es kommt keine fehlermeldung mehr.
obwohl ich nur die "with" zeile eingefügt habe.

Private Sub CommandButton1_Click()
Dim ar As Variant, i As Long
Dim objDic As Object, strKey As String, varKey As Variant
Dim intMax As Integer, intCount As Integer, strMax As String

Set objDic = CreateObject("scripting.dictionary")
With Worksheets("Tabelle2")
ar = .Range(.Range("F2"), .Range("F1").End(xlDown))
End With
For i = 1 To UBound(ar)
strKey = LCase(Trim(ar(i, 1)))
If strKey <> "ok" Then objDic(strKey) = objDic(strKey) + 1
Next

intMax = 0
For Each varKey In objDic
intCount = objDic(varKey)
If intCount > intMax Then
intMax = intCount
strMax = varKey
End If
Next
MsgBox intMax, , strMax
objDic.RemoveAll
Set objDic = Nothing
End Sub

abendmode

Ugg Boots Sale · 2011-11-10 06:56:39

Ugg Boots Sale
New member
Offline

Registrierungsdatum: 2011-11-03
Beiträge: 1

Re: DropDown Liste Eintrag dynamisch vorselektieren

uec
<a href=http://www.boottools.com/>Ugg Boots free shippping</a>
taq
Ugg Boots free shippping
jxo
http://www.boottools.com

pylxwzhj · 2011-12-16 09:13:17

pylxwzhj
Member
Offline

Registrierungsdatum: 2011-12-15
Beiträge: 113

Re: DropDown Liste Eintrag dynamisch vorselektieren

WHAT'S----456own peopleCoach Outlet,
just opened a Twitter aCoach Outlet
ccount, and in the pastChanel Handbags
week they have been wrCoach Outlet
iting up a storm, braggCoach Outlet
ing about recent attackChanel Bags
s and taunting their enCoach Factory Outlet
emies.“Your inexperieCoach Outlet Online
ced boys flee from confrCoach Outlet
ontation & flinch in thCoach Outlet
e face of death,” theCoach Outlet Online
Shabab wrote in a post Louis Vuitton Bags
to the Kenyan Army.iCoach Factory Outlet
s an odd, almost downriLouis Vuitton Bags
ght hypocritical move fCoach Factory Store
rom brutal militants inCoach Outlet
one of world’s mosCoach Factory Outlet
roken-down countrie,Coach Outlet Store
where millions of peCoach Factory Outlet
e do not have enough foCoach Outlet
od to eat, let alone aChanel Bags
laptop. The Shabab havChanel Bags
e vehemently rejected WLouis Vuitton
estern practices — banCoach Factory Store
ning Western music, movChanel Handbags
ies, haircuts and bras,Coach Outlet
and even blocking WestChanel Bags
ern aid for famine vicLouis Vuitton
tims, all in the nameCoach Factory Online
oBut terrorism expertsCoach Outlet
say that Twitter terroChanel Bags
rism is part of an emeCoach Outlet
rging trend and thatLouis Vuitton Bags
several other QaedaCoach Factory Outlet
anchises — a few yearChanel Bags
s ago the Shabab pledgCoach Factory

canada_goose_jakker

canada_goose_jakker
New member
Offline

Registrierungsdatum: Gestern
Beiträge: 4

Re: DropDown Liste Eintrag dynamisch vorselektieren

With every new canada goose jakkeriPhone canada goose sale release, there is

a wide range canada goose online of differences Canada Goose Jakke between

the current Canada Goose Coats and previous Canada Goose Jackets iPhone

versions. woolrich outlet This woolrich arctic parka is

no different woolrich sale with woolrich onlinethe new

iPhone 5 and hogan scarpe the hogan outletprevious Apple phone.

Not only is the hardware faster, allowing hogan shoes for better Internet speeds and graphic processing, but a

number of woolrich parka in-system woolrich arctic parka

updates make the iPhone 5 woolrich online shop the best iPhone produced by Apple yet.
To start,nike free there is nike free run an integrated

notification system. Before,nike free 3.0 every time an application required updating, a text was received or a

download nike free 5.0 completed, each application had a small red dot or number placed in its corner on the main

display screen.nike free 7.0 This is tods shoes different with

the new Apple phone, as a feature known as Notification tods outlet Center now stores all notifications in one single

location,tods womens shoes giving you tods mens shoes the ability to

see all updates in a single Snapback Hats location, instead of selecting each application individually.
The camera New Era Snapbacks feature Snapback Caps is different

on the new Apple baseball caps device.baseball hats Not

only is the NY caps resolution MLB hats of higher quality,

but the way you take pictures has also changed. With the old phone and all previous versions, you had to unlock the display screen, select the camera icon, aim the

camera and press the circular button at the bottom of the device. With the iPhone 5, there is a camera feature right on the lock screen, giving you instant access to

the camera for moments that new era caps can't wait. Then, instead of pressing the circular button, you hold the

camera sideways and press the "Volume Up"Woolrich Arctic Parka button, so it feels more like an actual camera than

a phone.

One of the highlights
Woolrich Jacken of the new Apple phone is the PC Free feature. This allows you to sync your

iPhone to a computer, without the aid of
Woolrich Outlet a USB cable or cord, as it is now completely wireless.
Internal Smart Phone Security
? Look for Apps
Keep in mind that downloading Chanel Sunglasses is, arguably, one of the most important ways to protect your

smartphone. Install apps from trusted Chanel Glasses sources and don't download suggested apps.

? Built in Security Functions
Know that attackers may look for security loopholes Chanel Eyeglasses through Bluetooth connections to access or

download information on your device. To Canada Goose Outlet avoid unauthorized access, disable Bluetooth when you are not

using it. Lock your keypad, too.

? Invest in Software: Using security software is one Canada Goose Parka of the smartest ways to protect your smartphone.

Just like your computer needs anti-virus and anti-spyware protection, so does your smartphone. Security software from companies like McAfee, Norton, BullGuard,

BitDefender, and others offer security scanning, remote control over your phone, and data back-up and recovery services.

DropDown Liste Eintrag dynamisch vorselektieren

Pun Tags

Beiträge [ 9 ]

1 Thema von Haraldos 2005-11-14 10:47:40

Thema: DropDown Liste Eintrag dynamisch vorselektieren

2 Antwort von Tobi 2005-11-14 11:29:10

Re: DropDown Liste Eintrag dynamisch vorselektieren

3 Antwort von Haraldos 2005-11-15 02:59:17

Re: DropDown Liste Eintrag dynamisch vorselektieren

4 Antwort von Tobi 2005-11-15 05:58:29

Re: DropDown Liste Eintrag dynamisch vorselektieren

5 Antwort von Haraldos 2005-11-15 15:39:16

Re: DropDown Liste Eintrag dynamisch vorselektieren

6 Antwort von abendrise 2011-05-17 10:00:21

Re: DropDown Liste Eintrag dynamisch vorselektieren

7 Antwort von Ugg Boots Sale 2011-11-10 06:56:39

Re: DropDown Liste Eintrag dynamisch vorselektieren

8 Antwort von pylxwzhj 2011-12-16 09:13:17

Re: DropDown Liste Eintrag dynamisch vorselektieren

9 Antwort von canada_goose_jakker Gestern 04:25:08

Re: DropDown Liste Eintrag dynamisch vorselektieren