Re: mysql and php

In your form tag, for the action part, done you mean $PHP_SELF? /Cody Lars Wilhelmsen wrote: > Hi Joanna. > > I wouldn't done it this way, but: > <? > if ( $go ) > { > mysql_connect( "host", "user", "password" ); > mysql_select_db( "fruitdb" ); > > $query_id = mysql_query("INSERT INTO FruitTable(fruit) > VALUES('$fruit')") > or die( "Could not insert record, dying like a dog..." ); > ?> > <html> > <form action=<?= $PHP_THIS ?> method="post"> > <select name="fruit"> > <option name="apple">Apple</option> > <option name="banana">Banana</option> > <option name="pear">Pear</option> > </select> > <input type="submit" name="go" value="Go!"> > </form> > </html> > > # > # sql file > # > CREATE DATABASE fruitdb; > > CREATE TABLE FruitTable( > id int not null auto_increment primary key, > fruit varchar(20), > other fields... > .... > ); > > It would be better if you create a table in your db with. > > 1 Apple "apple description" > 2 Banana "banana description" > 3 ... > > And generated the <select></select> tag from it. > > if you got the table def: > > create table fruittable( > id int not null auto_increment primary key, > name varchar(30), > descr varchar(50)); > > You could genererate the <select></select> box with: > > openDB(); > > $query_id = mysql_query( "SELECT * FROM fruitable" ); > > echo "<select name=\"fruitchoices\">"; > for ($i = 0; $i < mysql_num_rows( $query_id ); $i++) > { > $row = mysql_fetch_array( $query_id ); > > $id = $row["id"]; > $name = $row["name"]; > > echo "<input name="$id">$name</input>"; > } > echo "</select>"; > > then you could check for fruitchoices=1...n where the number would > be the corresponding row in your fruittable - which you again could > use for insertion into other tables (phew! ) > > ok.. Regards, > > -larsw- > > -- > Lars Wilhelmsen <lw@ez.no>, developer @ eZ systems <www.ez.no> > -----Original Message----- > From: Joanna [mailto:joanna@blackhole.evilgeeks.com] > Sent: 17. juli 2000 19:02 > 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