Re: mysql and php

If that is the case, then you would want to use: function prdbopts($name,$size,$table,$field,$sel) { $res = mysql_db_query("database_name","SELECT DISTINCT $field FROM $table ORDER BY $field"); if(mysql_errno()) { $err = mysql_error(); echo __FILE__ . " - " . __LINE__ . ": $err<BR>\n"; } if($size == 0) echo "<SELECT NAME=\"$name\">\n"; else echo "<SELECT NAME=\"$name\" SIZE=\"$size\">\n"; while($row = mysql_fetch_array($res)) { echo "<OPTION VALUE=\"$row[$field]\""; if($row[$field] == $sel) echo " SELECTED"; echo ">\n"; echo "$row[$field]</OPTION>"; } echo "</SELECT>\n"; } Chris Hughes wrote: > I may have misunderstood the question, I was thinking that youw wanted to > know which one they selected by the values in the DB. > Sorry, > Chris > > -----Original Message----- > From: codyc@cisco.com [mailto:codyc@cisco.com] > Sent: Monday, July 17, 2000 11:20 AM > To: Wesley Choate > Cc: php-db@lists.php.net > Subject: Re: [PHP-DB] mysql and php > > One of the beautiful things about PHP is that it automatically puts all form > variables for a POST form in HTTP_POST_VARS which is an associative array. > Of > course, this relies on 'enable track vars' being enabled in PHP config, > which > by default I believe it is. > so, lets say you have two form variables in your script, one is the name of > the > fruit producer, like this: > > <input type=text name=producer size=20> > > and then lets say you have a select menu with three fruits in it, like this: > > <SELECT name=fruits> > <OPTION VALUE="apple">Apple</OPTION> > <OPTION VALUE="orange">Orange</OPTION> > <OPTION VALUE="peach">Peach</OPTION> > > so if the user types in a name of the producer and selects a fruit and > submits > this form, then assuming you used POST as your form method (PHP also > supports > GET and hence uses HTTP_GET_VARS) > then the two variables will be set: > > HTTP_POST_VARS[producer] would be set to what the user typed in > HTTP_POST_VARS[fruits] would be either apple,orange or fruit. > > So you can just check for that. I have provided a function, you pass it the > name of select variable, in this fruits, and you have two arrays, one with > the > values and one with the text to show in the menu. > So I could have an array like this: > > $fruits = array("apple", "peach", "orange"); > > and then in the above HTML you would call the function like this: > > propts("fruits", 0, $fruits, $fruits, ""); > > function propts ($name,$size,$vals,$opts,$sel) { > if(size == 0) > echo "<SELECT NAME=\"$name\">\n"; > else > echo "<SELECT NAME=\"$name\" > SIZE=\"$size\">\n"; > for ($i=0;$vals[$i];$i++) { > echo "<OPTION VALUE=\"$vals[$i]\""; > if($sel == $vals[$i]) > echo " SELECTED"; > echo ">$opts[$i]</OPTION>\n"; > } > echo "</SELECT>\n"; > } > > If you wanted to use numbers as your fruits in the database, then create > another array that corresponds to the first and put that array name in place > of > $vals array in the function. > (in my example, since I wanted the fruit name to be both the value and the > text > in html, I just gave it to the function twice). Notice that if you want a > particular option to be selected by default you pass that name to the > function > as the last argument. > > Good luck > /Cody Caughlan > > Wesley Choate wrote: > > > Could you show us the code you are using..the html form code and the > > actually php program that the forms action refers to?? > > > > > -----Original Message----- > > > From: Joanna [SMTP:joanna@blackhole.evilgeeks.com] > > > Sent: Monday, July 17, 2000 12:02 PM > > > To: php-db@lists.php.net > > > Subject: [PHP-DB] mysql and php > > > > > > > > > I have a db with a simple table. One of the fields in the tables are > > > fruit. I created a HTML SELECT FORM to select what kind of > > > fruit,apples,peaches,ect... I would like to input the kind of fruit into > > > the table. I have even tried using php ifelse statements to assign > > > integers instead of the actual fruit name and I still can't figure it > > > out. Can someone please help. > > > The thing I can't figure out is how to know which of the choices have > been > > > selected from the form. > > > > > > thanks > > > > > > > > > > > > -- > > > PHP Database Mailing List (http://www.php.net/) > > > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > > > For additional commands, e-mail: php-db-help@lists.php.net > > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > > For additional commands, e-mail: php-db-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net